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]
