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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
