topic Re: Specific Driver Installation in Talend Studio

Specific Driver Installation

Anonymous — Thu, 17 Dec 2015 10:16:44 GMT

Hi,
I have an application with a specific driver *.jar.
I use it in Netbean IDE without problem to connect. But I am not able to connect in Talend.
I have tried to use General JDBC, but I have not xml file an returns failure (I think).
I have added the module but this module does not appear in the list of modules.
So my parametres are:
URL: jdbc:BD://GEST_2015_6
BDL.jar
BD.jdbc.LDriver
plus USER & PWD
I would like to know how to add a specific DRIVER for DB Connection.

Thank You

Re: Specific Driver Installation

Anonymous — Fri, 18 Dec 2015 03:17:54 GMT

Hi,
Have you tried to use component tJDBCInput which reads any database using a JDBC API connection and extracts fields based on a query to see if it works?
Please take a look at component reference TalendHelpCenter:tJDBCInput.

Best regards
Sabrina

Re: Specific Driver Installation

Anonymous — Fri, 18 Dec 2015 17:19:13 GMT

Hi,
Thank you for your answer.
I have just tested your solution.
I have the same problem of connection failed.
Message said that the datbase name is not valid, but it is the same value used in the Net Bean IDE.

Best regards

JM

Re: Specific Driver Installation

Anonymous — Wed, 30 Dec 2015 16:44:22 GMT

Hi,

If somebody can tell me how to solve this problem?

May I contact support or talend developers?
Best regards

JM

Re: Specific Driver Installation

Anonymous — Thu, 31 Dec 2015 08:41:45 GMT

Hi JM,
Sorry for delay!
On which talend build version you got that? Talend open source or subsription version?
Best regards
Sabrina

Re: Specific Driver Installation

Anonymous — Fri, 08 Jan 2016 15:16:46 GMT

Hi Sabrina
Thank you for you answer.
I am using Talend Data Integration 6.1 version
Note:"I repeat I can connect to this database using Java IDE, but not using Talend"
Best regards

Jean Marc

Re: Specific Driver Installation

Anonymous — Fri, 08 Jan 2016 16:40:36 GMT

Hi Sabrina,
Sorry, I forgot: I have not Subscription, my version is Open Source.
In fact I am testing Talend because I will need to have a tool that give me flexibility to do integration between Java Data Base, TX & CSV files, SQL Server, MySql, etc.
I think Talend is the tool, I have already connect Talend with MySQL, SQL Server Express (that not have DTS), but with my specific data base BD I am not able to reach!
For you information, I have done a lot of SQL DTSX Project.
Best regards
Jean Marc

Re: Specific Driver Installation

Anonymous — Wed, 13 Jan 2016 03:19:32 GMT

[size=3][font=??] Hi,[/font][/size]
[size=3][font=??] [/font][/size]
[size=3][font=??] Could you please also upload your tJDBCInput component setting screenshot into forum? What's your specific application you are trying to connect to?[/font][/size]
[size=3][font=??] Feel free to create a workitem jira issue of DI project on Talend Bug Tracker.[/font][/size]
https://jira.talendforge.org/secure/Dashboard.jspa
[size=3][font=??] Best regards[/font][/size]
[size=3][font=??] Sabrina[/font][/size]

Re: Specific Driver Installation

Anonymous — Fri, 15 Jan 2016 16:37:19 GMT

Hi Sabrina,
I have uploaded two screenshots tJDBCInput and my NetBean IDE (that works with this driver). My application is a local Accounting System that use JAVA, GESTION4.
Best regards
Jean Marc

Re: Specific Driver Installation

Anonymous — Mon, 18 Jan 2016 06:23:30 GMT

Hi,
[size=2][font="Calibri",sans-serif] Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.[/font][/size]

Best regards

Sabrina

Re: Specific Driver Installation

Anonymous — Tue, 19 Jan 2016 12:22:29 GMT

Hi Sabrina

OK, I have attached the sreenshot files.

best regards
Jean Marc

Re: Specific Driver Installation

Anonymous — Wed, 20 Jan 2016 02:56:43 GMT

Hi,
From your screenshots, we don't find any error in the component setting.
No error message in Window-->Show view-->General-->Error log?
Best regards
Sabrina

Re: Specific Driver Installation

Anonymous — Wed, 20 Jan 2016 11:22:43 GMT

Hi Sabrina

I have uploaded image and error log Below) with step by step process and error logs.

java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: No existe la Base de Datos 'GEST_2015_6'
	at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.getConnection(ExtractMetaDataUtils.java:875)
	at org.talend.metadata.managment.utils.MetadataConnectionUtils.getConnection(MetadataConnectionUtils.java:1216)
	at org.talend.sqlbuilder.repository.utility.SQLBuilderRepositoryNodeManager.updatePackage(SQLBuilderRepositoryNodeManager.java:686)
	at org.talend.sqlbuilder.repository.utility.SQLBuilderRepositoryNodeManager.createNewRepositoryNode(SQLBuilderRepositoryNodeManager.java:660)
	at org.talend.sqlbuilder.repository.utility.SQLBuilderRepositoryNodeManager.getRepositoryNodeByBuildIn(SQLBuilderRepositoryNodeManager.java:599)	at org.talend.sqlbuilder.ui.progress.OpenSQLBuilderDialogProgress.

To see the whole post, download it here
OriginalPost.pdf