Getting database connection from Websphere is time-consuming

[Setya Djajadinata]

Hi all,

Although I successfully obtain database connection from Websphere I always encounter the following warning messages:

Nov 8, 2007 7:56:44 PM com.ibm.ejs.j2c.XMLReader
WARNING: ERROR_GETTING_PROPERTIES_PATH_J2CA0115
Nov 8, 2007 7:56:44 PM com.ibm.ejs.j2c.XMLReader
WARNING: ERROR_GETTING_PROPERTIES_PATH_J2CA0115
Nov 8, 2007 7:56:44 PM com.ibm.ejs.j2c.ConnectionManager
WARNING: MISSING_TRANSACTION_CONTEXT_J2CA0075
Nov 8, 2007 7:57:13 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: DB_PRODUCT_NAME
Nov 8, 2007 7:57:13 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: DB_PRODUCT_VERSION
Nov 8, 2007 7:57:13 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: JDBC_DRIVER_NAME
Nov 8, 2007 7:57:13 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: JDBC_DRIVER_VERSION
Nov 8, 2007 7:57:13 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: CONFIG_WARN
Nov 8, 2007 7:57:13 PM com.ibm.ejs.j2c.ConnectionManager
WARNING: MISSING_TRANSACTION_CONTEXT_J2CA0075
Nov 8, 2007 7:57:13 PM com.ibm.ejs.j2c.XMLReader
WARNING: ERROR_GETTING_PROPERTIES_PATH_J2CA0115
Nov 8, 2007 7:57:13 PM com.ibm.ejs.j2c.XMLReader
WARNING: ERROR_GETTING_PROPERTIES_PATH_J2CA0115
Nov 8, 2007 7:57:13 PM com.ibm.ejs.j2c.ConnectionManager
WARNING: MISSING_TRANSACTION_CONTEXT_J2CA0075
Nov 8, 2007 7:57:41 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: DB_PRODUCT_NAME
Nov 8, 2007 7:57:41 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: DB_PRODUCT_VERSION
Nov 8, 2007 7:57:41 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: JDBC_DRIVER_NAME
Nov 8, 2007 7:57:41 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: JDBC_DRIVER_VERSION
Nov 8, 2007 7:57:41 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: CONFIG_WARN
Nov 8, 2007 7:57:41 PM com.ibm.ejs.j2c.ConnectionManager
WARNING: MISSING_TRANSACTION_CONTEXT_J2CA0075
Nov 8, 2007 7:57:41 PM com.ibm.ejs.j2c.XMLReader
WARNING: ERROR_GETTING_PROPERTIES_PATH_J2CA0115
Nov 8, 2007 7:57:41 PM com.ibm.ejs.j2c.XMLReader
WARNING: ERROR_GETTING_PROPERTIES_PATH_J2CA0115
Nov 8, 2007 7:57:41 PM com.ibm.ejs.j2c.ConnectionManager
WARNING: MISSING_TRANSACTION_CONTEXT_J2CA0075
Nov 8, 2007 7:58:09 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: DB_PRODUCT_NAME
Nov 8, 2007 7:58:09 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: DB_PRODUCT_VERSION
Nov 8, 2007 7:58:09 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: JDBC_DRIVER_NAME
Nov 8, 2007 7:58:09 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: JDBC_DRIVER_VERSION
Nov 8, 2007 7:58:09 PM com.ibm.ws.rsadapter.spi.InternalDataDirectDataStoreHelper
INFO: CONFIG_WARN

Besides for the 1st time it always takes very long time to get the datasource, but the subsequent calls are very fast.

Here's my code to get the connection:

Hashtable env = new Hashtable();
env.put(Context.INITIAL_CONTEXT_FACTORY,WsnInitialContextFactory.class.getName());
env.put(Context.URL_PKG_PREFIXES,SystemProperties.getProperty(Context.URL_PKG_PREFIXES));
env.put(Context.PROVIDER_URL,SystemProperties.getProperty(Context.PROVIDER_URL));
env.put("org.omg.CORBA.ORBClass",com.ibm.CORBA.iiop.ORB.class.getName());
 
Context context = new InitialContext(env);
DataSource ds = (DataSource)context.lookup("jdbc/DataSource");
Connection con = ds.getConnection("foo","bar"); //This takes so long.

Am I missing something here ? I've included all the neccessary jars in the classpath.

Any help would be greatly appreciated.

Best Regards,

Setya