[Qgis-user] Editing Oracle table - can't add feature

[Prud'homme Jérémie]

 Hi,

I have the spatial metadata in the both MDSYS.ALL_SDO_GEOM_METADATA and
USER_SDO_GEOM_METADATA views.
The SRID is well retrieved by Qgis in the add Oracle layer menu. But when I
add the layer to the project QGIS tells me that the CRS is not defined (and
it takes the default one).

The other problem is on the primary key that is not retrieved in the add
Oracle layer menu at all.
I saw in your link that there are 2 functions about primary key :
determinePrimaryKey() and  determineAlwaysGeneratedKeys().
I don't really understand what means AlwaysGeneratedKeys but what I'm sure
about is that the request made in the function works if I run it in SQL
Developer (I get the column name of the primary key for the table 'X')
whereas the request in determinePrimaryKey can't as the table/view
all_tab_identity_cols doesn't exists in my database !


Jérémie.

Le mar. 18 févr. 2020 à 16:45, SPeillet <sebastien.peillet at oslandia.com> a
écrit :

> Hello,
>
> I add my few knowledge about the srid definition. Currently oracle provider
> only check srid in the MDSYS.ALL_SDO_GEOM_METADATA view and not the
> MDSYS.USER_SDO_GEOM_METADATA.
>
> cf.
>
> https://github.com/qgis/QGIS/blob/master/src/providers/oracle/qgsoracleprovider.cpp#L2635
>
> I made some changes about this on my side to check it on both views, I will
> do a PR soon.
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200219/03978dc1/attachment.html>