[OJB-developers] Errors with PK-only objects

[Bischof, R. <rai...@ed...>]

Thomas,
 
I am not sure if this has been raised before:
There is a problem with OJB when working with objects that contain only the
attributes that make up the PK and no other attributes , e.g. if you model a
reference table as an object.
 
When the broker tries to save such an object it issues an update statement
which contains no set-clause, something like "update t_ref where pk1=1 and
pk2=2". This of course is invalid SQL.
 
Pls see the stacktrace below.
 
Thx
Rainer Bischof
EDS - Electronic Data Systems
European Automotive Solution Center - Distributed Solutions
Email: rai...@ed... <mailto:rai...@ed...> 

 
 
java.sql.SQLException: []Incorrect syntax near the keyword 'WHERE'.
 
 at com.inet.tds.TdsConnection.a(Unknown Source)
 
 at com.inet.tds.TdsStatement.a(Unknown Source)
 
 at com.inet.tds.TdsStatement.byte(Unknown Source)
 
 at com.inet.tds.TdsStatement.executeUpdate(Unknown Source)
 
 at ojb.broker.accesslayer.JdbcAccess.executeUpdate(JdbcAccess.java:218)
 
 at
ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1
086)
 
 at
ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:3
06)
 
 at
ojb.broker.singlevm.PersistenceBrokerImpl.storeCollections(PersistenceBroker
Impl.java:388)
 
 at
ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1
093)
 
 at
ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:3
06)
 
 at
ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1
037)
 
 at ojb.odmg.states.StateOldDirty.commit(StateOldDirty.java:102)
 
 at ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:114)
 
 at ojb.odmg.TransactionImpl.doCommit(TransactionImpl.java:210)
 
 at ojb.odmg.TransactionImpl.commit(TransactionImpl.java:345)