Yes, we are using Sybase exclusively for all our database work with turbine
and using torque generated sql and om. I have run the torque-3.0 test-bed
against sybase, but we are not currently using the decoupled torque for
production. We are using the 2.2b1 version for production ( before the
decoupled torque was integrated ).
To use sybase's identity fields, you'll need to set the idMethod= attribute
on the table to "native". Then IDBroker won't be used. Check out the docs
for torque.
-----Original Message-----
From: Peter Francq
To: Turbine Users List (E-mail)
Sent: 3/13/02 4:07 AM
Subject: Sybase
Hi list,
Has anyone running a turbine on sybase?
I have some issues that need explanation ;-)
Were the sql scripts tested? Seems not to me, if they where tested on
which
version of Sybase (I'm using sybase 12)
So are there newer scripts or should I mail the adapted scripts that I
made
to the community?
In the package org.apache.turbine.util.db there is a class called
IDBroker
I think there's a bug on line 752 of method updateRow() where following
code
can be found
.append( " SET next_id= " )
should it not say
.append(" SET NEXT_ID= ")
with capital letters for NEXT_ID ?
OK, I know this should not happen with sybase as you can set a table to
IDENTITY in order to get autoincremented id's. That easy to do in the
sql
script where the table is created, but how do i configure trubine to use
those autoincremented ID's. Where can I set what property in order to
not
use the ID_Table?
I found the problem as I was installing jetspeed which uses turbine. The
portal will be used internally in our company, but the only database I
can
use is Sybase so please can you help me?
I'm using version 2.1 and I get a constant error from Sybase when adding
a
user. "illegal table name next_id" I know this question should be asked
in
the jetspeed mailinglist, but the error occurs in the turbine part of it
so
I post it here ;-)
Any remarks are welcome,
regards and tnx in advance
Peter
_________________________________________
Peter Francq
Java Developer
swITch nv/sa
Tel: +32 2 254.13.47
Fax: +32 2 254.13.00
e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
