whether connection pool will available at the time of starting the server

[padmakar reddy kadem]

Hi,

I am able to get the connection from the connection pool and able to access the db and also i need to get the connection from the connection pool of websphere in custom class which will load at the time of starting the server.But i am not able to get the connection from the pool.
I created the datasource at the server level.
My question is can we get the connection(in custom class) from the pool at the time of starting the server.

  System.out.println("GETTING CONNECTION POOL FROM WEBSphere!!!!!!!!!!!!");
Hashtable ht = new Hashtable();
String strInitContext = rb.getString("webspheretContext");
String strt3Url = rb.getString("t3url");
String datasourceName = rb.getString("datasourceName");
ht.put(Context.INITIAL_CONTEXT_FACTORY, strInitContext);
ht.put(Context.PROVIDER_URL, strt3Url);
Context ctx = new InitialContext(ht);
System.out.println("after InitialContext;");
System.out.println("before ds.getConnection();");
DataSource ds = (DataSource) ctx.lookup(datasourceName);

conn = ds.getConnection();
System.out.println("after ds.getConnection();");  

here last statement i.e System.out.println("after ds.getConnection();"); is not printing on the console.

[John Jesunamam]

Assuming that code is taken from a try block. There must be an exception thrown before the print statement. So please find out and post the information about the exception.
[ March 27, 2008: Message edited by: John Jesunamam ]

[padmakar reddy kadem]

   [3/28/08 20:05:39:938 IST] 0000000a NameServerImp A   NMSV0018I: Name server available on bootstrap port 2809.
[3/28/08 20:05:40:110 IST] 0000000a SystemOut     O 1>inside intialize method:--padmakar
[3/28/08 20:05:40:126 IST] 0000000a SystemOut     O GETTING CONNECTION POOL FROM WEBSphere!!!!!!!!!!!!
[3/28/08 20:05:40:126 IST] 0000000a SystemOut     O after InitialContext;
[3/28/08 20:05:40:126 IST] 0000000a SystemOut     O before ds.getConnection();
[3/28/08 20:05:40:173 IST] 0000000a SystemOut     O exception in last catch block::javax.naming.NameNotFoundException: Context: IFLMUD6DLGBLGNode01Cell/nodes/IFLMUD6DLGBLGNode01/servers/server1, name: jdbc/orcads: [B]First component in name jdbc/orcads not found. [Root exception is org.omg.CosNaming.NamingContextPackage.NotFound:[/B] IDL :-o	 mg.org/CosNaming/NamingContext/NotFound:1.0]
[3/28/08 20:05:43:313 IST] 0000000a authz         I   CWWIM2000I Initialization of the authorization component completed successfully.
[3/28/08 20:05:43:313 IST] 0000000a UserRegistryI A   SECJ0136I: Custom Registry:com.ibm.ws.wim.registry.WIMUserRegistry has been initialized
[3/28/08 20:05:51:266 IST] 0000000a JMXSoapAdapte A   ADMC0013I: The SOAP connector is available at port 8880
[3/28/08 20:05:51:297 IST] 0000000a distSecurityC I   SECJ0243I: Security service started successfully
[3/28/08 20:05:51:297 IST] 0000000a distSecurityC I   SECJ0210I: Security enabled true
[3/28/08 20:05:52:531 IST] 0000000a J2EEServiceMa I   ASYN0055I: The Work Manager service started successfully.
[3/28/08 20:05:52:641 IST] 0000000a RecoveryDirec I   CWRLS0010I: Performing recovery processing for local WebSphere server (IFLMUD6DLGBLGNode01Cell\IFLMUD6DLGBLGNode01\server1).
[3/28/08 20:05:52:672 IST] 0000000a RecoveryDirec I   CWRLS0012I: All persistent services have been directed to perform recovery processing for this WebSphere server (IFLMUD6DLGBLGNode01Cell\IFLMUD6DLGBLGNode01\server1).
[3/28/08 20:05:52:703 IST] 00000017 RecoveryManag A   WTRN0028I: Transaction service recovering 0 transactions.
[3/28/08 20:05:53:297 IST] 0000000a ResourceMgrIm I   WSVR0049I: Binding ORCADSCELL as jdbc/orcads1
[3/28/08 20:05:53:328 IST] 0000000a ResourceMgrIm I   WSVR0049I: Binding DefaultEJBTimerDataSource as jdbc/DefaultEJBTimerDataSource
[3/28/08 20:05:53:375 IST] 0000000a ResourceMgrIm I   WSVR0049I: Binding Default_CF as eis/DefaultDatasource_CMP
[3/28/08 20:05:53:391 IST] 0000000a ResourceMgrIm I   WSVR0049I: Binding ORCADS_CF as eis/jdbc/orcads_CMP
[3/28/08 20:05:53:406 IST] 0000000a ResourceMgrIm I   WSVR0049I: Binding Default Datasource as DefaultDatasource
[3/28/08 20:05:53:516 IST] 0000000a ResourceMgrIm I   WSVR0049I: Binding ORCADS as jdbc/orcads 

exception causes javax.naming.NameNotFoundException: Context: IFLMUD6DLGBLGNode01Cell/nodes/IFLMUD6DLGBLGNode01/servers/server1, name: jdbc/orcads: First component in name jdbc/orcads not found. [Root exception is org.omg.CosNaming.NamingContextPackage.NotFound: IDL mg.org/CosNaming/NamingContext/NotFound


is it related to jar files(naming.jar,namingclient.jar,namingserver.jar).if it is where can we download these jar files.

I am able to access the web application which is deployed on the same server.Web application is successfully getting the connection from the pool.

In custom class also i am using the same datasource but not able to get the connection.

[John Jesunamam]

You could search for those jar files and add them to the build path. It should be there in WAS installation directory.
[ March 28, 2008: Message edited by: John Jesunamam ]

[padmakar reddy kadem]

Hi,

I need to set the classpath for the custom class(websphere) to use the websphere connection pool.

In websphere 6.1,at the time of creating the custom class, there is a text box for the class path.I was given the path like D:/jars,but i need to place the properties folder of websphere and some jar files(ecutils.jar,j2cImpl.jar,j2ee.jar,messagingClient.jar,naming.jar,namingClient.jar,namingserver.jar,webcontainer.jar,Properties folder)in the classpath.

How to place these jar files and properties folder of websphere in the classpath for the custom class.

Thanks,
Padmakar