File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
 
Similar Threads
Liferay deployment on JBoss
From hsqldb to oracle for JMS message persistence
JBoss with C3P0 Connection Pool Config/Usage
NameNotFoundException: MSAccessDS not bound
Troublesome EAR file deployment