aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
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>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Pls give me solution to solve "String literal too long" problem: