Hi, thanks for your response.
This works fine for me. However I am noticing one problem. In Oracle you
need to specify the size of a RAW, so the turbine-schema needs to have
the size attribute put into the VARBINARY columns. This would cause
problems for mysql users because mysql maps VARBINARY to MEDIUMBLOB
which does not take a size. My "solution" was to set VARBINARY = RAW
(2000) in the Oracle db.props file (I won't send a patch because this is
not a general solution).
I am currently developing locally with mysql and deploying to oracle, so
I need this flexibility. Just a heads up...
Chris C
>-----Original Message-----
>From: Stephane Bailliez [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, July 25, 2001 12:12 AM
>To: [EMAIL PROTECTED]
>Subject: RE: Torque, Oracle, and VARBINARY
>
>
>> -----Original Message-----
>> From: Chris Campbell [mailto:[EMAIL PROTECTED]]
>> For Oracle schema, toque is creating VARBINARY columns (The
>ObjectData
>> columns in particular) as LONG RAW. My Oracle friends tell me
>> that LONG
>> RAW can be up to 2 gigs in size and that RAW would be a better choice
>> for most of these columns for reasons of efficiency, not to
>> mention you
>> can only put one LONG RAW in an Oracle table. Now RAW can be
>> up to 2k in
>> size. Would I run into any problems with turbine if I make
>> this change?
>
>Hi Chris,
>
>This is also what I suggested a couple of days ago for the mapping.
>
>You can find my patch here:
>http://www.mail-archive.com/turbine-dev%40jakarta.apache.org/ms
g01973.html
And some additional info:
http://www.mail-archive.com/turbine-dev%40jakarta.apache.org/msg02091.ht
ml
If you have some Oracle guys near you, it might be a good idea to show
them
this mapping so they can give their feedback.
--
St�phane Bailliez
Software Engineer, Paris - France
iMediation - http://www.imediation.com
Disclaimer: All the opinions expressed above are mine and not those
from my
company.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
