Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

oracle datasource exception with WebSphere 5.0

24 views

Skip to first unread message

Amit R

unread,

Jul 8, 2002, 6:31:47 PM7/8/02

Hello;

I am trying to use Oracle classes12.zip driver to connect to a Oracle
Database for a web application and get the following exception when trying
to login to the application.
The application works fine in websphere 4.0 without any errors.
However when creating the DataSource I get the following error on the
WebSphere web based admin client for version 5.0
Configuration Problems
The following problems with the current configuration file might cause your
applications to perform poorly or not at all. These should be fixed before
moving to a production environment. If the XML Parser has detected problems,
you must fix them before the administrative console can load.
Problem Description
CHKW3029E: The name of the resource property is required.
[J2EEResourceProperty_2]
CHKW3028E: The type of the resource property is required.
[J2EEResourceProperty_2]

Any help will be greatly appreciated.

Thanks
Amit

-----------------------
RecordId: Rec_170
ComponentId:
ProcessId: 2664
ThreadId: 98c3155
FunctionName:
ProbeId:
SourceId: com.ibm.ejs.j2c.ConnectionFactoryBuilder
Manufacturer: IBM
Product: WebSphere
Version: AEs 5.0.0 Tc0150.16
ServerName: useomapp554/Default Server
ClientHostName:
ClientUserId:
TimeStamp: 7/8/2002 18:24:17.359000000
UnitOfWork:
Severity: 1
Category: ERROR
FormatWarning:
PrimaryMessage:
ExtendedMessage: J2CA0036E: An exception occurred while invoking method
setDataSource Properties on
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl :
java.lang.reflect.InvocationTargetException:
com.ibm.ws.exception.WsException: DataStoreHelper class
oracle.jdbc.pool.OracleConnectionPoolDataSource could not be constructed
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAd
apterException.java:176)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.setDataStoreHelper(WSRdbDataSource.
java:651)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.<init>(WSRdbDataSource.java:133)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.setDataSourcePropert
ies(WSManagedConnectionFactoryImpl.java:596)
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.createConnectionFactoryDetails(Conn
ectionFactoryBuilder.java:237)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.getObjectInstance(ConnectionFactory
Builder.java:448)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:313)
at
com.ibm.ws.naming.util.Helpers.processSerializedObjectForLookup(Helpers.java
:739)
at com.ibm.ejs.ns.jndi.CNContextImpl.cacheLookup(CNContextImpl.java:2682)
at com.ibm.ejs.ns.jndi.CNContextImpl.doLookup(CNContextImpl.java:1415)
at com.ibm.ejs.ns.jndi.CNContextImpl.lookup(CNContextImpl.java:1120)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:128)
at javax.naming.InitialContext.lookup(InitialContext.java:359)
at
kpmg.taxshared.beans.OracleConnectionBean.getConnection(OracleConnectionBean
.java:29)
at
kpmg.taxshared.beans.OracleConnectionBean.getEStarsConnection(OracleConnecti
onBean.java:63)
at kpmg.estars.servlets.LoginServlet.captureUserRole(LoginServlet.java:119)
at kpmg.estars.servlets.LoginServlet.performTask(LoginServlet.java:54)
at kpmg.estars.servlets.LoginServlet.doPost(LoginServlet.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java:860)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:50
2)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java:1052)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java:947)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java:648)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java:379)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:76)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:182)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cacheabl
eInvocationContext.java:106)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:125)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
va:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:417)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:321)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
---- Begin backtrace for nested exception
java.lang.NoSuchMethodException: <init>
at java.lang.Class.getConstructor0(Native Method)
at java.lang.Class.getConstructor(Class.java:967)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.setDataStoreHelper(WSRdbDataSource.
java:642)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.<init>(WSRdbDataSource.java:133)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.setDataSourcePropert
ies(WSManagedConnectionFactoryImpl.java:596)
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.createConnectionFactoryDetails(Conn
ectionFactoryBuilder.java:237)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.getObjectInstance(ConnectionFactory
Builder.java:448)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:313)
at
com.ibm.ws.naming.util.Helpers.processSerializedObjectForLookup(Helpers.java
:739)
at com.ibm.ejs.ns.jndi.CNContextImpl.cacheLookup(CNContextImpl.java:2682)
at com.ibm.ejs.ns.jndi.CNContextImpl.doLookup(CNContextImpl.java:1415)
at com.ibm.ejs.ns.jndi.CNContextImpl.lookup(CNContextImpl.java:1120)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:128)
at javax.naming.InitialContext.lookup(InitialContext.java:359)
at
kpmg.taxshared.beans.OracleConnectionBean.getConnection(OracleConnectionBean
.java:29)
at
kpmg.taxshared.beans.OracleConnectionBean.getEStarsConnection(OracleConnecti
onBean.java:63)
at kpmg.estars.servlets.LoginServlet.captureUserRole(LoginServlet.java:119)
at kpmg.estars.servlets.LoginServlet.performTask(LoginServlet.java:54)
at kpmg.estars.servlets.LoginServlet.doPost(LoginServlet.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java:860)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:50
2)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java:1052)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java:947)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java:648)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java:379)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:76)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:182)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cacheabl
eInvocationContext.java:106)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:125)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
va:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:417)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:321)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
----- Begin backtrace for targetException
com.ibm.ws.exception.WsException: DataStoreHelper class
oracle.jdbc.pool.OracleConnectionPoolDataSource could not be constructed
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAd
apterException.java:176)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.setDataStoreHelper(WSRdbDataSource.
java:651)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.<init>(WSRdbDataSource.java:133)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.setDataSourcePropert
ies(WSManagedConnectionFactoryImpl.java:596)
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.createConnectionFactoryDetails(Conn
ectionFactoryBuilder.java:237)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.getObjectInstance(ConnectionFactory
Builder.java:448)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:313)
at
com.ibm.ws.naming.util.Helpers.processSerializedObjectForLookup(Helpers.java
:739)
at com.ibm.ejs.ns.jndi.CNContextImpl.cacheLookup(CNContextImpl.java:2682)
at com.ibm.ejs.ns.jndi.CNContextImpl.doLookup(CNContextImpl.java:1415)
at com.ibm.ejs.ns.jndi.CNContextImpl.lookup(CNContextImpl.java:1120)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:128)
at javax.naming.InitialContext.lookup(InitialContext.java:359)
at
kpmg.taxshared.beans.OracleConnectionBean.getConnection(OracleConnectionBean
.java:29)
at
kpmg.taxshared.beans.OracleConnectionBean.getEStarsConnection(OracleConnecti
onBean.java:63)
at kpmg.estars.servlets.LoginServlet.captureUserRole(LoginServlet.java:119)
at kpmg.estars.servlets.LoginServlet.performTask(LoginServlet.java:54)
at kpmg.estars.servlets.LoginServlet.doPost(LoginServlet.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java:860)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:50
2)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java:1052)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java:947)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java:648)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java:379)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:76)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:182)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cacheabl
eInvocationContext.java:106)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:125)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
va:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:417)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:321)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
---- Begin backtrace for nested exception
java.lang.NoSuchMethodException: <init>
at java.lang.Class.getConstructor0(Native Method)
at java.lang.Class.getConstructor(Class.java:967)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.setDataStoreHelper(WSRdbDataSource.
java:642)
at
com.ibm.ws.rsadapter.spi.WSRdbDataSource.<init>(WSRdbDataSource.java:133)
at
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.setDataSourcePropert
ies(WSManagedConnectionFactoryImpl.java:596)
at java.lang.reflect.Method.invoke(Native Method)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.createConnectionFactoryDetails(Conn
ectionFactoryBuilder.java:237)
at
com.ibm.ejs.j2c.ConnectionFactoryBuilder.getObjectInstance(ConnectionFactory
Builder.java:448)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:313)
at
com.ibm.ws.naming.util.Helpers.processSerializedObjectForLookup(Helpers.java
:739)
at com.ibm.ejs.ns.jndi.CNContextImpl.cacheLookup(CNContextImpl.java:2682)
at com.ibm.ejs.ns.jndi.CNContextImpl.doLookup(CNContextImpl.java:1415)
at com.ibm.ejs.ns.jndi.CNContextImpl.lookup(CNContextImpl.java:1120)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCtx.java:128)
at javax.naming.InitialContext.lookup(InitialContext.java:359)
at
kpmg.taxshared.beans.OracleConnectionBean.getConnection(OracleConnectionBean
.java:29)
at
kpmg.taxshared.beans.OracleConnectionBean.getEStarsConnection(OracleConnecti
onBean.java:63)
at kpmg.estars.servlets.LoginServlet.captureUserRole(LoginServlet.java:119)
at kpmg.estars.servlets.LoginServlet.performTask(LoginServlet.java:54)
at kpmg.estars.servlets.LoginServlet.doPost(LoginServlet.java:29)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
.java:860)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:50
2)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java:1052)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java:947)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java:648)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java:379)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:76)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:182)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(Cacheabl
eInvocationContext.java:106)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:125)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
.java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
va:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:417)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:321)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)
. Processing halted.
RawDataLen: 0
RawData:

Sunil Zagade

unread,

Jul 10, 2002, 9:34:30 AM7/10/02

Amit,
At first take backup of your old WAS repository
and drop the table from the repository and try to regain the admin
repository again after restart.

Sunil

"Amit R" <anon...@hotmail.com> wrote in message
news:agd3hb$1skq$1...@news.boulder.ibm.com...

Amit R

unread,

Jul 10, 2002, 12:33:33 PM7/10/02

sunil;

Sorry i forgot to highlight. I am using websphere 50 technology preview
edition single serve.r it uses the xml file as a repository.
any ideas ?

Amit

"Sunil Zagade" <zag...@aetna.com> wrote in message
news:aghcpt$213s$1...@news.boulder.ibm.com...

0 new messages