aspose file tools*
The moose likes JDBC and the fly likes Large data entry issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Large data entry issue" Watch "Large data entry issue" New topic
Author

Large data entry issue

Ed Carrington
Ranch Hand

Joined: Oct 11, 2007
Posts: 77
My Form entry uses a Clob data type. The insert always works using Java PreparedStatement if the form entry is under 4000 characters. The database is Oracle 9i using ojdbc14 driver on my Tomcat web container.
Due to restrictions I cant update the ojdbc14 driver at this time.

The issue is when the Form entry is over 4000 characters it wont enter any data into the database. The error message I get: SQL Exception: Data size bigger than max size for the type: 12463

Please advise how I can make it work?
[ December 17, 2008: Message edited by: Ed Carrington ]
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Originally posted by Ed Carrington:
My Form entry uses a Clob data type. The insert always works using Java PreparedStatement if the form entry is under 4000 characters. The database is Oracle 9i using ojdbc14 driver on my Tomcat web container.
Due to restrictions I cant update the ojdbc14 driver at this time.

The issue is when the Form entry is over 4000 characters it wont enter any data into the database. The error message I get: SQL Exception: Data size bigger than max size for the type: 12463

Please advise how I can make it work?

[ December 17, 2008: Message edited by: Ed Carrington ]


I believe prior to Oracle 10G, you need to use the Oracle extension class oracle.sql.CLOB with CLOB data.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Ed, I believe this explains your issue and how to get around it.

http://www.devx.com/tips/Tip/14437
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Large data entry issue