[Qgis-user] QGIS and Oracle Views

[Jonathan Moules]

Hi Rob,
Thanks for the suggestion. I've already registered with USER_SDO_GEOM_METADATA to even get the table listed in the "Add table" dialog.

Selecting a geometry and/or primary key column don't work I'm afraid. I've also tried the "Select at id" checkbox on and off, but to no avail. Hence my wondering if QGIS supports views.

I get this back:

dbname='production.hw-uk.local' host=host port=1521 user='USER' password='PASSWORD' key='PKEY' estimatedmetadata=true srid=8307 type=POLYGON table="SZACCOUNTS"."JMO_TEMP_VIEW" (GEOMETRY) sql= is an invalid layer - not loaded

Has anyone else had success pointing to Oracle Views? How about PostGIS views, do they work?

Cheers,
Jonathan

-----Original Message-----
From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Rob L
Sent: Tuesday, October 14, 2014 8:25 AM
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] QGIS and Oracle Views

Jonathan,

I think as long as the view is registered in the `USER_SDO_GEOM_METADATA` table then you should be able to add them in QGIS.

Think at the "Add Oracle Table(s)" dialog you just have to select a geometry "Type" and a "Primary key column" using the drop downs.

Let me know how you get on.

Rob



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/QGIS-and-Oracle-Views-tp5166520p5167358.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user


This message has been scanned for viruses by MailControl - www.mailcontrol.com



Click https://www.mailcontrol.com/sr/yhxqFe!!ur!GX2PQPOmvUhStAXlT3N1zBgU!bku7KNXHzabdgX!LQrHMmaV05UyNdme+0SYzKNn1VsBVsOva5A== to report this email as spam.

________________________________

HR Wallingford and its subsidiaries uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them.
If you have received this message in error please advise us immediately and destroy all copies of it.

HR Wallingford Limited
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
Registered in England No. 02562099

________________________________