on 2007 Sep 06 4:17 PM
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
Suman,
We had a lot of trouble figuring out how to setup Data Source for Oracle also so you're not alone. : )
Before setting up the datasource, did you create a driver in Visual Administrator? You can name it anything you want but it should point to the classes*.zip file that contains the Oracle drivers.
Then you need to specify that driver in the Data Source.
The rest looks OK. The only other thing I can suggest right now is for you to set the Initial Connections to a non-zero value. Then when you save the Data Source, it will attempt to create the connection. If it fails you know there is something wrong with your data source. If it saves OK then the problem is somewhere else.
Oh, and we haven't been able to get it to work with Native SQL option under SQL Engine. We use Vendor SQL radio button.
Good luck!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.