You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by pyaar <um...@rediffmail.com> on 2007/12/17 14:20:56 UTC

Torque Runtime errors:-ID_TABLE

HI ALL
i am executing the bookstore application using mssql server 2000,torque
3.2,but when i try to execute java com.kazmier.Bookstore the following error
comes


C:\Torque\torque-gen-3.2\bookstore>java com.kazmier.BookStore
org.apache.torque.TorqueException: The table publisher does not have a
proper en
try in the ID_TABLE
        at org.apache.torque.oid.IDBroker.selectRow(IDBroker.java:802)
        at org.apache.torque.oid.IDBroker.storeIDs(IDBroker.java:652)
        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)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:503)
        at
org.apache.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:2
10)
        at
org.apache.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:5
56)
        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:34)

compilation is working fine for me.where the problem lies? anybody please
guide
-- 
View this message in context: http://www.nabble.com/Torque-Runtime-errors%3A-ID_TABLE-tp14370290p14370290.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

Re: Torque Runtime errors:-ID_TABLE

Posted by Fran Ferri <fr...@gmail.com>.
I think you need execute the init-tables-sql for idbroker

Re: Torque Runtime errors:-ID_TABLE

Posted by pyaar <um...@rediffmail.com>.
Hi thomas

i am executing the steps as outlined in the tutorial and after getting the
errors only i am sending it to the experts.Actually i am new to this field
thats why so many errors:-).As replied by one expert i have executed the
id-table-init-sql command after the create-db command.Table ID_TABLE in the
database is modified but its not inserting any values as given in
bookstore-schema-idtable-init.sql.Do we have to manually insert the values
in the Table ID_TABLE.I tried that and the sample application was working
fine for me.Also while executing the id-table-init-sql command the
report.idtable-init.sql.generation file is generated which contains
nothing.I wonder if something should be there in this file.please please 
answer my queries.

-- 
View this message in context: http://www.nabble.com/Torque-Runtime-errors%3A-ID_TABLE-tp14370290p14384478.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

RE: Torque Runtime errors:-ID_TABLE

Posted by Thomas Fischer <fi...@seitenbau.net>.
Pyaar. Before sending a message to the the mailing list, would you please
try and execute the steps AS DESCRIBED IN THE TUTORIAL ? Thanks a lot in
advance.

            Thomas

pyaar <um...@rediffmail.com> schrieb am 17.12.2007 14:20:56:

>
> HI ALL
> i am executing the bookstore application using mssql server 2000,torque
> 3.2,but when i try to execute java com.kazmier.Bookstore the following
error
> comes
>
>
> C:\Torque\torque-gen-3.2\bookstore>java com.kazmier.BookStore
> org.apache.torque.TorqueException: The table publisher does not have a
> proper en
> try in the ID_TABLE
>         at org.apache.torque.oid.IDBroker.selectRow(IDBroker.java:802)
>         at org.apache.torque.oid.IDBroker.storeIDs(IDBroker.java:652)
>         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)
>         at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:503)
>         at
> org.apache.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:2
> 10)
>         at
> org.apache.torque.BasePublisherPeer.doInsert(BasePublisherPeer.java:5
> 56)
>         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:34)
>
> compilation is working fine for me.where the problem lies? anybody please
> guide
> --
> View this message in context:
http://www.nabble.com/Torque-Runtime-errors%3A-
> ID_TABLE-tp14370290p14370290.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
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org