db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Bonner <brian.bon...@paraware.com>
Subject Re: Clob support Error 54002
Date Wed, 17 Aug 2005 03:50:00 GMT
Sunitha, I'm using a straight insert statement within "ij".  Basically 
preloading data.  I should have checked the bug database.  Thanks.


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.

View raw message