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
SQL> select sysdate as original from dual;
ORIGINAL
----------
29.10.2013
This SQL you can use in your view
SQL> select to_char(sysdate,'YYYY-MM-DD') as ISO from dual;
ISO
----------
2013-10-29
Or then this SQL if you want to maintain the Z
SQL> select to_char(sysdate,'YYYY-MM-DD')||'Z' as ISOZ from dual;
ISOZ
-----------
2013-10-29Z
-Jukka Rahkonen-
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 ?? :)
De : Garey Mills [mailto:gmi...@library.berkeley.edu]
Envoyé : 23 octobre 2013 11:21
À : Chamberland, Martin
Cc : Jonathan Moules;
geoserver-users@lists.sourceforge.net<mailto: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.chamberl...@fadq.qc.ca<mailto:martin.chamberl...@fadq.qc.ca>> 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:jonathanmou...@warwickshire.gov.uk<mailto:jonathanmou...@warwickshire.gov.uk>]
Envoyé : 22 octobre 2013 09:50
À : Chamberland, Martin
Cc :
geoserver-users@lists.sourceforge.net<mailto: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.chamberl...@fadq.qc.ca<mailto:martin.chamberl...@fadq.qc.ca>> wrote:
Did you have time to take a look at our problem ?
Thank's!
Martin C.
De : Jonathan Moules
[mailto:jonathanmou...@warwickshire.gov.uk<mailto:jonathanmou...@warwickshire.gov.uk>]
Envoyé : 21 octobre 2013 08:40
À : Chamberland, Martin
Cc :
geoserver-users@lists.sourceforge.net<mailto: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.chamberl...@fadq.qc.ca<mailto:martin.chamberl...@fadq.qc.ca>> 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<mailto: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@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users