This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 "the string constant beginning with ..... is too long" error" Watch "DB2 "the string constant beginning with ..... is too long" error" New topic
Author

DB2 "the string constant beginning with ..... is too long" error

Rakesh Basani
Ranch Hand

Joined: Jun 04, 2012
Posts: 38
Hi all,


I am trying to insert a row into a table which contains a column of XML datatype. My xml data is too long (more than 100000 characters).
When I write "insert query" for this, it is throwing following exception..


The string constant beginning with "'<!--Sample XML file generated by XMLSpy v2013 sp1 (http://www.altova." is too long.. SQLCODE=-102, SQLSTATE=54002, DRIVER=3.59.81


Thanks in advance..







 
Consider Paul's rocket mass heater.
 
subject: DB2 "the string constant beginning with ..... is too long" error
 
Similar Threads
when does an SQLWarning occurs ?
confuse about StringBuffer insert method
How do you parse an XML File?
Clob with EJB1.1
compile time constant doubt