You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Mitch Christensen <mi...@informatixinc.com> on 2002/10/22 14:12:45 UTC
Fixing TDK (2.2b3) WRT Oracle
Hey,
Building the 2.2b3 TDK, and running against an Oracle database demonstrates
a bug in the current code. Every time you 'Logout' of the flux app, an
exception gets thrown as the User.perm data is persisted to the database. I
found the problem on the Torque mailing list. The TURBINE_USER.OBJECTDATA
field is currently defined as a BLOB data type. This doesn't work with
Oracle (for whatever reason). This needs to be changed to LONG RAW to get
it to work. I've made the change locally, and everything works fine.
Unfortunately, every time I ant init (to modify my schema), the database
gets set back to BLOB.
Can someone with the appropriate know-how/permissions modify the code
(probably XSLT script) that is specifying BLOB for Oracle, and have it spit
out LONG RAW instead? Of course, I'm assuming (hoping) that this code is
separate for each database vendor.
-Mitch
RE: Fixing TDK (2.2b3) WRT Oracle
Posted by Peter Courcoux <pe...@courcoux.biz>.
I haven't followed the whole of this thread, and you may have looked at
this but my copy of torque (B3) db.props file show oracle fields mapped
as below. Can you map your field to an alternative type or change the
mapping in the db.props file? The db.props file is in
torque/src/templates/sql/base/oracle.
BIT = NUMBER (1, 0)
TINYINT = NUMBER (3, 0)
SMALLINT = NUMBER (5, 0)
INTEGER = NUMBER
BIGINT = NUMBER (20, 0)
FLOAT = FLOAT
REAL = NUMBER
DOUBLE = FLOAT
NUMERIC = NUMBER
DECIMAL = NUMBER
CHAR = CHAR
VARCHAR = VARCHAR2
LONGVARCHAR = VARCHAR2 (2000)
DATE = DATE
TIME = DATE
TIMESTAMP = DATE
BINARY = LONG RAW
VARBINARY = BLOB
LONGVARBINARY = LONG RAW
NULL =
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB = BLOB
CLOB = CLOB
REF =
NOTNULL = NOT NULL
Hope this helps.
Regards,
Peter Courcoux
On Wed, 2002-10-23 at 17:08, Mitch Christensen wrote:
> I tried this, I'm still getting BLOBs.
>
> -Mitch
>
> -----Original Message-----
> From: Zsombor Gegesy [mailto:deepspace@mailbox.hu]
> Sent: Tuesday, October 22, 2002 2:09 PM
> To: Turbine Users List
> Subject: Re: Fixing TDK (2.2b3) WRT Oracle
>
>
>
> MC> Can someone with the appropriate know-how/permissions modify the code
> MC> (probably XSLT script) that is specifying BLOB for Oracle, and have it
> spit
> MC> out LONG RAW instead? Of course, I'm assuming (hoping) that this code
> is
> MC> separate for each database vendor.
>
> MC> -Mitch
>
>
> Grab a fresh torque.jar from http://jakarta.apache.org/turbine/torque ,
> replace the one in WEB-INF/lib, and that's all (as I hope:)
>
> Best regards,
> Zsombor mailto:deepspace@mailbox.hu
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Fixing TDK (2.2b3) WRT Oracle
Posted by Mitch Christensen <mi...@attbi.com>.
I tried this, I'm still getting BLOBs.
-Mitch
-----Original Message-----
From: Zsombor Gegesy [mailto:deepspace@mailbox.hu]
Sent: Tuesday, October 22, 2002 2:09 PM
To: Turbine Users List
Subject: Re: Fixing TDK (2.2b3) WRT Oracle
MC> Can someone with the appropriate know-how/permissions modify the code
MC> (probably XSLT script) that is specifying BLOB for Oracle, and have it
spit
MC> out LONG RAW instead? Of course, I'm assuming (hoping) that this code
is
MC> separate for each database vendor.
MC> -Mitch
Grab a fresh torque.jar from http://jakarta.apache.org/turbine/torque ,
replace the one in WEB-INF/lib, and that's all (as I hope:)
Best regards,
Zsombor mailto:deepspace@mailbox.hu
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Fixing TDK (2.2b3) WRT Oracle
Posted by Zsombor Gegesy <de...@mailbox.hu>.
MC> Can someone with the appropriate know-how/permissions modify the code
MC> (probably XSLT script) that is specifying BLOB for Oracle, and have it spit
MC> out LONG RAW instead? Of course, I'm assuming (hoping) that this code is
MC> separate for each database vendor.
MC> -Mitch
Grab a fresh torque.jar from http://jakarta.apache.org/turbine/torque ,
replace the one in WEB-INF/lib, and that's all (as I hope:)
Best regards,
Zsombor mailto:deepspace@mailbox.hu
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>