Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Rem1
Contributor
Contributor

Adding parameters for a Ingres DB JDBC connection

I have a full installation of the Ingres client on my desktop. This installation provides the ODBC connection possibility, and also a JDBC librairy. The "iijdbc.jar" provided with the client installation uses a file called "iijdbc.properties", in which we can add some parameters for date handling and timezone settings :
- ingres.jdbc.date.empty=NULL
- ingres.jdbc.property.timezone=NA-EASTERN
So I was thinking that the Ingres JDBC librairy provided with Talend was working the same way, but it doesn't seems to. I can find the jar file (iijdbc.jar) in the Talend installation folder, but there's no properties file I can edit. Is someone aware of how can I add these two parameters to the librairie that Talend is using? My research so far have been unsucessful. 
Labels (3)
1 Reply
Anonymous
Not applicable

Hi,
Could you please try to add your properties into JVM arguments to see if it works?
Best regards
Sabrina
0683p000009MDOM.png