Re: Does anyone know why I get the following error? What's the ID_TABLE?

2005-02-16 Thread Nuno Miguel Rodrigues
On Tue, 15 Feb 2005 19:58:19 -0800, Joseph Yuen [EMAIL PROTECTED] wrote: *** Exception saving record org.apache.torque.TorqueException: The table encounter does not have a proper entry in the ID_TABLE at org.apache.torque.oid.IDBroker.selectRow(IDBroker.java:825) [...] I get

Re: Does anyone know why I get the following error? What's the ID_TABLE?

2005-02-16 Thread Rafal Markut
Hi, you forgot add information about your table into ID_TABLE. If you want to user ID-Broker then you have to do it. best regards, Rafal - Original Message - From: Joseph Yuen [EMAIL PROTECTED] To: Jeff Fowler (Chi-square) [EMAIL PROTECTED]; Jon Fleming (Chi-square) [EMAIL PROTECTED];

RE: PL/SQL in generated Oracle scripts

2005-02-16 Thread Thomas Fischer
Hi Paul, I suppose you use Torque 3.1.1. In that version, a change was introduced in order not to let the drop table statements fail if the table is not already there (e.g. if you start with an empty database). But this change produces more problem than it solves, so I removed it again in

RE: PL/SQL in generated Oracle scripts

2005-02-16 Thread Paul Osborne
Thanks Thomas, Yes, I'm using Torque 3.1.1. So, I'll make the necessary changes to the templates. Paul. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] e.org] On Behalf Of Thomas Fischer Sent: 16 February 2005 07:47 To: Apache Torque Users List Subject: RE: PL/SQL

Re: PL/SQL in generated Oracle scripts

2005-02-16 Thread Thomas Fischer
Nuno Miguel Rodrigues [EMAIL PROTECTED] schrieb am 16.02.2005 10:35:52: On Tue, 15 Feb 2005 23:29:55 -, Paul Osborne [EMAIL PROTECTED] wrote: I am trying to use the Maven Torque plugin to generate and initialize an Oracle 8i database. However, the torque 'insert-sql' target is

RE: Does anyone know why I get the following error? What's the ID_TABLE?

2005-02-16 Thread Jon Fleming
The ID_TABLE is a table maintained by Torque to generate and manage unique record IDs for each table. When you use Torque to generate the database it populates this table with one record for each table that uses Torque to generate primary key IDs. If you add a new table to the schema and set the