Error in connection - Oracle - TAC setup

Highlighted
Four Stars

Error in connection - Oracle - TAC setup

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

 

talend_driver.PNG

 

 

 


Accepted Solutions
Moderator

Re: Error in connection - Oracle - TAC setup

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: Error in connection - Oracle - TAC setup

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Error in connection - Oracle - TAC setup

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. 

 

Moderator

Re: Error in connection - Oracle - TAC setup

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Community Manager

Re: Error in connection - Oracle - TAC setup

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download