HI Guillaume, I'm using HSQLDB 1.7.1 with Torque 3.0 for test installations of our software and I did not problems. The stacktrace looks like a HSQLDB driver problem with isAutoIncrement() ... Might be worth stepping through the code.
Cheers, Siegfried Goeschl -----Original Message----- From: Lederrey Guillaume [mailto:[EMAIL PROTECTED] Sent: Montag, 14. Juni 2004 23:57 To: [EMAIL PROTECTED] Subject: Torque and Hsqldb -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi ! I would like to use torque with hsqldb. From the doc, it seems to be possible. I have an error when I run a small test (create an object, put some values and save it). My schema is very simple (just a test) : <database name="papyrus"> <table name="work" description="Works Table"> <column name="idWork" required="true" primaryKey="true" type="INTEGER" description="Work Id"/> <column name="title" required="true" type="VARCHAR" size="255" description="Work Title"/> </table> </database> I've search google with no luck, I've search the mailing list archive for "hsql" with no result at all ... I wonder if anybody actually uses Hsql ... just prove me wrong ! If there is anybody who understand what's happening I'll be glad to hear from it ! Guillaume 569 [main] ERROR ch.ledcom.papyrus.TestTorque - error saving language java.sql.SQLException: This function is not supported at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source) at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source) at org.hsqldb.jdbcResultSet.isAutoIncrement(Unknown Source) at com.workingdogs.village.Column.populate(Unknown Source) at com.workingdogs.village.Schema.populate(Unknown Source) at com.workingdogs.village.Schema.schema(Unknown Source) at com.workingdogs.village.Schema.schema(Unknown Source) at com.workingdogs.village.DataSet.<init>(Unknown Source) at com.workingdogs.village.TableDataSet.<init>(Unknown Source) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:740) at ch.ledcom.papyrus.om.BaseWorkPeer.doInsert(BaseWorkPeer.java:219) at ch.ledcom.papyrus.om.BaseWorkPeer.doInsert(BaseWorkPeer.java:567) at ch.ledcom.papyrus.om.BaseWork.save(BaseWork.java:404) at ch.ledcom.papyrus.om.BaseWork.save(BaseWork.java:368) at ch.ledcom.papyrus.om.BaseWork.save(BaseWork.java:348) at ch.ledcom.papyrus.TestTorque.main(TestTorque.java:47) rethrown as org.apache.torque.TorqueException: This function is not supported at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:746) at ch.ledcom.papyrus.om.BaseWorkPeer.doInsert(BaseWorkPeer.java:219) at ch.ledcom.papyrus.om.BaseWorkPeer.doInsert(BaseWorkPeer.java:567) at ch.ledcom.papyrus.om.BaseWork.save(BaseWork.java:404) at ch.ledcom.papyrus.om.BaseWork.save(BaseWork.java:368) at ch.ledcom.papyrus.om.BaseWork.save(BaseWork.java:348) at ch.ledcom.papyrus.TestTorque.main(TestTorque.java:47) Caused by: java.sql.SQLException: This function is not supported at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source) at org.hsqldb.jdbcResultSet.getNotSupported(Unknown Source) at org.hsqldb.jdbcResultSet.isAutoIncrement(Unknown Source) at com.workingdogs.village.Column.populate(Unknown Source) at com.workingdogs.village.Schema.populate(Unknown Source) at com.workingdogs.village.Schema.schema(Unknown Source) at com.workingdogs.village.Schema.schema(Unknown Source) at com.workingdogs.village.DataSet.<init>(Unknown Source) at com.workingdogs.village.TableDataSet.<init>(Unknown Source) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:740) ... 6 more , but they are very few informations ... A search on the mailing list archive -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAzh89W+xV6X6No3gRAsepAKCBeTnRm3lQZEGL3LX0xtj3XTAIzgCg8dgQ SvTvJd0B8VeLgiOEtZPs3Tg= =WKsJ -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
