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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.