on 12-13-2007 10:07 AM
Hi Experts,
I am encountering the following error while configuring the JDBC connector.
#1.5#001560DEB814000B0000000C00004569000440EAEC713145#1197277640208#com.sap.engine.services.connector##com.sap.engine.services.connector#Administrator#143##bdhp4530.na.pg.com_GGE_78680350#Administrator#c00e94b0a6fd11dc817a001560deb814#SAPEngine_Application_Thread[impl:3]_23##0#0#Error##Plain###ResourceObjectFactory.getConnectionSet(APT_DataSource), Exception: com.sap.engine.services.connector.exceptions.BaseResourceException: ConnectionFactory "APT_DataSource" does not exist. Possible reasons: the connector in which ConnectionFactory "APT_DataSource" 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.listFreeConnections(DataSourceManagerImpl.java:540)
at com.sap.engine.services.dbpool.deploy.DataSourceManagerImpl.getCurrentSize(DataSourceManagerImpl.java:944)
at sun.reflect.GeneratedMethodAccessor377.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:400)
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:157)
at com.sap.engine.services.jmx.ClusterInterceptor.invokeMbs(ClusterInterceptor.java:220)
at com.sap.engine.services.jmx.ClusterInterceptor.invoke(ClusterInterceptor.java:803)
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:304)
at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:193)
at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:122)
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:100)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)#
I have used the following configuration:
Application Name Test_Application
DataSource Name APT_DataSource
Description DataSource to the SDC Dev Oracle DB
Alias APT_DS
Driver Name SYSTEM_DRIVER
Database Version Oracle9i Enterprise Edition Release 9.2.0.6.0
JDBC Version 1.x ( No XA support)
Driver Class oracle.jdbc.driver.OracleDriver
Database URL jdbc:oracle:oci:@<hostname>:1521:<sid>
User User
Password password
Connection Pooling
Initial Connections 0
Max Connections 25
Max Time to Wait for Connection 60
Default Connection Isolation DEFAULT
Expiration Enable
Connection Lifetime 300
Cleanup Thread 5
SQL Engine Vendor SQL
TNSNAMES.ORA File Entry <sid>.WORLD =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = <host>)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <sid>.WORLD)
(SID = <sid>)
)
)
Can you please help.
Regards,
Ashish Shah
Hi,
Take note of the following and review the configuration,
1. In general, ojdbc14.jar is used in the SAP environment for Oracle JDBC Driver. The other being classes12.jar.
2. The driver class must be, oracle.jdbc.OracleDriver
3. The database URL for the Oracle JDBC thin driver has the following syntax:
jdbc:oracle:thin:@<host>:<port>:<sid>
jdbc:oracle:thin:<user>/<password>@<host>:<port>:<sid>
Hope these hints help you in solving !
Regards
Srinivasan T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srinivasan,
Thanks for your response.
I found the solution to this problem.
I had requested for a change in URL of a data source.
When ERP team did it, data source stopped working.
It happened so because; you are not supposed to change a data source. You need to recreate it and delete the old one.
When we created a new, the error was resolved.
NEVER CHANGE THE JDBC DATA SOURCE IN VISUAL ADMIN.
Copy it and recreate it.
Regards,
Ashish Shah
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.