Hi,
I installed a new 2.4.1 and Oracle datastore, created a new store from Oracle (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options) and created a new featuretype. WFS output is sending dates as “2012-11-27Z” so for me Geoserver 2.4.1 works as the old version used to work for you.
By the way, I was not sure about the date with timezone but after some reading the format 2012-11-27Z seems to OK and mean the first second of a day in UTC time.
So this issue does not seem to be a general bug in Geoserver because it does not affect all installations. There must be something in your system or data that is not the most typical.
You can, if you wish, fix the date output in few minutes by creating a view and selecting the date from Oracle into text. That is also a way to get rid of the Z you had before it you do not like it. Here are some examples:
Default date output format on console with Finnish settings
select sysdate as original from dual;
ORIGINAL
···
Chamberland, Martin wrote:
Hi there,
Anyone find a fix or why we receive date “1969-12-31” when we access Oracle database from Geoserver 2.4.1 ?
Is my explanation not enough clear ?
PS: maybe someone in French can help me translate my real problem, any French people ?? J
De : Garey Mills [mailto:gmills@anonymised.com]
Envoyé : 23 octobre 2013 11:21
À : Chamberland, Martin
Cc : Jonathan Moules; geoserver-users@lists.sourceforge.net
Objet : Re: [Geoserver-users] date BUG 2.4 Geoserver
I believe the problem that Martin is having is that all the dates are the epoch (1969-12-31), in other words, the app is not reading the system time, or the system time (use ‘date’ on a Unix system) is seriously messed up. The problem is probably going to me in whatever code is accessing system time (new Date() for example. Did geoserver change anything about accessing system time in the 2.4 release?
On Wed, Oct 23, 2013 at 5:40 AM, Chamberland, Martin <Martin.Chamberland@anonymised.com> wrote:
It’s pretty hard for me to explain correctly because english in not my first language. Let’s try my best.
We where running geoserver 2.2.3 for a long time and everything was running fine. The only problem (that is not one) we had was that in the output date, there was a “Z” after all date.
So we were sure that is was a bug, so we decide to update to geoserver 2.4 (latest one) to fix the issue. Meantine (continuing searching) we discover that it’s not a bug but just normal that the “Z” appear there. But as we where now running 2.4, now all date that we output from our Oracle database are “1969-12-31”, every date are the same.
I hope i was enough clear, sorry again for poor English explanation.
Martin C.
De : Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Envoyé : 22 octobre 2013 09:50
À : Chamberland, Martin
Cc : geoserver-users@lists.sourceforge.net
Objet : Re: [Geoserver-users] date BUG 2.4 Geoserver
Hi Martin,
I’m not sure what you’re asking here - without further information I suspect you won’t get any help as it’s not clear what you want.
Jonathan
On 22 October 2013 14:32, Chamberland, Martin <Martin.Chamberland@anonymised.com> wrote:
Did you have time to take a look at our problem ?
Thank’s!
Martin C.
De : Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Envoyé : 21 octobre 2013 08:40
À : Chamberland, Martin
Cc : geoserver-users@lists.sourceforge.net
Objet : Re: [Geoserver-users] date BUG 2.4 Geoserver
Hi Martin,
That’s the ISO standard for date formatting. https://en.wikipedia.org/wiki/ISO_8601
Could you be clearer what the problem is for you?
Jonathan
On 17 October 2013 19:38, Chamberland, Martin <Martin.Chamberland@anonymised.com> wrote:
Hi there,
We just install the new version Geoserver 2.4 and from now we seem to receive some strange date format in our request.
All date output create by our trigger look like this: 1969-12-31.
Is there maybe a bug in the 2.4 version ?
Martin C.
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users