permaculture playing cards
The moose likes JBoss/WildFly and the fly likes From hsqldb to oracle for JMS message persistence Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "From hsqldb to oracle for JMS message persistence" Watch "From hsqldb to oracle for JMS message persistence" New topic
Author

From hsqldb to oracle for JMS message persistence

Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 213
Hello,

I am migrating from hsqldb to oracle for JMS message persistence. However,
the table, JMS_MESSAGES,
CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )

the OBJECT type of MESSAGEBLOB column is not available in oracle.

Can anyone tell me which data type of MESSAGEBLOB should be used instead of OBJECT type in oracle database?


Thanks
Benson
 
Don't get me started about those stupid light bulbs.
 
subject: From hsqldb to oracle for JMS message persistence