openjms and db2
"Mike Miller" <[email protected]>
| Newsgroups | gmane.comp.java.openjms.devel |
|---|---|
| Message-ID | <[email protected]> |
I have a question regarding OpenJMS. I have had no problem with any database except for db2. The issue I have is when OpenJMS is trying to add an object into the messages table. When it tries to insert an object I get the following error: javax.jms.JMSException: Failed to addPersistentMessage : javax.jms.JMSException: Failed to addPersistentMessage : org.exolab.jms.persistence.PersistenceException: add msg [IBM][CLI Driver][DB2/6000] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001 I looked at the create table script for the MESSAGES table and the MESSAGEBLOB field has a data type of BLOB (100K). I looked at the source code and in the prepare statement sets it as a byte stream (obviously of some undetermined length). I figure the problem centers around the database because if I set the persistence to non-persistent the error does not occur. I am not sure how to fix this problem. I have asked our db2 DBA's and they compared the differences between the oracle and db2 create scripts and they do not see a problem. I do not want to go in and alter the existing source code. Is there some way to alter the table to fix this problem? Has this problem occurred before? Another question the DBA's keep asking me is why there are 2 less tables in db2 verses oracle. Thanks for any help you can give me.