Skip to Content
0
Former Member
Sep 06, 2007 at 03:17 PM

Oralce datasource - problem

13 Views

Hello,

I tried to create a datasource using Visual Administrator to Oracle Database. I have a webdynpro application accessing the datasource to pull the data from the Database and display to the user.

I am working on Oracle 10.2 and using ojdbc14.jar. I am using JDBC 2.x driver for this. Here are the configuration parameters used for the Datasource

JDBC Version : 2.0 (with XA Support)

Object Factory : oracle.jdbc.pool.OracleDataSourceFactory

DataSource Type : ConnectionPoolDataSource

CPDS Classname : oracle.jdbc.pool.OracleConnectionPoolDataSource

[Additional] Properties:

url = jdbc:oracle:thin:@localhost:1521:orcl817

user = scott

password = tiger

My application is not able to pull up any data from the database and is not showing any data. I found an exception on the defaultTrace file. Here is the stack trace of the exception thrown.

#1.5_#0003BA1D8303004F0000005700000B5F00043969ECC1420E#
1189027013280#com.sap.engine.services.connector##
com.sap.engine.services.connector#Administrator#11205####
1da526b05bf511dc907a0003ba1d8303#SAPEngine_Application_Thread[impl:3]
_37##0#0#Error##Plain###ResourceObjectFactory.getConnectionSet(MDM_SandBox), 
Exception: com.sap.engine.services.connector.exceptions.BaseResourceException: 
ConnectionFactory "MDM_SandBox" does not exist. 
Possible reasons: the connector in which ConnectionFactory "MDM_SandBox" is 
defined is not deployed or not started.

      at com.sap.engine.services.connector.ResourceObjectFactory.getConnectionSet(ResourceObjectFactory.java:671)

      at com.sap.engine.services.dbpool.deploy.DataSourceManagerImpl.listUsedConnections(DataSourceManagerImpl.java:565)

      at com.sap.engine.services.dbpool.deploy.DataSourceManagerImpl.getUsedConnectionsCount(DataSourceManagerImpl.java:967)

      at sun.reflect.GeneratedMethodAccessor459.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      at java.lang.reflect.Method.invoke(Method.java:324)

      at com.sap.pj.jmx.introspect.DefaultMBeanInvoker.invoke(DefaultMBeanInvoker.java:58)

      at com.sap.pj.jmx.mbeaninfo.AdditionalInfoProviderMBean.invoke(AdditionalInfoProviderMBean.java:289)

      at com.sap.pj.jmx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:944)

      at com.sap.pj.jmx.server.interceptor.MBeanServerWrapperInterceptor.invoke(MBeanServerWrapperInterceptor.java:288)

      at com.sap.engine.services.jmx.CompletionInterceptor.invoke(CompletionInterceptor.java:409)

      at com.sap.pj.jmx.server.interceptor.BasicMBeanServerInterceptor.invoke(BasicMBeanServerInterceptor.java:277)

      at com.sap.jmx.provider.ProviderInterceptor.invoke(ProviderInterceptor.java:258)

      at com.sap.engine.services.jmx.RedirectInterceptor.invoke(RedirectInterceptor.java:340)

      at com.sap.pj.jmx.server.interceptor.MBeanServerInterceptorChain.invoke(MBeanServerInterceptorChain.java:330)

      at com.sap.engine.services.jmx.MBeanServerSecurityWrapper.invoke(MBeanServerSecurityWrapper.java:287)

      at com.sap.engine.services.jmx.MBeanServerInvoker.invokeMbs(MBeanServerInvoker.java:131)

      at com.sap.engine.services.jmx.ClusterInterceptor.invokeMbs(ClusterInterceptor.java:212)

      at com.sap.engine.services.jmx.ClusterInterceptor.invoke(ClusterInterceptor.java:766)

      at com.sap.engine.services.jmx.MBeanServerInterceptorInvoker.invokeMbs(MBeanServerInterceptorInvoker.java:102)

      at com.sap.engine.services.jmx.connector.p4.P4ConnectorServerImpl.invokeMbs(P4ConnectorServerImpl.java:61)

      at com.sap.engine.services.jmx.connector.p4.P4ConnectorServerImplp4_Skel.dispatch(P4ConnectorServerImplp4_Skel.java:64)

      at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:312)

      at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:199)

      at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:129)

      at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

      at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

      at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

      at java.security.AccessController.doPrivileged(Native Method)

      at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

      at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

#

The excpetion says that the Datasource is not deployed or not started. However, I can see my datasource running in the Visual Administrator.

Any help on fixing this problem is appreciated.

Thanks

Suman