This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB2 Pool Data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 Pool Data" Watch "DB2 Pool Data" New topic

DB2 Pool Data

Vikram Anand

Joined: May 17, 2002
Posts: 10
I want to use the pool data in Db2
Oracle gives the code as simple as
* A simple Pooled Connection Sample
import java.sql.*;
import javax.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.pool.*;
class PooledConnection1
public static void main (String args [])
throws SQLException
// Create a OracleConnectionPoolDataSource instance
OracleConnectionPoolDataSource ocpds =
new OracleConnectionPoolDataSource();
// Set connection parameters
ocpds.setURL("jdbc racle ci8:@");
// Create a pooled connection
PooledConnection pc = ocpds.getPooledConnection();
// Get a Logical connection
Connection conn = pc.getConnection();
// Create a Statement
Statement stmt = conn.createStatement ();
// Select the ENAME column from the EMP table
ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
// Iterate through the result and print the employee names
while ( ())
System.out.println (rset.getString (1));
// Close the RseultSet
rset = null;
// Close the Statement
stmt = null;
// Close the logical connection
conn = null;
// Close the pooled connection
pc = null;

can any one help me for DB2.
wood burning stoves
subject: DB2 Pool Data
Similar Threads
JDBC and Oracle Host
Pooling DB2 connection
Oracle Connection Pooling
offtopic for cert but related to java basics
Oracle JDBC connection in a servlet