Configuring JDBC adapter connection

Subhajit_Sarkar · September 10, 2016, 4:04pm

I am new to webMethods. I am trying to configure my JDBC Adapter configuration. But I am unable to do it. Here is the steps I do,

Go to http://tech.forums.softwareag.com:5555
Adapters
webMethods Adapter for JDBC
Configure new connection
webMethods Adapter for JDBC connection

I fill up all the details and I enable the connection. I get the following error as soon as I enable the connection:

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MyTestPackage.adapters:myTestAdapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located.
oracle.jdbc.pool.OracleDataSource

Please help.

MR_as173d · September 11, 2016, 6:18pm

Based on your oracle version, place corresponding jar file ( ojdbc14.jar or ojdbc6.jar ) under WmJDBCAdapter/code/jars location. Restart IS and check.

Thanks,

Holger_von_Thomsen · September 12, 2016, 8:22pm

Hi,

what is your oracle server version?
waht is your exact wM Version as well as JDBC Adpater version?

For all wM Versions starzting with 9.x you should use latest ojdbc6.jar or ojdbc7.jar (available since Oracle 12) and place it where MR has described.
Reloading the package should be sufficient.

For further informations check for JDBC Adapter Documentation available from here:
http://techcommunity.softwareag.com/ecosystem/communities/public/_communities/documentation

Regards,
Holger

Subhajit_Sarkar · September 15, 2016, 5:20pm

Hi,

I tried the same but got the same error. I am attaching the screenshots…hope you could get a larger view about the issue.

Thanks
Subhajit

Holger_von_Thomsen · September 15, 2016, 6:40pm

Hi Subhajit,

please make sure that you have placed an ojdbc6.jar or ojdbc7.jar under WmJDBCAdapter/code/jars/ and have reloaded the package from IS Admin UI.

If this does not help check the Conenction configuraiton (as in web.png) for any leading or trailing spaces and remove those.

You can try to explore the server.log for this instance as the error message might be easier to check to additional spaces there.

Regards,
Holger

Mahesh_K_Sreenivas · September 15, 2016, 7:07pm

Hello Subhajit,

Network protocol=tcp is missing.

I would suggest you to read and understand the JDBC adapter guide before setting up JDBC connection. There is a chapter that clearly talks about this.

MR_as173d · September 15, 2016, 8:52pm

Error states that it is unable to locate the class. Keep the right jar as specified , reload the package.

Thanks,

Subhajit_Sarkar · September 17, 2016, 4:54pm

Hi,

I did the same again as told by you all. Now, its showing a different error which I am unable to diagnose. I have attached the screenshot here.

Thanks
Subhajit

Mahesh_K_Sreenivas · September 18, 2016, 5:24pm

Either your DB listener is not up or you are not passing the correct db name. Check your configurations again.

Sasanka · September 19, 2016, 8:52am

I would request you to please use either TOAD or SQL Developer to connect to the DB server and check the connectivity.