[prev in list] [next in list] [prev in thread] [next in thread] 

List:       taglibs-user
Subject:    Re: Updating Oracle CLOBs with JSTL sql tags
From:       "Mike Cantrell" <Mike.Cantrell () ind ! alcatel ! com>
Date:       2002-08-30 20:10:51
[Download RAW message or body]


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.
>
>  
>


[prev in list] [next in list] [prev in thread] [next in thread]