[Geoserver-users] Wrong Date-Value using Oracle-Datastore

GeoServer GeoServer User
1

Hello,

Justin do you think that there e.g. will be subtract an hour from the
recieved date?
This will mean that 2007-04-23 will be converted to 2007-04-22 23:00:00 ?
This would be horrible.

Has anyone some experiences to german date values and geoserver?

Tim

-----Ursprüngliche Nachricht-----
Von: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net]Im Auftrag von Tim
Englich
Gesendet: Freitag, 15. Juni 2007 21:05
An: Justin Deoliveira
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hello Justin,
we have this problems on different Systems.

When there is a timezone attached it would be central european time. Our
server runs with the same timezone.

do you know somethink about the method which converts the Date to String?

Tim

-----Ursprüngliche Nachricht-----
Von: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Gesendet: Fr 15.06.2007 20:28
An: Tim Englich
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hi Tim,

Does the date in the database have a timezone attached to it? If so when
the date gets pulled into java it will be converted to the local time
zone. Then probably getting written out without the timezone info
attached. Just a guess.

-Justin

Tim Englich wrote:

Hello everybody,

we think have found an issue using the Oracle Datastore.
We use the 1.5.0 Release of Geoserver
We get a Date-Value in the response which is one Day wrong.

We get 2007-04-22 the Value in the Database is 2007-04-23.

When we use the Oracle-DataStore directly everything works fine.
Might this issue occurs while creating the output?

Our System is like this:

Oracle 9.2 Database (We use JDBC-Connection)
Java Version 1.6.0
Servlet Container apache-tomcat-5.5.20

Has anyone an idea how to solve this issue?

Tim

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,4672d55d127591628642973!

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

2

Hi,

Perhaps you could have a try by making a view, and select your date column into the view by using Oracle TO_CHAR function?

-Jukka Rahkonen-

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net on behalf of Tim Englich
Sent: Sat 16.6.2007 16:56
To: Tim Englich; Justin Deoliveira
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hello,

Justin do you think that there e.g. will be subtract an hour from the
recieved date?
This will mean that 2007-04-23 will be converted to 2007-04-22 23:00:00 ?
This would be horrible.

Has anyone some experiences to german date values and geoserver?

Tim

-----Ursprüngliche Nachricht-----
Von: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net]Im Auftrag von Tim
Englich
Gesendet: Freitag, 15. Juni 2007 21:05
An: Justin Deoliveira
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hello Justin,
we have this problems on different Systems.

When there is a timezone attached it would be central european time. Our
server runs with the same timezone.

do you know somethink about the method which converts the Date to String?

Tim

-----Ursprüngliche Nachricht-----
Von: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Gesendet: Fr 15.06.2007 20:28
An: Tim Englich
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hi Tim,

Does the date in the database have a timezone attached to it? If so when
the date gets pulled into java it will be converted to the local time
zone. Then probably getting written out without the timezone info
attached. Just a guess.

-Justin

Tim Englich wrote:

Hello everybody,

we think have found an issue using the Oracle Datastore.
We use the 1.5.0 Release of Geoserver
We get a Date-Value in the response which is one Day wrong.

We get 2007-04-22 the Value in the Database is 2007-04-23.

When we use the Oracle-DataStore directly everything works fine.
Might this issue occurs while creating the output?

Our System is like this:

Oracle 9.2 Database (We use JDBC-Connection)
Java Version 1.6.0
Servlet Container apache-tomcat-5.5.20

Has anyone an idea how to solve this issue?

Tim

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,4672d55d127591628642973!

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

3

Not quite, the problems i have run into (and i can only speak from
postgis) is when a timezone is stored with the date in the database. For
instance a time with a +2 zone offset:

2007-06-20 02:00+02:00

When this date gets read into java it is stored internally in the native
timzone for that locale, so for me the date becomes:

2007-06-19 16:00-08:00

SO depending on how this date gets written out and read back in it could
potentially lose the timezone.

Its tough to say though without having a database to test with. I know
andrea has an oracle install around, perhaps he can do a little test for us.

-Justin

Tim Englich wrote:

Hello,

Justin do you think that there e.g. will be subtract an hour from the
recieved date?
This will mean that 2007-04-23 will be converted to 2007-04-22 23:00:00 ?
This would be horrible.

Has anyone some experiences to german date values and geoserver?

Tim

-----Ursprüngliche Nachricht-----
Von: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net]Im Auftrag von Tim
Englich
Gesendet: Freitag, 15. Juni 2007 21:05
An: Justin Deoliveira
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hello Justin,
we have this problems on different Systems.

When there is a timezone attached it would be central european time. Our
server runs with the same timezone.

do you know somethink about the method which converts the Date to String?

Tim

-----Ursprüngliche Nachricht-----
Von: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Gesendet: Fr 15.06.2007 20:28
An: Tim Englich
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Wrong Date-Value using Oracle-Datastore

Hi Tim,

Does the date in the database have a timezone attached to it? If so when
the date gets pulled into java it will be converted to the local time
zone. Then probably getting written out without the timezone info
attached. Just a guess.

-Justin

Tim Englich wrote:

Hello everybody,

we think have found an issue using the Oracle Datastore.
We use the 1.5.0 Release of Geoserver
We get a Date-Value in the response which is one Day wrong.

We get 2007-04-22 the Value in the Database is 2007-04-23.

When we use the Oracle-DataStore directly everything works fine.
Might this issue occurs while creating the output?

Our System is like this:

Oracle 9.2 Database (We use JDBC-Connection)
Java Version 1.6.0
Servlet Container apache-tomcat-5.5.20

Has anyone an idea how to solve this issue?

Tim

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com