Hi,
I have a problem with storing data in the mysql database. When I
call the save() method I get an error in the torque.log file which says
my database do not allow this operation. But rollback is allowed by
mysql.
Can someone give me an advice?
this is my simple test-class:
package org.openscience.nmrshiftdb;
import org.apache.torque.Torque;
import org.apache.torque.util.Criteria;
import org.openscience.nmrshiftdb.*;
import java.util.*;
public class DBTest
{
public static void main(String[] args)
{
try
{
Torque.init("/home/stefan/dev/nmrshiftdb/schema/Torque.properties");
Contributor con = new Contributor();
con.setId("1");
con.setFirstName("firstname");
con.setLastName("lastname");
con.save();
}
catch (Exception exc)
{
}
}
}
Here is the error message i got in the torque.log file:
INFO - Logging has been configured by Torque.
DEBUG - Using org.apache.torque.adapter.DBMM
INFO - IDBroker thread was started.
WARN - IDBroker is being used with db 'nmrshiftdb', which does not
support transactions.
IDBroker attempts to use transactions to limit the possibility of
duplicate key generation.
Without transactions, duplicate key generation is possible if multiple
JVMs are used or
other means are used to write to the database.
INFO - Forced id retrieval - no available vector
DEBUG - BasePeer.doUpdate: whereClause=TABLE_NAME='CONTRIBUTOR'
ERROR - An attempt was made to rollback a transaction but the database
did not allow the operation to be rolled back.
Thanks.
Stefan
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
