WAS 4.0 AES + DB2 + connection error!

[luisalfredoperez]

Hi all

I'm a newbie in the ejb development. I´m working with WebSphere Advanced Edition Single Server 4.0 with DB2 UDB v 7.1 Fixpack 5, with IBM HTTP Server, all over Linux Red Hat 7.2.

I've done a tutorial which I've downloaded from

http://www.webspherepro.com.

I've deployed a CMP entity bean which uses a instantdb. Everything worked fine until I tried to use the same entity bean with db2, creating the same db with the same tables. In the AAT I switched the jndi reference from instantdb to respective db2 db, and I generated the code again, later I deployed it and I got the following error:

79518ccb Helpers W NMSV0610I: A NamingException is being thrown from a javax.naming.Context implementation. Details follow:
Context implementation: com.ibm.ws.naming.urlns.genericURLContextRoot
Context method: lookup(Name)
Context name: local:
Target name: jdbc/jdbc/sample40
Other data:
Exception stack trace: java.lang.NoClassDefFoundError: javax/sql/ConnectionPoolDataSource
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code))
at java.net.URLClassLoader.defineClass(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader.defineClass(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader.access$300(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at com.ibm.ws.classloader.ReloadableClassLoader.loadClass(ReloadableClassLoader.java:66)
at com.ibm.websphere.advanced.cm.factory.DataSourceFactory.isJTAEnabled(DataSourceFactory.java:491)
at com.ibm.ejs.cm.DataSourceFactory.createDataSource(DataSourceFactory.java:128)
at com.ibm.ejs.cm.DataSourceFactory.getDataSource(DataSourceFactory.java:112)
at com.ibm.websphere.advanced.cm.factory.DataSourceFactory.getDataSource(DataSourceFactory.java:387)
at com.ibm.websphere.advanced.cm.factory.DataSourceFactory$ResourceReferenceObjectFactory.getObjectInstance(DataSourceFactory.java:750)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:308)
at com.ibm.ws.naming.urlbase.UrlContextHelper.isReference(UrlContextHelper.java:115)
at com.ibm.ws.naming.urlbase.UrlContextHelper.processBoundObjectForLookup(UrlContextHelper.java:221)
at com.ibm.ws.naming.urlbase.UrlContext.lookup(UrlContext.java:1181)
at com.ibm.ws.naming.urlbase.UrlContext.lookup(UrlContext.java:1158)
at com.ibm.ws.naming.urlbase.UrlContext.lookup(UrlContext.java:1210)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at com.ibm.ws.cpi.JDBCPersisterFactoryImpl.create(JDBCPersisterFactoryImpl.java:88)
at com.ibm.ejs.container.EJSContainer.loadBeanMetaData(EJSContainer.java:1511)
at com.ibm.ejs.container.EJSContainer.getHomeInstance(EJSContainer.java:1255)
at com.ibm.ejs.container.EJSContainer.startBean(EJSContainer.java:1219)
at com.ibm.ws.runtime.BeanHelper.startBean(BeanHelper.java:154)
at com.ibm.ws.runtime.EJBEngine.addEjbModule(EJBEngine.java:437)
at com.ibm.ws.runtime.Server.startModule(Server.java:605)
at com.ibm.ws.runtime.Server.startApplication(Server.java:399)
at com.ibm.ejs.sm.util.debug.DrAdminServer.basicStartApplication(DrAdminServer.java:2311)
at com.ibm.ejs.sm.util.debug.DrAdminServer.startApplication(DrAdminServer.java:2276)
at com.ibm.ejs.sm.util.debug.DrAdminServer.handleRestartApplication(DrAdminServer.java:1359)
at com.ibm.ejs.sm.util.debug.DrAdminServer.processMethod(DrAdminServer.java:750)
at com.ibm.ejs.sm.util.debug.DrAdminServer.processRequest(DrAdminServer.java:603)
at com.ibm.ejs.sm.util.debug.DrAdminServer.processRequest(DrAdminServer.java:555)
at com.ibm.ejs.sm.util.debug.DrAdminServer.listen(DrAdminServer.java:504)
at com.ibm.ejs.sm.util.debug.DrAdminServer$ServerRunner.run(DrAdminServer.java:243)


[02.01.30 11:51:38:025 GMT-04:00] 79518ccb Helpers W NMSV0610I: A NamingException is being thrown from a javax.naming.Context implementation. Details follow:
Context implementation: com.ibm.ws.naming.urlns.genericURLContextRoot
Context method: lookup(Name)
Context name: local:
Target name: local:jdbc/jdbc/sample40
Other data:
Exception stack trace: javax.naming.NamingException: The JNDI operation "lookup(Name)"on the context "local:" with the name "jdbc/jdbc/sample40" failed. Please get the root cause Throwable contained in this NamingException for more information. Root exception is java.lang.NoClassDefFoundError: javax/sql/ConnectionPoolDataSource
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code))
at ...

My datasource's JNDI name is jdbc/sample40. I don't know why the engine is searching for jdbc/jdbc/sample40 !


I'm very tired going around in circles and surfing the ibm websphere infocenter page and get nothing of help. I feel null, I'm waiting your help, thanxs

Have a nice day

 

[KishoreKumar]

Hi ,
Try putting jar file which is having javax.sql.* pakages in websphere calss path. Kishore Kumar K
Covansys India