I try to write and select feature from Oracle datastore in WFS-T and it is impossible to handle time written in Oracle database.
I try to manage myself the schema with this tuto and it doesn’t work. http://docs.geoserver.org/stable/en/user/services/wfs/schemamapping.html
Is there a way to insert and get datetime property with a correct timezone from geoserver?
I think it’s a big issue for Geoserver with Oracle, if we can’t handle a datetime attribute!
Regards,
Jeremie
Geomatics engineer
Hi,
I know there are issues with timezone preservation because the JVM handles
Date objects in the current JVM timezone, and not all code paths are taking
that into account (parsing, encoding to the db, and so on, plus we don’t have
a separate management of timestams with timezones and without in the
various database backends).
If you have coding time or funding to throw at the problem the community would
certainly be happy to get a solution (or even just and improvement) on the
current situation.
I know that when dealing with multitemporal data we normally set the JVM
to run in GMT, but probably that works well because all the metereological
data is stored also in GMT
Cheers
Andrea
On Mon, Sep 15, 2014 at 8:41 PM, Jérémie Fortin-Groulx <geojim08@anonymised.com> wrote:
I try to write and select feature from Oracle datastore in WFS-T and it is impossible to handle time written in Oracle database.
I try to manage myself the schema with this tuto and it doesn’t work. http://docs.geoserver.org/stable/en/user/services/wfs/schemamapping.html
Is there a way to insert and get datetime property with a correct timezone from geoserver?
I think it’s a big issue for Geoserver with Oracle, if we can’t handle a datetime attribute!
Regards,
Jeremie
Geomatics engineer
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
Hi,
We tried to do the same but finally we just desided to cast Oracle dates to strings for WFS-T and convert strings back to Oracle dates with triggers when doing inserts/updates. We have been happy with the workaround for several years now but we do not need to handle several timezones which makes our case rather simple.
-Jukka Rahkonen-
Jérémie Fortin-Groulx wrote:
I try to write and select feature from Oracle datastore in WFS-T and it is impossible to handle time written in Oracle database.
I try to manage myself the schema with this tuto and it doesn’t work. http://docs.geoserver.org/stable/en/user/services/wfs/schemamapping.html
Is there a way to insert and get datetime property with a correct timezone from geoserver?
I think it’s a big issue for Geoserver with Oracle, if we can’t handle a datetime attribute!
Regards,
Jeremie
Geomatics engineer
Thanks all for your answers! I just wanted to be sure that there is no fix for this issue. We will see if we can live with this workaround with string. If we opt for a Geoserver architecture for the Town of Montreal, it will be a good idea to funding this feature.
Cheers!
Jeremie
Geomatics engineer