jdbc Error in webMethods 9.12 trail version

, ,
1

Hi,

I have installed webMethods trail version 9.12 and I am trying to configure JDBC connection.and the connection is not enabled and giving

error

“[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource AdapterConnection:OracleConnection.
[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”.
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor”

I have given all connection properties .
I have copied classes12.jar and ojdbc 14.jar files at the location “C:\SoftwareAG912\IntegrationServer\lib\jars”.

Please suggest me on this.

2

Place the files in the below-mentioned path and try reloading WmJDBC package.
\instances\default\packages\WmJDBCAdapter\code\jars

Also, you can place it under below-mentioned location and restart your IS.
\instances\default\lib\jars

BTW which oracle version you are trying to connect? I suggest you use the ojdbc6.jar file.

Regards,
Syed Faraz Ahmed

3

Small update for you.
I am using JVM 1.7 and I have removed database name from the properties and given serviceName after that I got below below error,

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource AdapterConnection:OracleConnection.
[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”.
ORA-28040: No matching authentication protocol

Could you please let me know the reason.
Thanks

4

I am using 11g

5

Thanks Syed Faraz,
Issues has been resolved after I places ojdbc6.jar file at below locations.
1.\instances\default\packages\WmJDBCAdapter\code\jars
2.\instances\default\lib\jars

6

Hi,

classes12.jar and ojdcb14.jar are fairly outdated and no longer supported by Oracle.

Most recent versions are ojdbc5.jar for Oracle 11g, ojdbc6.jar for Oracle 11g and Oracle 12c R1, ojdbc7.jar for Oracle 12c R1 and ojdbc8.jar for Oracle 12c R2 and newer.

The number in the Jar-File names indicates the minimum version of Java these Jars are compatiblie with.

Instead of placing the jars in “\instances\default\lib\jars” they should be placed under “\instances\default\lib\jars\custom” to indicate that these are not default jars but have been added later by customer.

Placing the jars under \instances\default\lib\jars or \instances\default\lib\jars\custom requires a restart of whole IntegrationServer, while placing them under \instances\default\packages\WmJDBCAdapter\code\jars only require a reload of the package WmJDBCAdapter to activate them.

Regards,
Holger