topic Re: Add a new JDBC parameter for Postgres in Talend Studio

Add a new JDBC parameter for Postgres

Anonymous — Thu, 10 Dec 2015 16:56:59 GMT

Hi everyone !
I've got a problem with my pretty integration process !
I have to integrate some data in a Postgres database but there is some encoding problems !
I read somewhere that I had to add a JDBC parameter like this : "charSet=ISO-8859-1", but I really don't know where I sould put it.

The problematic part of my process look a this ! (see the attached screen)
Thank you by advance !

Re: Add a new JDBC parameter for Postgres

Anonymous — Fri, 11 Dec 2015 11:58:49 GMT

First of all, check if the problem is actually the database. If it the case, you do not need such property. Take care the tables are created with the correct encoding setting.

Re: Add a new JDBC parameter for Postgres

Anonymous — Sun, 13 Dec 2015 19:01:28 GMT

I run the job on my local machine and didn't met any encoding problem but when I run the job on a VM, there is encoding problem !
So I don't think that the problem comes from the DB...
I tried to force the chcp code in the console but it didn't change anything !
So, in my opinion, the only thing I can do is to force the encoding in the job !

Re: Add a new JDBC parameter for Postgres

Anonymous — Mon, 14 Dec 2015 10:57:57 GMT

FYI : I'm working on TOS 5.6

Re: Add a new JDBC parameter for Postgres

Anonymous — Tue, 15 Dec 2015 07:49:24 GMT

Hi FloCAD,
Have you tried to add the parameter "charSet=ISO-8859-1" to the JVM parameters to see if it works?

Best regards
Sabrina

Re: Add a new JDBC parameter for Postgres

Anonymous — Tue, 15 Dec 2015 08:32:06 GMT

Ah thx a lot Sabrina ! It was what I was searching for !
But unhappily, when I run it, I obtain the following error code : "Erreur : impossible de trouver ou charger la classe principale charSet=ISO-8859-1"
(in English, it sound like : Error: Can not find or load the main class charSet = ISO-8859-1)

Re: Add a new JDBC parameter for Postgres

Anonymous — Tue, 15 Dec 2015 09:58:26 GMT

I tried : -Dfile.encoding="ISO-8859-15" (found there) and the job ran but it didn't work to in the DB, the encoding problems were there again...
I start to give up...

Oh sorry ! I forgot to specify that, in Talend, with a tLogRow, I can visualise the data without encoding problem ! But in the console (with an exported job in .bat), this same tLogRow has encoding problems !
And in all cases, in the DB I always have encoding problems ...

Re: Add a new JDBC parameter for Postgres

Anonymous — Tue, 15 Dec 2015 13:38:08 GMT

Okay I finally found the solution !
For the others who have the same problem, juste follow those steps :
- go to C:\TOS\TOS_DI-Win32-20141207_1530-V5.6.1\plugins\org.talend.designer.components.localprovider_5.6.1.20141207_1530\components\tPostgresql[the different postgres component you use]\[the different postgres component you use].xml and set the parameter where the encoding SHOW="true" ! (now, you can modify the encoding dynamically in talend)
- Then, in your process, setup the encoding parameters in all [the different postgres component you use]
- And then, put in the advanced settings of the JVM, the following parameter : -Dfile.encoding="ISO-8859-15"
Take care to always specify the same encoding a lot of time can lost some caracters !

Re: Add a new JDBC parameter for Postgres

Anonymous — Wed, 16 Dec 2015 07:16:18 GMT

Hi,

For the others who have the same problem, juste follow those steps :
- go to C:\TOS\TOS_DI-Win32-20141207_1530-V5.6.1\plugins\org.talend.designer.components.localprovider_5.6.1.20141207_1530\components\tPostgresql[the different postgres component you use]\[the different postgres component you use].xml and set the parameter where the encoding SHOW="true" ! (now, you can modify the encoding dynamically in talend)
- Then, in your process, setup the encoding parameters in all [the different postgres component you use]
- And then, put in the advanced settings of the JVM, the following parameter : -Dfile.encoding="ISO-8859-15"
Take care to always specify the same encoding a lot of time can lost some caracters !

Thanks for your feedback and sharing your solution with us.
Best regards
Sabrina