Talend community forum / How to update the configured JDBC driver

james73 · 2011-05-10 11:47:36

Hi,

I need to update the JDBC driver associated with PostgreSQL tInput/tOutput.

Can someone please advise how I go about doing this, I did update the following file to reference the new JAR (JDBC4) file which I copied to the same path

\plugins\org.talend.designer.components.localprovider_4.2.0.r59885\components\tPostgresqlInput\tPostgresqlInput_java.xml

I restarted Talend but it does not recognise the changes.

(Talend v4.2.0)

Cheers

jnbarthas · 2011-05-10 12:42:02

Hello,

in case of failure you could also use the generic JDBC connection with the appropriate and explicit driver.
But you would need to upgrade many components from Postgre to Generic.
OK for test without Postgre specific components need.

JNB

james73 · 2011-05-10 12:58:10

I specifically want to change the driver from 8.3 to 8.4 and will soon need to change to 9.x. I tried your suggestion but Windows 7 64 bit seems to have issues with ODBC which I am struggling to get fixed. It will probably be easier to do it in the Talend configuration.

Many thanks

Last edited by james73 (2011-05-10 15:24:18)

james73 · 2011-05-11 10:31:48

I must say that I don't know if it is a Talend issue or an opensource issue but I can never understand why it is so difficult to get a solution to something that is so simple.

If Talend gave me an option to buy a licensed version of Talend Studio for $99 and if I wanted extended features pay $199 (pricing just as an example) and then know I have support I would but it's so cryptic and you have chat to a sales team and do a whole requirements analysis ...........

I think Talend need to change their business model to make purchasing licenses more transparent and simpler for those wanting to buy the product.

My 2 cents.

danreb · 2011-06-03 07:07:57

with TOS 3.1.1 (not tested on Talend v4.2.0) it actualy works like that (update from postgresJdbc 8.3 to postgresJdbc 9.0.3) :
N.B.: under my project the only components where a postgresjdbc.jar is present is the tPostgresqlInput component

here are the few steps:
- close TOS
- discard the the old jdbc.jar under TOS\lib\java\
- rename to *.jarOLD the old jdbc.jar under your folder \plugins\org.talend.designer.components.localprovider_X.X.X.xxxxx\components\tPostgresqlInput\
- copy at the same place your new jdbc.jar i.e under \plugins\org.talend.designer.components.localprovider_X.X.X.xxxxx\components\tPostgresqlInput\
- rename this new copied jdbc.jar with the same name as the old one (i.e. like it is writtent in the tPostgresqlInput_java.xml file)
- open TOS

I agree this is kind of messy, you keep going with a jar call "OldVersion" which actualy is the "NewVersion" ( I would have rather liked to be able to rename the reference to the new jdbc.jar in the XML file, but if I do that, It is not working , the jar is neither regenerated in the TOS/JAVA/LIB folder nor is it exported in the Project script ).
Anyway it is the only work around I could find ( the export jobscript works well as well, i.e. the OLDNew jdbc.jar is exported in the script)!

Can you please try and Tell me if it works for TOSV4.0.2?

james73 · 2011-06-03 09:13:35

Will try it today and let yo know.

Cheers

danreb · 2012-06-14 23:18:03

tested OK on TOS 5.1.1

Announcement

Unanswered posts

#1 2011-05-10 11:47:36

How to update the configured JDBC driver

#2 2011-05-10 12:42:02

Re: How to update the configured JDBC driver

#3 2011-05-10 12:58:10

Re: How to update the configured JDBC driver

#4 2011-05-11 10:31:48

Re: How to update the configured JDBC driver

#5 2011-06-03 07:07:57

Re: How to update the configured JDBC driver

#6 2011-06-03 09:13:35

Re: How to update the configured JDBC driver

#7 2012-06-14 23:18:03

Re: How to update the configured JDBC driver

Board footer