LONG RAW Problem on Oracle needs to be addressed, I think

[Jason McKerr <mc...@nacse.org>]

Hey guys, a lot of people are running into the problem of two LONG RAW
columns in Oracle.  In the OJB_DMAP_ENTRIES two LONGVARBINARY are
created.

In oracle, this translates to two LONG RAW columns which is illegal in
oracle 9i or 8i.

So basically, I need to know if it's OK to use RAW columns for the
various LONGVARBINARY columns in the OJB Core tables?

If so, can you guys change the db.props file in the
torque/sql/base/oracle directory to RAW?

The real issue is that RAW only supports 2000 length, and LONG raw is 2
Gigs.

Jason

Re: LONG RAW Problem on Oracle needs to be addressed, I think

[Jason McKerr <mc...@nacse.org>]

That sounds fine.  VARBINARY maps to BLOB.

J

On Tue, 2003-06-17 at 13:25, Thomas Mahler wrote:
> hi again,
> 
> <snip>
> 
> > Maybe it's easier to simply change LONGVARBINARY to VARBINARY in our 
> > torque scripts...
> 
> checked into CVS!
> 
> > cheers,
> > Thomas
> > 
> >>
> >> The real issue is that RAW only supports 2000 length, and LONG raw is 2
> >> Gigs.
> >>
> >> Jason
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> >> For additional commands, e-mail: ojb-user-help@db.apache.org
> >>
> >>
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org

Re: LONG RAW Problem on Oracle needs to be addressed, I think

[Thomas Mahler <th...@web.de>]

hi again,

<snip>

> Maybe it's easier to simply change LONGVARBINARY to VARBINARY in our 
> torque scripts...

checked into CVS!

> cheers,
> Thomas
> 
>>
>> The real issue is that RAW only supports 2000 length, and LONG raw is 2
>> Gigs.
>>
>> Jason
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

Re: LONG RAW Problem on Oracle needs to be addressed, I think

[Thomas Mahler <th...@web.de>]

Hi Jason,

Jason McKerr wrote:
> Hey guys, a lot of people are running into the problem of two LONG RAW
> columns in Oracle.  In the OJB_DMAP_ENTRIES two LONGVARBINARY are
> created.
> 
> In oracle, this translates to two LONG RAW columns which is illegal in
> oracle 9i or 8i.
> 
> So basically, I need to know if it's OK to use RAW columns for the
> various LONGVARBINARY columns in the OJB Core tables?
> 

Yes, that should be fine.
We need those columns to store gzipped serialized Identity Objects. 
Unfortunately there is no fixed size to them (an Identity could have any 
number of primary key attributes).
But they should < 1024 bytes for nearly all possible applications.

so using raw(2000) should be perfect.

> If so, can you guys change the db.props file in the
> torque/sql/base/oracle directory to RAW?

We have to tell the Torque team about this issue.
Maybe it's easier to simply change LONGVARBINARY to VARBINARY in our 
torque scripts...

cheers,
Thomas

> 
> The real issue is that RAW only supports 2000 length, and LONG raw is 2
> Gigs.
> 
> Jason
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
>