?
Solved

connection pool coding

Posted on 2006-05-02
8
Medium Priority
?
231 Views
Last Modified: 2010-03-31
Could you give me a simple connection pool codin in weblogic server 8.1
0
Comment
  • 5
  • 3
8 Comments
 
LVL 30

Accepted Solution

by:
Mayank S earned 400 total points
ID: 16593481
The connection pooling would typically be handled by the driver, I guess. You don't need to do connection-pool coding. You will use normal JDBC API to communicate with the driver.
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 16593494
In any case, this has Weblogic 8.1 specific connection pooling stuff:

http://edocs.bea.com/wls/docs81/jdbc/programming.html
0
 
LVL 9

Author Comment

by:Manikandan Thiagarajan
ID: 16593609
>>JDBC API to communicate with the driver.

could you give me a sample api code for that
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 30

Expert Comment

by:Mayank S
ID: 16593637
Standard JDBC is simple:

Class.forName ( driverClassName ) ;
Connection con = DriverManager.getConnection () ;
Statement s = con.createStatement () ;
ResultSet rs = s.executeQuery ( "your SQL query" ) ;

while ( rs.next () )
{
  // get the data using rs.getString ( "column name" ) ;
}
0
 
LVL 9

Author Comment

by:Manikandan Thiagarajan
ID: 16593974
tht code i know already.

if any specific connection pool coding apart from that
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 16594037
If the driver handles connection-pooling - no.
0
 
LVL 9

Author Comment

by:Manikandan Thiagarajan
ID: 16594140
>>Class.forName ( driverClassName ) ;

what i could specify in driver class name if my database is db2
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 16594160
I think its "COM.ibm.db2.jdbc.app.DB2Driver"
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Suggested Courses
Course of the Month13 days, 22 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question