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]
