db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pyaar <umadas2...@rediffmail.com>
Subject Torque Runtime errors:-Invalid object name "ID_Table"
Date Mon, 17 Dec 2007 11:04:19 GMT

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


Mime
View raw message