Talend community forum / postgresql jar version

anja · 2012-04-24 13:36:31

Tags: [bug, database, date, error, postgres plus, PostgreSQL, schema, TPostresInput, upgrade jar]

hi
I have a data warehouse project.
To implement my DW i use postgres plus 9.0 .
I have finish loading data to my dimensions table.
Now i'm tring to aliment my fact table.
but i have problem :when using tPostgresInput to load data from my dimension i have exception.
i found the problem, actully the jar version used by talend is 8.3 but i need 9.0.

do you have any idea to solve my problem and upgrade the jar version
regards/tks a lot

pedro · 2012-04-25 04:34:58

Hi

Talend is using postgresql-8.3-603.jdbc3.jar to support postgresql.
At postgresql website, I get a suggestion.

Code:

If you are using the 1.6 or 1.7 JVM, then you should use the JDBC4 version for Version 9.1-901

So i'm not sure whether updating this jar file manually might cause unexpected errors.
It seems that jdbc3 and jdbc4 use different API.

Anyway, you might have a try.
Find tPostgresqlInput_java.xml in TOS directory.
Modify the code.

Code:

<IMPORT NAME="Driver-Postgres" MODULE="postgresql-8.3-603.jdbc3.jar" REQUIRED="true" /> // old code
<IMPORT NAME="Driver-Postgres" MODULE="postgresql-9.1-901.jdbc4.jar" REQUIRED="true" /> // new code

Then copy this new jar file into <TOS installation>\lib\java directory.

Or just choose the simplest way.
Report it on BugTracker.

Regards,
Pedro

anja · 2012-04-25 13:19:26

Hi
thx Pedro for your help
i tried your solution but it doesn't work so i modified the file index.xml of the talend as following

<jarsToRelativePath key="postgresql-8.3-603.jdbc3.jar" value="org.talend.designer.components.localprovider_5.0.2.r78327/components/tGreenplumInput/postgresql-8.3-603.jdbc3.jar"/>
<jarsToRelativePath key="postgresql-9.1-901.jdbc4.jar" value="org.talend.designer.components.localprovider_5.0.2.r78327/components/tGreenplumInput/postgresql-9.1-901.jdbc4.jar"/>

and i place postgresql-9.1-901.jdbc4.jar in org.talend.designer.components.localprovider_5.0.2.r78327/components/tGreenplumInput
but the error is

Uploaded Images

pedro · 2012-04-26 04:06:29

Hi

Find tPostgresqlInput_java.xml in TOS directory.
Modify the code as I mentioned above.

Code:

<IMPORT NAME="Driver-Postgres" MODULE="postgresql-9.1-901.jdbc4.jar" REQUIRED="true" />  code

But I think you'd better report it on BugTracker.

Regards
Pedro

danreb · 2012-06-14 06:07:22

this is a recurrent problem since TOS 3.1.1

cfr. http://www.talendforge.org/forum/viewtopic.php?id=15594

the only quick (and dirty) solution I am thinking of

Announcement

Unanswered posts

#1 2012-04-24 13:36:31

postgresql jar version

#2 2012-04-25 04:34:58

Re: postgresql jar version

Code:

Code:

#3 2012-04-25 13:19:26

Re: postgresql jar version

#4 2012-04-26 04:06:29

Re: postgresql jar version

Code:

#5 2012-06-14 06:07:22

Re: postgresql jar version

Board footer