It sounds like your java object is storing application data, is this true? In a good database design a primary key is of no significance to the application other than a means to reference other data.
You may need to reconsider your database design. -----Original Message----- From: Alvaro Coronel [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 6:26 AM To: Apache Torque Users List Subject: Re: Can a Java object or byte[] be used as a primary key? Wow! What SQL database supports having a byte[] field as primary key? Regards, Álvaro. ----- Original Message ---- From: Jeffrey Dawson <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, August 14, 2006 4:15:58 PM Subject: Can a Java object or byte[] be used as a primary key? I want to use a fixed size byte array as the primary key to a table, but Torque can't convert between ObjectKey and byte[], and gets compilation errors in the Base classes. I was going to try using BigInteger objects as the primary key instead, but then I get errors during the code generation. The xml for the column definition looks like this: <column name="DATUM_ID" primaryKey="true" required="true" type="JAVA_OBJECT" javaType="object" autoIncrement="false"/> Am I asking for the impossible? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
