aspose file tools*
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 Spring in Action this week in the Spring 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: 211
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: From hsqldb to oracle for JMS message persistence