cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with JDBC datasource configuration

ashish_shah
Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

ashish_shah
Contributor
0 Kudos

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

Answers (0)