Remember: The ID Broker is case sensitive on the names in the tables vs. what torque compiled against.
Cheers,
Ben
CP Agrawal wrote:
I was able to successfully create the torque classes and create tables
in the DB for the tutorial which ships with torque-3.0-rc1, when trying
to execute the Bookstore application I get following error, I checked
ID_TABLE has 3 rows corresponding to 3 tables in the tutorial.
421 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting datasource
property: url
441 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting datasource
property: user
441 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting datasource
property: password
441 [main] DEBUG dsfactory.TorqueDataSourceFactory - Starting
initTorqueClassic
471 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting datasource
property: defaultMaxConnections
481 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting datasource
property: maxExpiryTime
481 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting datasource
property: connectionWaitTimeout
491 [main] DEBUG torque.Torque - Adding a dummy entry for default,
mapped onto bookstore
771 [Thread-1] DEBUG oid.IDBroker - IDBroker thread was started.
2013 [main] DEBUG oid.IDBroker - Forced id retrieval - no available
list
2133 [main] DEBUG oid.IDBroker - updateQuantity: UPDATE ID_TABLE SET
QUANTITY = 10 WHERE TABLE_NAME = 'publis
her'
org.apache.torque.TorqueException: The table publisher does not have a
proper entry in the ID_TABLE
at org.apache.torque.oid.IDBroker.selectRow(IDBroker.java:808)
at org.apache.torque.oid.IDBroker.storeIDs(IDBroker.java:669)
at org.apache.torque.oid.IDBroker.getNextIds(IDBroker.java:443)
at
org.apache.torque.oid.IDBroker.getIdAsBigDecimal(IDBroker.java:330)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
at
com.steelwedge.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:
192)
at
com.steelwedge.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:
475)
at
com.steelwedge.torque.BasePublisher.save(BasePublisher.java:459)
at
com.steelwedge.torque.BasePublisher.save(BasePublisher.java:421)
at
com.steelwedge.torque.BasePublisher.save(BasePublisher.java:401)
at com.steelwedge.torqueclient.Bookstore.main(Bookstore.java:26)
rethrown as org.apache.torque.TorqueException: The table publisher does
not have a proper entry in the ID_TABL
E
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:713)
at
com.steelwedge.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:
192)
at
com.steelwedge.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:
475)
at
com.steelwedge.torque.BasePublisher.save(BasePublisher.java:459)
at
com.steelwedge.torque.BasePublisher.save(BasePublisher.java:421)
at
com.steelwedge.torque.BasePublisher.save(BasePublisher.java:401)
at com.steelwedge.torqueclient.Bookstore.main(Bookstore.java:26)
Caused by: org.apache.torque.TorqueException: The table publisher does
not have a proper entry in the ID_TABLE
at org.apache.torque.oid.IDBroker.selectRow(IDBroker.java:808)
at org.apache.torque.oid.IDBroker.storeIDs(IDBroker.java:669)
at org.apache.torque.oid.IDBroker.getNextIds(IDBroker.java:443)
at
org.apache.torque.oid.IDBroker.getIdAsBigDecimal(IDBroker.java:330)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
... 6 more
-- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
