If I understood correctly, you don't get primary key recognized when user used in connection string is not owner of data ?<div><br></div><div>I am looking into code and it seems that that in such case when you do not use 'OracleSchema' connection property of King.Oracle, primary key wouldn't be recognized.</div>
<div><br></div><div>If you would set King.Oracle connection property 'OracleSchema' to owner of that table then primary key in your case would be recognized ?</div><div><br></div><div>But then you could have Oracle user which could have access to multiple schema's which he doesn't own and then again primary keys wouldn't be correctly recognized.</div>
<div>So, on quick look it seems it is bug in provider.</div><div><br></div><div>Haris<br><br><div class="gmail_quote">On Wed, Feb 24, 2010 at 2:06 PM, Crispin_at_1Spatial <span dir="ltr"><<a href="mailto:crispin.hoult@1spatial.com">crispin.hoult@1spatial.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br>
Hi,<br>
<br>
Where a KingOra connection is made to a user that has no ownership of data<br>
but is instead allocated access via roles and groups (not views) the code<br>
that finds the PKey - GetTablePkeyColumns() - passes in the "Owner" for an<br>
optimised query against USER_CONSTRAINTS.<br>
<br>
Maybe it's my misunderstanding of the "Owner" -- if this the user logged<br>
onto the DB with the connection properties then this is wrong? There is an<br>
entry against the ALL_CONSTRAINTS but that's a slow query.<br>
<br>
Maybe I am creating my connection parameters wrong?<br>
<br>
Thought I'd post here before submitting a ticket on this...<br>
<br>
Crispin<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://n2.nabble.com/KingOra-Cannot-Find-Primary-Key-with-Some-Database-Roles-tp4625565p4625565.html" target="_blank">http://n2.nabble.com/KingOra-Cannot-Find-Primary-Key-with-Some-Database-Roles-tp4625565p4625565.html</a><br>
Sent from the FDO Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
</font></blockquote></div><br></div>