Sunitha, I'm using a straight insert statement within "ij". Basically
preloading data. I should have checked the bug database. Thanks.
Brian
Sunitha Kambhampati wrote:
> Brian Bonner wrote:
>
>> I'm trying to insert data into field of a table created with CLOB(100
>> K). The text is only 40K in size, but it keeps throwing an error:
>>
>> ERROR 54002: A string constant starting with ''<?xml
>> version=\"1.0\"?>\n\n<root>\n <dynamic-element name=&' is too long.
>>
>> Any thoughts on this?
>>
> How are you trying to do the insert ?
>
> There is a limitation in string constants (literals) in the text of a
> SQL statement. But if you use prepared statement and use dynamic
> markers ('?') instead of a constant, you should be able to insert
> larger values. See
> http://issues.apache.org/jira/browse/DERBY-102#action_56627
>
> Sunitha.
|