Hello, I know this has been reported before, but the only answers I have seen in the archives were "it works for us". But along with those answers were statments to the effect that because torque could not generate the DB2 database, the tests couldnt really be run against a correct db2 database.
With the recent changes I have subbitted (and were accepted/applied) to torque, and the small change I posted here yesterday for the schema (reversing 2 tables) I can get a complete database generated. However when you run "ant junit" you get a hang - as described here several times. It appears to be a transaction problem, as the table being accessed (projects) is locked to any other access as well. Rather than rehash info here again, here are pointers to several messages describing the problem. In each case, my results are identical http://archives.apache.org/eyebrowse/ReadMsg?[EMAIL PROTECTED] e.org&msgId=454651 http://archives.apache.org/eyebrowse/ReadMsg?[EMAIL PROTECTED] e.org&msgId=455086 The actual hang is in org.apache.ojb.broker.util.sequence.SequenceGenerator.getMaxIdForClass(Persi stenceBroker brokerForClass, ClassDescriptor cld, String fieldName) at the stmt.executeStatement(sql); line (line 148) sql = "SELECT MAX(ID) FROM PROJECT" which is valid, and runs just fine outside of OJB stack trace: (line) org.apache.ojb.broker.util.sequence.SequenceGenerator.getMaxIdForClass (148) org.apache.ojb.broker.util.sequence.SequenceGenerator.getMaxForExtent (109) org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence (59) org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl.getUniqueId (93) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueId (1745) org.apache.ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue (933) org.apache.ojb.broker.metadata.ClassDescriptor.getKeyValues (836) org.apache.ojb.broker.Identity.<init> (144) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store (549) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeCollectionObject (732) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeCollections (702) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store (1592) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store (558) org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store (514) org.apache.ojb.broker.MtoNMapping.testInsertion (219) Please let me know if there is anything else I can provide to track this problem. I fixed the torque generation, now hopefully someone can help me with this! Thanks Russell -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
