Re: What is current status of LOBs with Oracle?

[Per-Olof Norén <pe...@alma.nu>]

Chris, all,

Chris Rossi wrote:

<snip/>

>
>
> My apologies if this has already been addressed and I just lost it in
> the volume of email, but I'm wondering now, has this been resolved?  Or
> are LOBs under Oracle still broken?  Does anybody have a patch they
> would share that works for OJB 0.9.9?

We´re currently at the same position with our project. We´re using the 
cvs 1.0 version though.
I´ve prosponed the introduction of BLOB part of our mapping file.
I need however this to be working on oracle 8.1.7 and 9i by the end of 
this weekend.
So if  the solution is as simple as a patch I´ll make it available to 
this list.
I know from experience though, making it work for oracle might very well 
break for other dbmses.
Of course there is the "OraclePlatformImpl.java" already  in place in 
OJB, where there is an attempt to handle issues with oracle, including 
BLOB´s varbinary and such. I had other problems that are now fixed, so I 
will know during the weekend if this really is an issue or not for my 
project.

>
>
> At any rate, I've hit a point where the ability to do LOBs in Oracle is
> a basic requirement.  If I can't do it with OJB then I'm going to have
> to do it with something else. 

Of course LOB´s should be available with OJB. I´m taking the fact the 
code in OraclePlatformImpl is not deprecated and tries to handle this as 
 a proof of the  OJB project´s intention to make this work. As I said 
earlier, if I reach a useful conclusion I´ll let the list know

Regards,
Per-Olof Norén
Curalia AB