Link to home
Start Free TrialLog in
Avatar of Manikandan Thiagarajan
Manikandan ThiagarajanFlag for India

asked on

connection pool coding

Could you give me a simple connection pool codin in weblogic server 8.1
ASKER CERTIFIED SOLUTION
Avatar of Mayank S
Mayank S
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
In any case, this has Weblogic 8.1 specific connection pooling stuff:

http://edocs.bea.com/wls/docs81/jdbc/programming.html
Avatar of Manikandan Thiagarajan

ASKER

>>JDBC API to communicate with the driver.

could you give me a sample api code for that
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" ) ;
}
tht code i know already.

if any specific connection pool coding apart from that
If the driver handles connection-pooling - no.
>>Class.forName ( driverClassName ) ;

what i could specify in driver class name if my database is db2
I think its "COM.ibm.db2.jdbc.app.DB2Driver"