This is a sample from a class using Oracle 9iAS connection pool.
import java.util.*;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
/**
* This class provides the DB Access.
* @see ConnectionPool
*/
public class DBAccess {
private static
String theDataSource = "jdbc/OracleCoreDS";
private static DataSource myDataSource = null;
private static java.sql.Connection myConn = null;
private static String queryStatus="good";
public DBAccess()
{
}
public static Connection getConnection()
{
try {
InitialContext ctx = new InitialContext();
myDataSource = (DataSource)ctx.lookup(theDataSource);
myConn = myDataSource.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return myConn;
}
public static void closeConnection(Connection conn)
{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* This method executes the query passed to it
* @returns the resultset
*/
public static ResultSet executeQuery(String qr)
{
queryStatus = "good";
ResultSet rs = null;
try {
InitialContext ctx = new InitialContext();
myDataSource = (DataSource)ctx.lookup(theDataSource);
myConn = myDataSource.getConnection();
Statement st = myConn.createStatement();
rs = st.executeQuery(qr);
}
catch(Exception e)
{
e.printStackTrace();
queryStatus = e.toString();
}
//System.out.println("Query is : " +qr);
return rs;
}