Hi,
Search the mail archive, I remember someone asking this question before. I simply
open sqlplus and cut and paste the sql that deals wth the ID table in the right order.
-Sarav
-----Original Message-----
From: Adam <[EMAIL PROTECTED]>
To: Apache Torque Users List <[EMAIL PROTECTED]>
Date: Wed, 18 Aug 2004 06:39:11 -0500
Subject: Torque not populating the ID-TABLE
when i run
ant -f build-torque.xml insert-sql
i get these results:
[output]
insert-sql:
[torque-sql-exec] Our new url -> jdbc:postgresql://127.0.0.1:5432/app
[torque-sql-exec] Executing file:
C:\webapps\app\WEB-INF\src\sql\app-schema.sql
[torque-sql-exec] Executing file:
C:\webapps\app\WEB-INF\src\sql\app-schema-idtable-init.sql
[torque-sql-exec] 35 of 35 SQL statements executed successfully
[torque-sql-exec] Our new url -> jdbc:postgresql://127.0.0.1:5432/app
[torque-sql-exec] Executing file: C:\webapps\app\WEB-INF\src\sql\id-tab
le-schema.sql
[torque-sql-exec] 37 of 37 SQL statements executed successfully
[/output]
I notice that it runs the idtable-init, then runs the id-table-schema
(which drops and recreates the table), so I get an empty id-table.
The above three sql files are in that order in the sqlmap:
[file]
app-schema.sql=app
app-schema-idtable-init.sql=app
id-table-schema.sql=${database.name}
[/file]
How do I get these to execute in the proper order?
Thanks in advance!
Adam
>
---------------------------------------------------------------------
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]
