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
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: 207
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: From hsqldb to oracle for JMS message persistence