Thanks everyone. I was able to get this up and running.
________________________________
From: [email protected] [[email protected]] on behalf of
Mauro Bartolomeoli [[email protected]]
Sent: Tuesday, September 16, 2014 12:06 PM
To: Price, Robert C.
Cc: [email protected]
Subject: Re: [Geoserver-users] WFS-T and Oracle Views
Hi Robert,
in general, they should be usable. You could have some issues with metadata
recognition by Geoserver on those views, mainly the type of Geometry and
primary key will not be set correctly. If you need them to work with WFS-T you
will probably need to create and populate correcly the geotools metadata tables
for primary keys as explained here:
http://docs.geoserver.org/latest/en/user/data/database/primarykey.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__docs.geoserver.org_latest_en_user_data_database_primarykey.html&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=W7NNKjp8gZKqjir-h_HXLwrr-UX5GVHfRt1dWxeqwBM&e=>
You could also need to create and fill the geotools specific geometry metadata
table, explained here:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html#using-the-geometry-metadata-table<https://urldefense.proofpoint.com/v2/url?u=http-3A__docs.geoserver.org_latest_en_user_data_database_oracle.html-23using-2Dthe-2Dgeometry-2Dmetadata-2Dtable&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=xQOd8OqPGtHT1Rt2GXYgtYZeGuql8C3frPt4JqPOY0E&e=>
Regards,
Mauro Bartolomeoli
2014-09-15 22:24 GMT+02:00 Price, Robert C.
<[email protected]<mailto:[email protected]>>:
Earlier, GeoServer did not support wfs-t on top of Oracle views. Does anyone
know if this is still the case or if this has been added as a feature. I have
tried to do use WFS-T with a view and have not been successful thus far.
Thanks
Robert
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.
------------------------------------------------------------------------------
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<https://urldefense.proofpoint.com/v2/url?u=http-3A__pubads.g.doubleclick.net_gampad_clk-3Fid-3D157508191-26iu-3D_4140_ostg.clktrk&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=-s9M7X-tcBPJ9a6MM19CcSbtjcqx1UEfJAsz7XEwN1I&e=>
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_geoserver-2Dusers&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=PM9y1N9QfkM1sZFFGIKqy3jU-qlWUFx0kHiCf3oKiuI&e=>
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2<https://urldefense.proofpoint.com/v2/url?u=http-3A__goo.gl_NWWaa2&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=qCTr5q09vycW40iQMucR3RIy8BTmZcG7y8wXgQ_g3bw&e=>
for more information.
==
Dott. Mauro Bartolomeoli
@mauro_bart
Senior Software Engineer
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
http://www.geo-solutions.it<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.geo-2Dsolutions.it&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=Kyn_PUErCY1TqiUi7yHTmI3_EvDI5hdttIbW_KbSx9I&e=>
http://twitter.com/geosolutions_it<https://urldefense.proofpoint.com/v2/url?u=http-3A__twitter.com_geosolutions-5Fit&d=AAMFaQ&c=jF7FvYH6t0RX1HrEjVCgHQ&r=5noV4C9SgSSn9Yiah-dlOQ&m=XAeJBVIYYZi0v5w-P-w3YxytwFygN28DGJzO3JevZoE&s=D6jT2iXPXIiUP6f-P8fM228E_2rONvcj7BAmi_4Vuo4&e=>
-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo
è consentito esclusivamente al destinatario del messaggio, per le finalità
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro
sistema. Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse,
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the
attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act (Legislative
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in
accord with its purpose, any disclosure, reproduction, copying, distribution,
or either dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the intended
recipient, please contact immediately the sender by telephone, fax or e-mail
and delete the information in this message that has been received in error. The
sender does not give any warranty or accept liability as the content, accuracy
or completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
