Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Large data entry issue

 
Ed Carrington
Ranch Hand
Posts: 77
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ed, I believe this explains your issue and how to get around it.

http://www.devx.com/tips/Tip/14437
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic