Re: CLOBs vs. Oracle!

[Robert S. Sfeir]

On Tuesday, Jan 28, 2003, at 16:59 US/Eastern, Rajeev Kaul wrote:

Michael,

Okay. May be my solution only works for the Oracle "OCI" driver - not the
Oracle "thin" driver. Is there any problem in using the OCI driver in
webapps?

yeah you're not portable and you have to install the Oracle client to get that. Thin driver (type 4) only requires the jdbc driver and you're on your way. OCI is not any faster either.

R

Rajeev
----- Original Message -----
From: "Michael Mogley" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 1:40 PM
Subject: Re: CLOBs vs. Oracle!

Rajeev,

I believe this problem occurs with the thin driver, which represents the
typical scenario for a web app.

Michael

----- Original Message -----
From: "Rajeev Kaul" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>; "Michael Mogley"
<[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 12:05 PM
Subject: Re: CLOBs vs. Oracle!

Michael,

Yes, I have run the BlobTest (OJB supplied test case) with size set to
10000, and I have had no problem. I know some other users also have
reported problems with size > 4000. However, I cannot seem to recreate

the

problem on my end.  I do not know if it has anything to do with the
PersistentBroker API, driver(OCI8) and Oracle version (8.1.7) I am

using.

Rajeev
----- Original Message -----
From: "Michael Mogley" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 10:56 AM
Subject: Re: CLOBs vs. Oracle!

Rajeev,

Have you tested this fix for strings greater than 4K? I've tried the
setCharacterStream approach in the past and have had problems with it.

Michael

----- Original Message -----
From: "Rajeev Kaul" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>; "sclark"
<[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 10:24 AM
Subject: Re: CLOBs vs. Oracle!

CLOBs do not work out of the box with Oracle and 0.9.8.  However, I

have

managed to make them work for me with Oracle 8.1.7 and OJB 0.9.8.

with

the

attached modifications. I have also included my repository settings

if

they

are of any help.


----- Original Message -----
From: "sclark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 4:33 PM
Subject: CLOBs vs. Oracle!

I'm having trouble getting CLOBs to work with Oracle (9.0.1, OJB

0.9.8),

and in

truth I'm not clear whether they are expected to.  I have tried

with

and

without

various pieces of Rajeev's patch from last November

(http://archives.apache.org/eyebrowse/ReadMsg?listId=107&msgNo=3610),

which has

not been committed to CVS, and I get a variety of exceptions

during

read,

write,

or both.

Can somebody confirm whether CLOBs work out of the box with Oracle

and

0.9.8?

thanks,
-steve


--
To unsubscribe, e-mail:

<mailto:[EMAIL PROTECTED]>

For additional commands, e-mail:

<mailto:[EMAIL PROTECTED]>

---------------------------------------------------------------------- ----

--

----

--
To unsubscribe, e-mail:

<mailto:[EMAIL PROTECTED]>

For additional commands, e-mail:

<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:

<mailto:[EMAIL PROTECTED]>

For additional commands, e-mail:

<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:

<mailto:[EMAIL PROTECTED]>

For additional commands, e-mail:

<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]