turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Joelly <chris.joe...@unycom.com>
Subject Re: Turbine / Torque mit sapdb
Date Thu, 29 Jan 2004 08:53:06 GMT
Hello!

ok. i have corrected the generated sql script and added quotes around
the reserved key words.
but i think that there are some other troubles with the generated sql
script.

the comments starts with -- but they should start with // for example...

does anybody know how torque can be configured for the script
generation? does torque use velocity for this task?

thx, Chris

Am Wed, Jan 28, 2004 at 01:22:14PM -0500, Jeff Painter meinte:
> 
> 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 

-- 
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

In die Kirche ging ich morgens,
um Komödien zu schauen,
abends ins Theater, um mich
an der Predigt zu erbauen.
    -- Heinrich Heine (Reisebilder)

---------------------------------------------------------------------
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