1 Reply Latest reply: Oct 10, 2012 3:15 PM by damorgan RSS

    ORA-01401:inserted value too large for column while inserting textmessage

    967443
      Hello,

      lately i'm getting a wired exception while trying to insert a javax.jms.TextMessage via JMS into an AQ-queue:

      +oracle.jms.AQjmsException: Inserted value too large for column "[here stands the text of my message ~5kb]"; nested exception is java.sql.SQLException: Inserted value too large for column...+

      The exception only comes up every now and then and has nothing to do with the size of my text in the message (i'm getting it for a textsize around 4kb / tested >17kb without any problem). While getting the exception, other messages around that time do work fine. Some time after getting the exception it works perfectly fine when i am trying to add the message into the same queue again.
      So it can't be the message itself or the general setup of Java-jms-jdbc-OracleDB.

      Here is my setup:

      Database: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
      JDBC-Driver: thin ojdbc5 11.2.0.3
      Java SE 1.5.21
      JMS 1.1

      Here is how i am adding messages (pseudocode like):

      +TextMessage txtMsg = javax.jms.Session.createTextMessage();+
      +txtMsg.setText("[here stands the text of my message ~5kb]");+
      +javax.jms.Session.createProducer(Queue)+
      +javax.jms.MessageProducer.send(txtMsg)+

      Any ideas or hints would be greatly appreciated!

      Thank you,
      Michael