BZ24: SQL error while creating thumbnails

[harri]

Exception log:

Exception in thread "Thread-3" org.apache.ojb.odmg.TransactionAbortedExceptionOJB
        at org.apache.ojb.odmg.ObjectEnvelopeTable.commit(Unknown Source)
        at org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(Unknown Source)
        at org.apache.ojb.odmg.TransactionImpl.prepare(Unknown Source)
        at org.apache.ojb.odmg.TransactionImpl.commit(Unknown Source)
        at dbhelper.ODMGXAWrapper.commit(ODMGXAWrapper.java:33)
        at imginfo.PhotoInfo.createThumbnail(PhotoInfo.java:481)
        at imginfo.PhotoInfo.createThumbnail(PhotoInfo.java:488)
        at imginfo.PhotoInfo.getThumbnail(PhotoInfo.java:368)
        at photovault.swingui.ThumbCreatorThread.run(ThumbCreatorThread.java:38)
Caused by: org.apache.ojb.broker.KeyConstraintViolatedException: SQL failure
while insert object data for class imginfo.ImageInstance, PK of the given object
is [ volumeId=defaultVolume fname=20050307_00036.jpg], object was
imginfo.ImageInstance@18b3e62, exception message is [null,  message from server:
"Duplicate entry 'defaultVolume-20050307_00036.jpg' for key 1"]
        at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
        at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
        at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
        at org.apache.ojb.odmg.states.StateNewDirty.commit(Unknown Source)
        at org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(Unknown Source)
        ... 9 more
Caused by: java.sql.SQLException: null,  message from server: "Duplicate entry
'defaultVolume-20050307_00036.jpg' for key 1"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2051)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527)
        ... 17 more