Setting TIMEZONE in INGRES 2.6 using jdbc (edbc.jar)

[pwelti]

Hi,
I need know how setting a TIMEZONE (II_TIME_ZONE variable) using edbc.jar to connecting a INGRES 2.6

In INGRES 2006, using iijdbc.jar, only need complete connection string with attribute (ie TZ=GMT-4). But isn't supported in edbc.jar/INGRES 2.6

Can anybody tell me how set this variable?

Thank you

[petda03]

Hello pwelti

I don't think you'll be able to do this directly using iijdbc.jar to the Ingres jdbc server in the 2.6 installation.

You can achieve the same aim by going through the DAS server in a separate 2006/9.2 installation (whether remotely or on the same machine as the Ingres 2.6 installation).

Instead of referencing the jdbc server in the 2.6 installation you should reference the listen address for the DAS Server in the 2006/9.2 installation. You can then further reference the 2.6 installation either setting the ii.NODENAME.gcn.remote_vnode CBF parameter for that 2006/9.2 installation or referencing the Ingres/net vnode directly (see setting Default nodes in connectivity guide or http://docs.ingres.com/Ingres/9.2/Co...emotenodes.htm )

So, an example connection string for your java prog might be:

Connection con = DriverManager.getConnection("jdbc:ingres://NODENAME:PORT/DBNAME;TZ=NA-EASTERN","USER","PASSWD" );

(where you set your TZ to whatever valid value you want)

On the 2006/9.2 installation on NODENAME in config.dat (set through cbf!!)

ii.NODENAME.gcn.remote_vnode: Ingres2.6NODE

If you don't set remote_vnode then the connection string would be:

Connection con = DriverManager.getConnection("jdbc:ingres://NODENAME:PORT/VNODE:BNAME;TZ=NA-EASTERN","USER","PASSWD" );

And that should allow you to connect up to the 2.6 installation using the 2006/9.2 DAS server and iijdbc.jar.

HTH

Dave

[pwelti]

Works fine!

Thanks you a lot petda03.