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: > <mailto:turbine-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: > <mailto:turbine-user-help@;jakarta.apache.org> > > > -- > To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
