it looks like SECOND, MINUTE, and HOUR are reserved keywords in SAPdb
TURBINE_SCHEDULED_JOB uses all three of these for column names. I'm not
sure what the solution would be other than to change the coding of these
column names or remove the Scheduler Service if you do not need it and
drop the creation of this table.
The methods are hard coded in
o.a.t.services.schedule.JobEntry
setSecond()
setMinute()
setHour()
and in $tdkroot/webapps/appname/WEB-INF/conf/turbine-schema.xml
<table name="TURBINE_SCHEDULED_JOB" idMethod="idbroker">
<column name="JOB_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="SECOND" default="-1" required="true" type="INTEGER"/>
<column name="MINUTE" default="-1" required="true" type="INTEGER"/>
<column name="HOUR" default="-1" required="true" type="INTEGER"/>
<column name="WEEK_DAY" default="-1" required="true" type="INTEGER"/>
<column name="DAY_OF_MONTH" default="-1" required="true" type="INTEGER"/>
<column name="TASK" required="true" size="99" type="VARCHAR"/>
<column name="EMAIL" size="99" type="VARCHAR"/>
<column name="PROPERTY" type="VARBINARY"/>
</table>
if you need the scheduler I'm guessing you would have to remap the fields
hth,
Jeff Painter
On Wed, 28 Jan 2004, Chris Joelly wrote:
> 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
>
>
--
Regards,
Jeffery Painter
- --
[EMAIL PROTECTED] http://kiasoft.com
PGP FP: 9CE8 83A2 33FA 32B1 0AB1 4E62 E4CB E4DA 5913 EFBC
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/qEQE5Mvk2lkT77wRAnMJAJ9vJ6qOkg/mvqqIpz7troCEQJ8bFACglu/U
YNXabx7DZOV2Hd9LwSTmGpY=
=dWiu
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
