You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by Mike Cantrell <Mi...@ind.alcatel.com> on 2002/08/29 23:25:20 UTC
Updating Oracle CLOBs with JSTL sql tags
Is there any way to get JSTL to update Oracle CLOBs with large amounts
of data? the <sq:update> tag works fine until it reaches the 4k limit.
Anything larger results in:
Data size bigger than max size for this type: 27257
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Updating Oracle CLOBs with JSTL sql tags
Posted by Mike Cantrell <Mi...@ind.alcatel.com>.
Ugh, ya... it appears to be a problem with the Oracle thin-JDBC drivers.
They won't even update using setAsciiStream (it throws no errors but
just sets the field to null if it's over 4k). I guess I need to install
the OCI drivers and give it a try.
Shawn Bayern wrote:
>On Thu, 29 Aug 2002, Mike Cantrell wrote:
>
>
>
>>Is there any way to get JSTL to update Oracle CLOBs with large amounts
>>of data? the <sq:update> tag works fine until it reaches the 4k limit.
>>Anything larger results in:
>>
>> Data size bigger than max size for this type: 27257
>>
>>
>
>Do you get this because the update has a large literal, or does the error
>actually come from <sql:param>.
>
>It sounds like a limitation of the Oracle JDBC driver, though; JSTL is
>specified to use setObject() to set parameters. But perhaps I'd be able
>to come up with a workaround if I knew a little more about your situation.
>
>
>
Re: Updating Oracle CLOBs with JSTL sql tags
Posted by Shawn Bayern <ba...@essentially.net>.
On Thu, 29 Aug 2002, Mike Cantrell wrote:
> Is there any way to get JSTL to update Oracle CLOBs with large amounts
> of data? the <sq:update> tag works fine until it reaches the 4k limit.
> Anything larger results in:
>
> Data size bigger than max size for this type: 27257
Do you get this because the update has a large literal, or does the error
actually come from <sql:param>.
It sounds like a limitation of the Oracle JDBC driver, though; JSTL is
specified to use setObject() to set parameters. But perhaps I'd be able
to come up with a workaround if I knew a little more about your situation.
--
Shawn Bayern
"JSTL in Action" http://www.jstlbook.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>