I am trying to reconfigure JMS to use Oracle instead of the Hypersonic database default. To avoid Adrian's wrath, I did quite a bit of research on my own ;)
Looking on the forums, I found the references to docs/examples/jms, and copied over the XML file for oracle, pointing it to my oracle DS, running against Oracle 9i, JBoss 3.2.3. Even though the create_tables flag was set to true, when I first tried to run my sample test, I got exceptions claiming that the table did not exist. So I created the JMS_Messages table using this command: CREATE TABLE JMS_MESSAGES ( MESSAGEID integer NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXOP CHAR(1), txid integer, MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) ); Now, when I try and run my tests, I get the following exception: [OIL Worker-9] 17:27:52,063 WARN [OILServerILService] Client request resulted in a server exception: org.jboss.mq.SpyJMSException: Could not store message: 1 msg=0 hard NOT_STORED PERSISTENT queue=QUEUE.QueueInvokerManage r priority=4 hashCode=15590814; - nested throwable: (java.sql.SQLException: Invalid column type) Did I not create the JMS table correctly? Are there any problems using the OCI driver for oracle instead of the thin driver? Any help would be appreciated. Thanks. -Dan View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3837151#3837151 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3837151 ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
