Return-Path: 
 <turbine-user-return-17601-apmail-jakarta-turbine-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-turbine-user-archive@www.apache.org
Received: (qmail 33844 invoked from network); 28 Jan 2004 18:26:22 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 28 Jan 2004 18:26:22 -0000
Received: (qmail 63008 invoked by uid 500); 28 Jan 2004 18:26:04 -0000
Delivered-To: apmail-jakarta-turbine-user-archive@jakarta.apache.org
Received: (qmail 62977 invoked by uid 500); 28 Jan 2004 18:26:04 -0000
Mailing-List: contact turbine-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:turbine-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:turbine-user-subscribe@jakarta.apache.org>
List-Help: <mailto:turbine-user-help@jakarta.apache.org>
List-Post: <mailto:turbine-user@jakarta.apache.org>
List-Id: "Turbine Users List" <turbine-user.jakarta.apache.org>
Reply-To: "Turbine Users List" <turbine-user@jakarta.apache.org>
Delivered-To: mailing list turbine-user@jakarta.apache.org
Received: (qmail 62934 invoked from network); 28 Jan 2004 18:26:03 -0000
Received: from unknown (HELO mail.jivecast.com) (198.143.231.106)
  by daedalus.apache.org with SMTP; 28 Jan 2004 18:26:03 -0000
Received: by mail.jivecast.com (Postfix, from userid 500)
	id 5C9241C403E; Wed, 28 Jan 2004 13:22:15 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
	by mail.jivecast.com (Postfix) with ESMTP id 1D3961C403D
	for <turbine-user@jakarta.apache.org>; Wed, 28 Jan 2004 13:22:15 -0500 (EST)
Date: Wed, 28 Jan 2004 13:22:14 -0500 (EST)
From: Jeff Painter <painter@kiasoft.com>
X-X-Sender: painter@ipdev.imageproductsusa.com
To: Turbine Users List <turbine-user@jakarta.apache.org>
Subject: Re: Turbine / Torque mit sapdb
In-Reply-To: <20040128150932.GA28002@unycom.com>
Message-ID: 
 <Pine.LNX.4.44.0401281256350.26504-100000@ipdev.imageproductsusa.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N


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