Re: Select Query on Table with no Primary Key

From: Dave Merrin (dmerri..pasystems.co.uk)
Date: Thu Jun 07 2007 - 06:20:27 EDT

  • Next message: Andrus Adamchik: "Re: Select Query on Table with no Primary Key"

    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.
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Jun 07 2007 - 06:22:58 EDT