File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
I agree. Here's the link:
subject: DB2 Pool Data
It's not a secret anymore!