Adding parameters for a Ingres DB JDBC connection

Highlighted
Four Stars Rem
Four Stars

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. 
Moderator

Re: Adding parameters for a Ingres DB JDBC connection

Hi,
Could you please try to add your properties into JVM arguments to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download