Stefan, It would be helpful if you included your schema, build.propertiers, and run-time properties as well. Rather than post these to the list, feel free to send these to me directly and I'll take a look at them for you, and post the results back to the list.
In addition, you may want to read the tutorial that I am putting together. I'm sure if you followed that you'd find your problem The URL to the work-in-progress is: http://www.kazmier.com/~kaz/torque/tutorial.html Thanks, Pete On Wed, Jan 30, 2002 at 03:29:49PM +0100, Stefan Krause wrote: > 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]> > -- Peter Kazmier http://www.kazmier.com PGP Fingerprint 4FE7 8DA3 D0B5 9CAA 69DC 7243 1855 BC2E 4B43 5654 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
