turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Joelly <chris.joe...@unycom.com>
Subject Turbine / Torque mit sapdb
Date Wed, 28 Jan 2004 15:09:32 GMT
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
chris.joelly@unycom.com
http://www.unycom.com


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


Mime
View raw message