What is current status of LOBs with Oracle?

[Chris Rossi <ro...@webslingerZ.com>]

Hello,

I remember having seen previously conversation on this list concerning
getting OJB to be able to work with LOBs in Oracle.  I remember there
being some philosophical debate on how best to attack this problem, and
I remember that some people had patched their own code to get this to
work, but there hadn't been any decision as to what to do to the current
codebase.

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?

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.

rossi


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

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

 

Re: What is current status of LOBs with Oracle?

[Rajeev Kaul <Ra...@customercaresolutions.com>]

You will find a patch in the archives that works with Oracle OCI driver.
The patch does not appear to work for lobs > 4000 with the Oracle thin
driver.

----- Original Message -----
From: "Chris Rossi" <ro...@webslingerZ.com>
To: <oj...@db.apache.org>; <oj...@db.apache.org>
Sent: Friday, February 28, 2003 8:45 AM
Subject: What is current status of LOBs with Oracle?


> Hello,
>
> I remember having seen previously conversation on this list concerning
> getting OJB to be able to work with LOBs in Oracle.  I remember there
> being some philosophical debate on how best to attack this problem, and
> I remember that some people had patched their own code to get this to
> work, but there hadn't been any decision as to what to do to the current
> codebase.
>
> 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?
>
> 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.
>
> rossi
>
>
> ---------------------------------------------------------------------
> 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