This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Pls give me solution to solve Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Pls give me solution to solve "String literal too long" problem: " Watch "Pls give me solution to solve "String literal too long" problem: " New topic
Author

Pls give me solution to solve "String literal too long" problem:

rose deng
Ranch Hand

Joined: Dec 29, 2000
Posts: 78
HI,
When I use jdbc to do update to a table in oracle database(the type of updated field is Clob), i got following error: String literal is too long.
Could anyone throw a light on how to solve this problem.
Thanks Soo much.
Tanel Alumae
Greenhorn

Joined: Aug 26, 2002
Posts: 14
Usually this happens when one tries to put the field value directly into the SQL statement. Are you using parameters?
E.g.


RefactorIT - Java Refactoring Tool<br /><a href="http://www.refactorit.com" target="_blank" rel="nofollow">www.refactorit.com</a>
 
GeeCON Prague 2014
 
subject: Pls give me solution to solve "String literal too long" problem: