Just so other know,
I was trying to test performance of messages persistence across a couple of database
engine (Hypersonic, PostgreSQL, MySQL and Oracle). So i've made a simple program to
create N subscriber and publish N messages. I've also create a JBoss instance for each
of those database. Everything works fine on all database except orable which was always
throwing at .publish(message) "java.sql.SQLException: Io Exception: Connection
reset).
After spending almost a day trying to figured out what was wrong with my oracle
configuration, I manage to get that it was the size of my message (a typical xml message
in our current application of 7382 bytes) was to big for the "messageblob" field
in the "jms_message" table.
So I needed to change the type of "jms_message.messageblob" from
"blob" to "long raw" in server/default/jms/hsqldb-jdbc2-service.xml.
But in Oracle documentation they "strongly recommends" that we use
"BLOB" as a replacement of "LONG RAW".
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_e...
So why is BLOB failing?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4000624#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...