Thanks and PK questions

From: McBrayer, Roy (Roy.McBraye..ail.va.gov)
Date: Thu Jul 15 2004 - 12:39:05 EDT

  • Next message: Jonathan Carlson: "Simple retrieval of an object by PK"

    Thanks to all. I restarted the Oracle database and the problem went away.
    Everything is working now and my query is returning a value.

    I have a question about primary keys in Cayenne. For tables, that do not
    have a primary key in the actual database, it appears that Cayenne requires
    me to designate a primary key. If a designate multiple fields as a primary
    key, does Cayenne use this as a combined key. Also, can I create a primary
    key that is unrelated to the database and is just tracked internally by
    Cayenne?

    Thanks to everyone for helping me to get my first simple app up and running.

    Roy

    -----Original Message-----
    From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    Sent: Thursday, July 15, 2004 11:32 AM
    To: cayenne-use..bjectstyle.org
    Subject: Re: No more data to read from socket" error.

    Hi Roy,

    > [main 07-15 10:39:25] QueryLogger: ***
    > error. java.sql.SQLException: No more data to read from socket

    > Do I have to do something to terminate the connection once the query is
    > complete?

    No, this problem is not related to Cayenne. This is an Oracle driver
    issue. Make sure that the driver version matches both Oracle DB version
    and Java version on your machine. Oracle is very sensitive to this.

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu Jul 15 2004 - 12:39:09 EDT