Hi, probably the first problem is already known and fixed in a later version, nevertheless I want to post it, to keep others from running into the same issue.
when you run "ant init", it happens, that sql-scripts are executed in the wrong order: As you can see below, <fcar-schema-idtable-init.sql> is executed before <id-table-schema> meaning, that there are no entries for the fcar tables in the id_table. also manually creating the id_table dosn't fix the problem, because later id-table-schema takes affect and does a DROP before reinitialize it. --- insert-sql: [torque-sql-exec] Our new url -> jdbc:oracle:thin:@cdbmr:1521:MR01 [torque-sql-exec] Executing file: /opt/tdk-2.2/webapps/fcar/WEB-INF/src/sql/fcar-schema.sql [torque-sql-exec] Failed to execute: DROP TABLE ADDRESS CASCADE CONSTRAINTS [torque-sql-exec] java.sql.SQLException: ORA-00942: table or view does not exist [torque-sql-exec] Executing file: /opt/tdk-2.2/webapps/fcar/WEB-INF/src/sql/fcar-schema-idtable-init.sql [torque-sql-exec] Failed to execute: insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (101, 'ADDRESS', 1000, 10) [torque-sql-exec] java.sql.SQLException: ORA-00942: table or view does not exist [torque-sql-exec] 2 of 4 SQL statements executed successfully [torque-sql-exec] Our new url -> jdbc:oracle:thin:@cdbmr:1521:MR01 [torque-sql-exec] Executing file: /opt/tdk-2.2/webapps/fcar/WEB-INF/src/sql/id-table-schema.sql [torque-sql-exec] Failed to execute: DROP TABLE ID_TABLE CASCADE CONSTRAINTS [torque-sql-exec] java.sql.SQLException: ORA-00942: table or view does not exist [torque-sql-exec] 4 of 7 SQL statements executed successfully --- I wasn't able to figure out how to change the order of script-execution yet (build.xml -> build-torque.xml -> sqldb.map -> ?). So my workaround is to rerun fcar-schema-idtable-init.sql by hand. Any better ideas? The second thing is that while I was looking into the build files, I saw a build-target "jdbc" which pretty much looked like, as if it's possible to create the database schema xml files from an existing database via an jdbc connection. Is that correct? is there an howto concerning this? Best Regards, David --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
