I followed most of the ibm directions on how to set this up. My app server obtains Connections using the following code:
/** Obtain
JDBC connection. */
public java.sql.Connection getConnection() throws Exception
{
javax.sql.DataSource ds = null;
java.sql.Connection conn = null;
String jdbcPoolName = "java:comp/env/jdbc/hhhhPool";
try
{
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
// InitialContext ctx = this.getInitialContext();
ds = (javax.sql.DataSource) ctx.lookup (jdbcPoolName);
conn = ds.getConnection();
log.debug("Connection to " + jdbcPoolName + " established..");
return conn;
}
catch(Exception e)
{
throw new Exception("Could not establish a Connection using the following connection pool: " +
jdbcPoolName + " with this problem: " + e);
}
}
Yet any time I attempt to use the Connection, I get the following error:
[9/18/03 10:59:14:744 EDT] 61ec06a6 ConnectionFac I J2CA0122I: Resource reference jdbc/hhhhPool could not be located, so default values of the following are used: [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
As a WS newbie, the configuration nightmare is killing me. Anybody know why I'm getting this and how to fix?
Thanks!
