topic Error in connection - Oracle - TAC setup in Installing and Upgrading

Error in connection - Oracle - TAC setup

Anonymous — Sat, 16 Nov 2024 07:57:18 GMT

Hi,

I'm getting stuck with installing database drivers in my Web application server.

I keep on getting - Cannot connect to database (Could not initialize class oracle.jdbc.driver.DMSFactory) on the connection test.

I've already put the ojdbc6dms.jar and ojdbc6dms_g.jar in <apache-tomcat>/lib but still not working. Has anyone encountered this before?

im using Oracle 11g

Re: Error in connection - Oracle - TAC setup

Anonymous — Tue, 17 Jul 2018 10:42:16 GMT

Hello,

Please make sure you have the correct JDBC driver for your Oracle 11 installed for TAC/Tomcat (in the /endorsed/ or /lib/ folder).

Is your Oracle 11g connection Ok with you in studio?

Best regards

Sabrina

Re: Error in connection - Oracle - TAC setup

Anonymous — Tue, 17 Jul 2018 16:48:40 GMT

Thanks xdshi! it worked, only that i need to put the jar files into both. I did have successful Connection check but i got this error in the Version check part -

500 The call failed on the server; see server log for details

when i checked the logs, it says

18-Jul-2018 01:07:50.745 SEVERE [http-nio-8080-exec-6] org.apache.catalina.core.ApplicationContext.log Exception while dispatching incoming RPC call
com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract void org.talend.gwttoolkit.client.login.service.LoginService.checkLicenseKey(boolean) throws org.talend.gwttoolkit.client.exception.ClientBusinessException,org.talend.gwttoolkit.client.exception.ClientSystemException' threw an unexpected exception: java.lang.IllegalStateException: Unknown database schema version
at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:415)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:605)

I chose Oracle 11g and the jars are ojdbc6.jar, ojdbc6dms.jar, ojdbc6_g.jar and ojdbc6dms_g.jar.

I saw a post related to this, but it doesn't have any answer.

Hope you can advise.

Re: Error in connection - Oracle - TAC setup

Anonymous — Wed, 18 Jul 2018 08:54:51 GMT

Hello,

Would you mind create a case on talend support portal so that we can give you a remote assistance(webex session) through support cycle with priority?

Best regards

Sabrina

Re: Error in connection - Oracle - TAC setup

Anonymous — Fri, 14 Dec 2018 13:13:46 GMT

For Apache Tomcat 8.0, put the JDBC drivers in the <apache-tomcat>/endorsed path. For Apache Tomcat 8.5, you need to put the JDBC drivers in the <apache-tomcat>/lib path. For more information, see Installing database drivers in your Web application server, on the Talend Help Center.