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.
