cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Merrin <>
Subject Re: Select Query on Table with no Primary Key
Date Thu, 07 Jun 2007 10:20:27 GMT
Hi Tore,

I understand there will be limitations in the use of cayenne if there is 
no primary key; I can work with these.

I'm using an Oracle database. The views were created to give restricted 
access to the data. The tables may have primary keys but I can't get 
these added to the views.

We already use Cayenne on a different project so we have a lot of code 
to make things easier for us. This is the main reason I'm not looking at 
alternatives to solve the problem.



Tore Halset wrote:
> On Jun 6, 2007, at 16:12 , Dave Merrin wrote:
>> I'm trying to run a SelectQuery on a table with no primary key. 
>> Unfortunately it's not working. Can anybody help? I have no control 
>> over the database so I can't add in primary keys.
> As you know the PK are essential not only to update a row, but to make 
> sure a single row maps to a single DataObject in your context.
> Some database engines do have a unique invisible column. If your 
> database does this, then perhaps you could map that column as your 
> primary key? What database engine are you using?
> Regards,
>  - Tore.

View raw message