This discussion is archived
1 Reply Latest reply: Oct 10, 2012 1:15 PM by damorgan RSS

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

967443 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points