Hello! i want to use Turbine via Torque against a sapdb database and have some troubles building the database schema out of the xml schema definitions:
insert-sql: [torque-sql-exec] Our new url -> jdbc:sapdb://uny-dev-mysql/aportal [torque-sql-exec] Executing file: /home/chris/eclipse/aportal/WEB-INF/src/sql/id-table-schema.sql [torque-sql-exec] Executing file: /home/chris/eclipse/aportal/WEB-INF/src/sql/turbine-schema.sql [torque-sql-exec] Failed to execute: drop table TURBINE_SCHEDULED_JOB cascade [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 12): Unknown table name:TURBINE_SCHEDULED_JOB [torque-sql-exec] Failed to execute: CREATE TABLE TURBINE_SCHEDULED_JOB ( JOB_ID INTEGER NOT NULL, SECOND INTEGER default -1 NOT NULL, MINUTE INTEGER default -1 NOT NULL, HOUR INTEGER default -1 NOT NULL, WEEK_DAY INTEGER default -1 NOT NULL, DAY_OF_MONTH INTEGER default -1 NOT NULL, TASK VARCHAR (99) NOT NULL, EMAIL VARCHAR (99), PROPERTY LONG BYTE ) [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-7006] (at 63): Reserved identifier not allowed [torque-sql-exec] Failed to execute: ALTER TABLE TURBINE_SCHEDULED_JOB ADD PRIMARY KEY (JOB_ID) [torque-sql-exec] com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 13): Unknown table name:TURBINE_SCHEDULED_JOB [torque-sql-exec] Executing file: /home/chris/eclipse/aportal/WEB-INF/src/sql/turbine-schema-idtable-init.sql [torque-sql-exec] 33 of 36 SQL statements executed successfully [torque-sql-exec] Our new url -> jdbc:sapdb://uny-dev-mysql/aportal [torque-sql-exec] Executing file: /home/chris/eclipse/aportal/WEB-INF/src/sql/aportal-schema.sql [torque-sql-exec] Executing file: /home/chris/eclipse/aportal/WEB-INF/src/sql/aportal-schema-idtable-init.sql [torque-sql-exec] 68 of 71 SQL statements executed successfully how can i handle the column names used in the table TURBINE_SCHEDULED_JOB? thx, Chris -- mit freundlichen Gr��en / with kind regards Ing. Christian J�lly @ Solutions unycom Information Technology Services GmbH A-8042 Graz | Schmiedlstra�e 1 / III Tel: ++43 (0)316 / 818 828 - 30 Fax: ++43 (0)316 / 818 828 - 38 [EMAIL PROTECTED] http://www.unycom.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
