Re: Hollow Object issue

2008-04-17 Thread Malcolm Edgar
OK I found my problem it, I had the foreign key in a related DbEntity defined as a BINARY. I will close the issue. regards Malcolm Edgar On Thu, Apr 17, 2008 at 8:18 PM, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > > On Apr 17, 2008, at 1:13 PM, Malcolm Edgar wrote: > > Hi Andrus, > > > > the

Re: Hollow Object issue

2008-04-17 Thread Andrus Adamchik
On Apr 17, 2008, at 1:13 PM, Malcolm Edgar wrote: Hi Andrus, the column is a MySQL 5.0 BIGINT, I have tried changing this to an INTEGER and I still had the same problem. regards Malcolm Edgar So it is BIGINT on MySQL end and in the Cayenne model? Please doublecheck that you don't map i

Re: Hollow Object issue

2008-04-17 Thread Malcolm Edgar
Hi Andrus, the column is a MySQL 5.0 BIGINT, I have tried changing this to an INTEGER and I still had the same problem. regards Malcolm Edgar On Thu, Apr 17, 2008 at 8:08 PM, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > > On Apr 17, 2008, at 12:48 PM, Malcolm Edgar wrote: > > Caused by: java.s

Re: Hollow Object issue

2008-04-17 Thread Andrus Adamchik
On Apr 17, 2008, at 12:48 PM, Malcolm Edgar wrote: Caused by: java.sql.SQLException: Cannot convert class [B to SQL type requested due to java.lang.ClassCastException - [B at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java: 2744) So I assume that "schema_config_oid" is

Re: Hollow Object issue

2008-04-17 Thread Malcolm Edgar
Some more analysis on this problem the ObjectId singleValue value is a byte[] of the table primary key value "3456", and the ObjectId is returning the raw byte array as the single primary key value. This is making a mess of Cayenne refreshing objects, lazy loading, etc. The environment I am using

Hollow Object issue

2008-04-16 Thread Malcolm Edgar
Hi Guys, I have a nasty problem with attempting to perform a refetchObject() on a hollow object. This is the DataObject toString(), note the primary key column 'schema_config_oid' has a value of '[EMAIL PROTECTED]>' The primary key column of this database is an BIGINT, this table only has one re