turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Painter <pain...@kiasoft.com>
Subject Re: Turbine / Torque mit sapdb
Date Wed, 28 Jan 2004 18:22:14 GMT

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

- --
painter@kiasoft.com                     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: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


Mime
View raw message