db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: Clob support Error 54002
Date Wed, 17 Aug 2005 00:04:36 GMT
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.

Mime
View raw message