Timezone problem with ingres JDBC
- From: "nickc" <nick.creek@xxxxxxxxx>
- Date: 11 Oct 2005 19:57:00 -0700
Hi,
We are running ingres 2 on unixware 7.1.1. We have the ingres2.5
ingresnet installed on a windows server being used to report from via
ODBC, and also running some sql queries from another application via
the JDBC:ODBC bridge as well.
Our issue is to do with timezones (our timezone is GMT+10) via JDBC.
I've read some posts and other websites to do with this issue, but am
unable to work out a solution as yet.
On the windows server, when I do a simple select on a datetime field in
the database via the odbc, I get the correct time (or at least the same
time as what is on the unix host application) On the ingres database
server, ingprenv states "II_TIMEZONE_NAME=australia-victoria" . When I
use the JDBC:ODBC bridge, the value returned is less 10 hours than what
I am expecting. I am not sure if the JDBC is getting the date stored in
the database, without adding the 10 hours, or if it is subtracting ten
hours from the date stored in the database (i am guessing the former,
if my understanding is close).
On the windows server, I have modified the timezone for ingres via
ingsetenv, but this only made the datetime select via ODBC return the
time value of 'less 10 hours' also.
I don't have access to the application that calls the sql via jdbc, but
can replicate the problem using squirrelSQL. Can I fix the problem of
JDBC not picking up the timezone by modifing the timezone settings
somewhere?
Many thanks in advance,
nick
.
- Prev by Date: Re: IIZIC on VMS
- Next by Date: Re: IIZIC on VMS
- Previous by thread: Re: [Info-ingres] Re: 6.4: IPM can not find (name)server
- Next by thread: Re: [Info-ingres] Identifying database procedure hierarchies
- Index(es):
Relevant Pages
|
