You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Lederrey Guillaume <Ge...@LedCom.ch> on 2004/06/14 23:57:12 UTC

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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org