Announcement Announcement Module
No announcement yet.
Data size bigger than max size for this type Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data size bigger than max size for this type

    This error occurs when I use setString in JDBC because there is a restriction of data size: 4000 bytes
    I am using SqlUpdate to insert a registry in the database and the setters method are implicit to me...
    I read about a solution: to use setCharacterString
    But, how the setters method are implicit I don't get change the setString method to setCharacterString in this situations.
    Does somebody have any solutions ?

    Thanks in advance

  • #2
    are you using the Oracle 9i drivers (odbc14.jar)?. If so, try to switch to the Oracle 10 drivers, as far as i know there should not be such a 4K limit.



    • #3
      I'm also receiving this error when trying to insert a BLOB over 4k into an oracle table. I'm using NamedParameterJdbcDaoSupport and issuing an insert with a Map of parameters, one of which is a byte[] for the BLOB column. I did upgrade my oracle driver to 10.2.0 as recommended by this post and it did not seem to help.

      Any other advice?


      • #4
        I have just downloaded the most recent version of the odbc14.jar file and now it works
        Last edited by martynhiemstra; Jul 20th, 2007, 03:55 AM.