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.
Cheers,
Dave
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.
