Thanks for the hint. I went back and looked at the ant task in
build-torque.xml
<torque-sql-exec
autocommit="true"
driver="${torque.database.driver}"
onerror="continue"
password="${torque.database.password}"
sqldbmap="${torque.sql.dir}/sqldb.map"
srcDir="${torque.sql.dir}"
url="${torque.database.buildUrl}"
userid="${torque.database.user}">
<classpath refid="torque-classpath"/>
</torque-sql-exec>
It executes files in alphabetical order:
[torque-sql-exec] Executing file:
torque-3.0-rc1\src\sql\bookstore-schema.sql
[torque-sql-exec] Executing file:
torque-3.0-rc1\src\sql\bookstore-schema-idtable-init.sql
[torque-sql-exec] 14 of 14 SQL statements executed successfully
[torque-sql-exec] Executing file:
\torque-3.0-rc1\src\sql\id-table-schema.sql
and it was deleting the entries from the table.
Also, case sensitivity does matter, values as generated by torque (lower
case) work, because select/update clauses always pass table names in
lower case.
-----Original Message-----
From: Ben Walding [mailto:ben@;walding.com]
Sent: Wednesday, October 30, 2002 12:33 PM
To: Turbine Torque Users List
Subject: Re: [NEWBIE]: Getting error when running tutorial on Oracle 9i
What are the three rows in ID_TABLE?
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>
--
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>
