It seems that you forgot to execute the command maven torque:id-table-init-sql
from http://db.apache.org/torque/releases/torque-3.3/tutorial/step3.html Thomas pyaar <[EMAIL PROTECTED]> schrieb am 17.12.2007 12:04:19: > > Hi all > > i am using mssql server 2000,torque 3.2.I am trying to execute java > com.kazmier.Bookstore from the command as given in the sample application in > http://db.apache.org/torque/releases/torque-3.1/tutorial/step4.html > but i am getting the following error > > > org.apache.torque.TorqueException: java.sql.SQLException: > [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name > 'ID_TABLE'. > at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103) > at org.apache.torque.util.BasePeer.getId(BasePeer.java:570) > at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:503) > at org.apache.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:210) > at org.apache.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:556) > at org.apache.torque.BasePublisher.save(BasePublisher.java:531) > at org.apache.torque.BasePublisher.save(BasePublisher.java:495) > at org.apache.torque.BasePublisher.save(BasePublisher.java:475) > at org.apache.BookStore.main(BookStore.java:23) > Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > JDBC][SQLServer]Invalid object name 'ID_TABLE'. > at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) > at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown > Source) > at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown > Source) > at > com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown > Source) > at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) > at > com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown > Source) > at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown > Source) > at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) > at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source) > at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown > Source) > at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source) > at org.apache.torque.oid.IDBroker.updateQuantity(IDBroker.java:902) > at org.apache.torque.oid.IDBroker.storeIDs(IDBroker.java:649) > at org.apache.torque.oid.IDBroker.getNextIds(IDBroker.java:419) > at org.apache.torque.oid.IDBroker.getIdAsBigDecimal(IDBroker.java:307) > at org.apache.torque.util.BasePeer.getId(BasePeer.java:559) > ... 7 more > my bookstore-schema.xml file is as under > > <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> > <!-- Copyright 2001-2005 The Apache Software Foundation. Licensed under the > Apache License, Version 2.0 (the "License") you may not use this file except > in compliance with the License. You may obtain a copy of the License at > http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law > or agreed to in writing, software distributed under the License is > distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > KIND, either express or implied. See the License for the specific language > governing permissions and limitations under the License. --> > <!DOCTYPE database SYSTEM > "http://db.apache.org/torque/dtd/database_3_2.dtd";> > > <!-- ==================================================================== --> > <!-- --> > <!-- I D B R O K E R S C H E M A --> > <!-- --> > <!-- ==================================================================== --> > <!-- This is the XML schema use by Torque to generate the SQL for --> > <!-- ID_TABLE table used by the id broker mechanism in Torque. --> > <!-- ==================================================================== --> > <!-- @author: mailto:[EMAIL PROTECTED] Jason van Zyl --> > <!-- @version $Id: id-table-schema.xml 239624 2005-08-24 12:18:03Z henning $ --> > <!-- ==================================================================== --> > <database > name="bookstore" > defaultIdMethod="idbroker"> > > <table name="book" description="Book Table"> > <column > name="book_id" > required="true" > primaryKey="true" > type="INTEGER" > description="Book Id"/> > <column > name="title" > required="true" > type="VARCHAR" > size="255" > description="Book Title"/> > <column > name="isbn" > required="true" > type="VARCHAR" > size="24" > javaName="ISBN" > description="ISBN Number"/> > <column > name="publisher_id" > required="true" > type="INTEGER" > description="Foreign Key Publisher"/> > <column > name="author_id" > required="true" > type="INTEGER" > description="Foreign Key Author"/> > <foreign-key foreignTable="publisher"> > <reference > local="publisher_id" > foreign="publisher_id"/> > </foreign-key> > <foreign-key foreignTable="author"> > <reference > local="author_id" > foreign="author_id"/> > </foreign-key> > </table> > <table name="publisher" description="Publisher Table"> > <column > name="publisher_id" > required="true" > primaryKey="true" > type="INTEGER" > description="Publisher Id"/> > <column > name="name" > required="true" > type="VARCHAR" > size="128" > description="Publisher Name"/> > </table> > <table name="author" description="Author Table"> > <column > name="author_id" > required="true" > primaryKey="true" > type="INTEGER" > description="Author Id"/> > <column > name="first_name" > required="true" > type="VARCHAR" > size="128" > description="First Name"/> > <column > name="last_name" > required="true" > type="VARCHAR" > size="128" > description="Last Name"/> > </table> > </database> > > > i guess its something related to defaultidMethod > > i am trying to execute the application in the following order > > 1)ant -f build-torque.xml > 2)ant -f build-torque.xml compile > 3)ant -f build-torque.xml id-table-init-sql > > at this stage bookstore-schema-idtable-init.sql file is generated > > which contains > > insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES > (101, 'book', 1000, 10); > insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES > (102, 'publisher', 1000, 10); > insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES > (103, 'author', 1000, 10); > > 4)ant -f build-torque.xml insert-sql > > at this stage tables are successfully created in database > > 5)ant -f build-torque.xml compile > > all the necessary java objects are created > > 6)java com.kazmier.Bookstore > this is the problem area ,having error shown above > > any body here please help > -- > View this message in context: http://www.nabble.com/Torque-Runtime-errors%3A- > Invalid-object-name-%22ID_Table%22-tp14370223p14370223.html > Sent from the Apache DB - Torque Users mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > 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]
