Hi, Two points:
1. I'm trying to get torque (3.0b4) going using the latest hsqldb release 1.7.0 but I've run into a problem. It appears that in com.workingdogs.village.Column (line 150) we have this line : this.autoIncrement = rsmd.isAutoIncrement(columnNumber); This assumes either a true or false will be returned whereas the hsqldb 1.7.0 driver throws an SQLException (It is not supported ) which prevents torque from inserting or updating etc... I found this: http://sourceforge.net/forum/message.php?msg_id=1606182 I'm not to sure what course of action I should take: 1. hack 1.7.0's org.hsqldb.jdbcResultSet to always return false (NOTE: hsqldb1.6.1 just returns false but I like the new features in 1.7.0) or 2. Submit a patch for Column.java e.g. try { this.autoIncrement = rsmd.isAutoIncrement(columnNumber); } catch (Exception e) { this.autoIncrement = false; } What do you reckon? Has anyone else comes up across this situation. See exception trace below... Point 2. I had another problem with the same driver while using org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory. The driver was barfing on the validation query (SELECT 1).It was coming up with parsing errors (See exception trace below the first trace). As I wasn't very sure what this was for exactly I set torque.dsfactory.groupworks.pool.testOnBorrow=false and that sorted that out but I would like to know what this is for, anyway. Could somebody explain it's use? Point1: 2002-08-09 21:57:05,785 [main] DEBUG com.jwsm.gw.DBTest - Success Initing Torque! 2002-08-09 21:57:05,786 [main] DEBUG com.jwsm.gw.DBTest - About to instantiate new Objects from Manager! 2002-08-09 21:57:05,789 [main] DEBUG com.jwsm.gw.DBTest - About to set ob property! 2002-08-09 21:57:05,803 [main] DEBUG com.jwsm.gw.DBTest - We've just created Objects ob and set desc=!testing 2002-08-09 21:57:05,804 [main] DEBUG com.jwsm.gw.DBTest - About to save ob! 2002-08-09 21:57:05,895 [main] INFO org.apache.torque.oid.IDBroker - Forced id retrieval - no available list 2002-08-09 21:57:05,945 [main] DEBUG org.apache.torque.oid.IDBroker - updateQuantity: UPDATE ID_TABLE SET QUANTITY = 10 WHERE TABLE_NAME = 'OBJECTS' 2002-08-09 21:57:05,951 [main] DEBUG org.apache.torque.oid.IDBroker - updateNextId: UPDATE ID_TABLE SET NEXT_ID = 1030 WHERE TABLE_NAME = 'OBJECTS' 2002-08-09 21:57:06,259 [main] ERROR com.jwsm.gw.DBTest - Can't save ob!! java.sql.SQLException: This function is not supported at org.hsqldb.Trace.getError(Trace.java:226) at org.hsqldb.Trace.error(Trace.java:277) at org.hsqldb.jdbcResultSet.getNotSupported(jdbcResultSet.java:6476) at org.hsqldb.jdbcResultSet.isAutoIncrement(jdbcResultSet.java:5707) 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:871) at com.jwsm.gw.om.BaseObjectsPeer.doInsert(BaseObjectsPeer.java:184) at com.jwsm.gw.om.BaseObjectsPeer.doInsert(BaseObjectsPeer.java:482) at com.jwsm.gw.om.BaseObjects.save(BaseObjects.java:356) at com.jwsm.gw.om.BaseObjects.save(BaseObjects.java:311) at com.jwsm.gw.om.BaseObjects.save(BaseObjects.java:294) at com.jwsm.gw.DBTest.main(DBTest.java:191) org.apache.torque.TorqueException: This function is not supported at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:877) at com.jwsm.gw.om.BaseObjectsPeer.doInsert(BaseObjectsPeer.java:184) at com.jwsm.gw.om.BaseObjectsPeer.doInsert(BaseObjectsPeer.java:482) at com.jwsm.gw.om.BaseObjects.save(BaseObjects.java:356) at com.jwsm.gw.om.BaseObjects.save(BaseObjects.java:311) at com.jwsm.gw.om.BaseObjects.save(BaseObjects.java:294) at com.jwsm.gw.DBTest.main(DBTest.java:191) Caused by: java.sql.SQLException: This function is not supported at org.hsqldb.Trace.getError(Trace.java:226) at org.hsqldb.Trace.error(Trace.java:277) at org.hsqldb.jdbcResultSet.getNotSupported(jdbcResultSet.java:6476) at org.hsqldb.jdbcResultSet.isAutoIncrement(jdbcResultSet.java:5707) 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:871) ... 6 more 2002-08-09 21:58:01,306 [Thread-3] INFO org.apache.torque.oid.IDBroker - IDBroker thread checking for more keys on table: OBJECTS 2002-08-09 21:58:01,309 [Thread-3] DEBUG org.apache.torque.oid.IDBroker - updateQuantity: UPDATE ID_TABLE SET QUANTITY = 10 WHERE TABLE_NAME = 'OBJECTS' 2002-08-09 21:58:01,313 [Thread-3] DEBUG org.apache.torque.oid.IDBroker - updateNextId: UPDATE ID_TABLE SET NEXT_ID = 1040 WHERE TABLE_NAME = 'OBJECTS' 2002-08-09 21:58:01,317 [Thread-3] INFO org.apache.torque.oid.IDBroker - Retrieved more ids for table: OBJECTS Point 2: DriverManager.getConnection("jdbc:hsqldb:hsql://localhost") trying driver[className=org.hsqldb.jdbcDriver,org.hsqldb.jdbcDriver@93385d] getConnection returning driver[className=org.hsqldb.jdbcDriver,org.hsqldb.jdbcDriver@93385d] SQLException: SQLState(37000) vendor code(-11) java.sql.SQLException: Unexpected token: 37000 Unexpected token: in statement [SELECT 1] at org.hsqldb.Trace.getError(Trace.java:226) at org.hsqldb.Result.<init>(Result.java:154) at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:2821) at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2536) at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1804) at org.hsqldb.jdbcStatement.executeQuery(jdbcStatement.java:199) at org.apache.commons.jdbc2pool.KeyedCPDSConnectionFactory.validateObject(KeyedCPDSConnectionFactory.java:207) __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
