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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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