Can't see logs in Integration service. JDBC connection issue

What product/components do you use and which version/fix level are you on?

Using Integration Server - 10.11.0.0
Software Ag Designer - 10.11.0.0

Is your question related to the free trial, or to a production (customer) instance?

Using free trial version.

What are you trying to achieve? Please describe it in detail.

Creating flat file schema. Successfully got records in Results of Designer. But unable to see logs on IS.

Do you get any error messages? Please provide a full error message

Error Message -
Unable to save event in table. Details: Unable to get JDBC connection from ISInternal. conn=(null)

Have you installed all the latest fixes for the products and systems you are using?

Yes installed all latest fixes like - downloading ojdbc14.jar

Hi Prakhar,

ojdbc14.jar was developed for Java 1.4 and does not support latest JDBC 4.x versions.

Most likely you should check for the latest ojdbc-jar from Oracle like ojdbc10.jar developed for Java 10 and newer.

BTW: Audit logging does not require an ojdbc-jar anyway as the IS is using a bundled (& branded) DataDirect-Driver by default for the internal JDBC-Pools.
And the IS Server Log is configured to use logs/server.log on a file base by default.

Please provide more detailed error messages when the tips above do not help.

Regards,
Holger

3 Likes

While enabling webMethods Adapter for JDBC Connection at - IS> Adapters > webMethods Adapter for JDBC > Connections .

I’m getting error that oracleDataSource cannot be located.
(Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Udemy_training.Connection:Orcldatabase.
[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 )

For which I’ve provided ojdbc-jar. ( which I read as a solution in one Thread) but it’s not fixing. So what Can I do next ?

Hi Prakhar,

where did you place the ojdbc-jar?
Was the WmJDBCAdapter package reloaded afterwards?
Depending on where the jar has been placed it might be neccessary to shutdown and restart there IS.

As already mentioned above, check for recent version of the ojdbc-jar (ojdbc10.jar for Oracle 19c).
ojdbc14.jar is considered outdated and should not be used any longer.

Regards,
Holger

I placed ojdbc11.jar in C:\SoftwareAG\IntegrationServer\packages\WmJDBCAdapter\code\jars
and then I restarted IS but still got same error.

Hi Prakhar,

this is the wrong location.
Please copy the jar to C:\SoftwareAG\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars and reload the WmJDBCAdapter package afterwards.

The location you have used will only be used when creating new IS instances from this installation.

Regards,
Holger