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