openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roger Keays <roger.ke...@ninthavenue.com.au>
Subject sql errors on postgres / openjpa 1.1
Date Fri, 27 Jun 2008 07:50:01 GMT
Hi,

I've had a few SQL errors under 1.1 due to missing column names. The 
latest one looks like this:

Caused by: <openjpa-1.1.0-SNAPSHOT-r422266:657918 nonfatal general 
error> org.apache.openjpa.persistence.PersistenceException: ERROR: 
syntax error at or near "WHERE" {prepstmnt 10993018 UPDATE CMS_BLOBS SET 
  WHERE id = ? [params=(long) 61]} [code=0, state=42601]
FailedObject: 
au.com.ninthavenue.cms.entities.Blob-au.com.ninthavenue.cms.entities.Blob-61


The code is roughly

blob.setAttachedTo(item);
item.getAttachments().add(blob);

em.getTransaction().begin();
em.persist(item);
em.getTransaction().commit();


item.attachments is CASCADE-ALL, and blob.attachedTo is CASCADE-MERGE. I 
can't set the relationships inside the transaction because of the way 
our code is executed. Both are new objects. I would have expected the 
SQL to do SET attachedTo_id = ? WHERE id = ?

Any suggestions would be appreciated.

Thanks,

Roger


Mime
View raw message