JDBC 601 Adfapter configuration error

, ,
1

Hi,
I am trying to create JDBC connection and getting following error. What could be the possible problem, Could you please let me know.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource testfolder:JDBCtestConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
Io exception: The Network Adapter could not establish the connection

I provided following parameters.
Transaction Type = LOCAL_TRANSACTION
DataSource Class = oracle.jdbc.pool.OracleDataSource
serverName = localhost
user = scott
databaseName = webdb
portNumber = 1521
networkProtocol =
Other Properties = driverType=thin

Thanks,
Shri

2

Pls try using:

oracle.jdbc.pool.OracleConnectionPoolDataSource

instead of oracle.jdbc.pool.OracleDataSource.

HTH.

3

Thanks for reply.
I tried with “oracle.jdbc.pool.OracleConnectionPoolDataSource” but still getting the same error.

Shri

4

Hi Shri,

Check and try this…

Please make sure that Classes12.zip is in the IntegrationServer Jars directory. If you don;t have that in that directory please place classes12.zip in the HOME/IntegrationServer/lib/jars.

You can get this classes12.zip JDBC driver file from oracle site or from your local oracle Installation directories.

Thanks,
-GV

5

Hi GV,

Thanks for reply.
There is classes12.zip file in HOME/IntegrationServer/lib/jars directory. After placing in specified directory, I restarted integration server also. Do we need to add this to classpath?.

Thanks,
Shri

6

It is solved. The problem was with TNS listner. It was not running.

Shri

7

Hi Shri,

I have the same problem too.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource adapters:D106Adapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.7

Please advise which TNS listener should i enable? Do I need to add the classpath of the jar file? Or any other suggestions?

Thanks!

8

Hi,
I too have the same problem, but the database is informix.
My Conn Parameters :
Transaction Type : LOCAL_TRANSACTION
DataSource Class : com.informix.jdbc.IfxDriver
serverName informix.db.com
user :testuser
password :testuser
databaseName : ds05
portNumber : 6678
networkProtocol: TCP
Other Properties : driverType=oci
i copied the ifxjdbc.jar in integrationServer/lib/jars also under jdbcAdapter/lib/jars

Error:
com.wm.pkg.art.error.DetailedServiceException: [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource informixConTest:informixTest.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
com.informix.jdbc.IfxDriver
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1048)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:522)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Compiled Code))
at com.wm.util.template.SwitchToken.evalChild(SwitchToken.java:90)
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.SwitchToken.eval(SwitchToken.java:58)
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java(Compiled Code))
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.IfVarToken.eval(IfVarToken.java:219)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.Reporter.reportNoReset(Reporter.java:1299)
at com.wm.util.template.Reporter.reportToOutput(Reporter.java:1274)
at com.wm.util.template.Reporter.reportIData(Reporter.java:1163)
at com.wm.app.b2b.server.HTTPDocHandler._process(HTTPDocHandler.java:485)
at com.wm.app.b2b.server.HTTPDocHandler.process(HTTPDocHandler.java:106)
at com.wm.app.b2b.server.Dispatch.ru

kindly help me to solve the issue.

9

I’ve solved my problem. The oracle db is version 9i but the client server’s classes12.zip is 8i. It’s fine after i’ve put in version 9i’s classes12.zip in the directory.

10

Anush, did you resolve the informix Connection manager issue? I’m getting the same error. Any insights?? Pl. help.

-----error msg----
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource mainFolder.subFolder1:myConn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
java.util.NoSuchElementException