Manikandan Thiagarajan
asked on
connection pool coding
Could you give me a simple connection pool codin in weblogic server 8.1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>JDBC API to communicate with the driver.
could you give me a sample api code for that
could you give me a sample api code for that
Standard JDBC is simple:
Class.forName ( driverClassName ) ;
Connection con = DriverManager.getConnectio n () ;
Statement s = con.createStatement () ;
ResultSet rs = s.executeQuery ( "your SQL query" ) ;
while ( rs.next () )
{
// get the data using rs.getString ( "column name" ) ;
}
Class.forName ( driverClassName ) ;
Connection con = DriverManager.getConnectio
Statement s = con.createStatement () ;
ResultSet rs = s.executeQuery ( "your SQL query" ) ;
while ( rs.next () )
{
// get the data using rs.getString ( "column name" ) ;
}
ASKER
tht code i know already.
if any specific connection pool coding apart from that
if any specific connection pool coding apart from that
If the driver handles connection-pooling - no.
ASKER
>>Class.forName ( driverClassName ) ;
what i could specify in driver class name if my database is db2
what i could specify in driver class name if my database is db2
I think its "COM.ibm.db2.jdbc.app.DB2D river"
http://edocs.bea.com/wls/docs81/jdbc/programming.html