Just like genman has suggested, you can use the same datasource config file but different table name withing the same Oracle SID or schema
eg. JMS_MESSAGES, JMS_TRANSACTIONS vs. NODEX_JMS_MESSAGES , NODEX_JMS_TRANSACTIONS You can specify the table that JMS uses in jboss-mqservice.xml. | <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager" | name="jboss.mq:service=PersistenceManager"> | <depends optional-attribute-name="MessageCache">jboss.mq:service=MessageCache</depends> | <depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS</depends> | <attribute name="SqlProperties"> | BLOB_TYPE=BINARYSTREAM_BLOB | INSERT_TX = INSERT INTO NODEX_JMS_TRANSACTIONS (TXID) values(?) | INSERT_MESSAGE = INSERT INTO NODEX_JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?) | SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM NODEX_JMS_TRANSACTIONS | SELECT_MAX_TX = SELECT MAX(TXID) FROM NODEX_JMS_MESSAGES | SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM NODEX_JMS_MESSAGES WHERE DESTINATION=? | SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM NODEX_JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? | MARK_MESSAGE = UPDATE NODEX_JMS_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=? | UPDATE_MESSAGE = UPDATE NODEX_JMS_MESSAGES SET MESSAGEBLOB=? WHERE MESSAGEID=? AND DESTINATION=? | UPDATE_MARKED_MESSAGES = UPDATE NODEX_JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? | UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE NODEX_JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND TXID=? | DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM NODEX_JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM NODEX_JMS_TRANSACTIONS) AND TXOP=? | DELETE_TX = DELETE FROM NODEX_JMS_TRANSACTIONS WHERE TXID = ? | DELETE_MARKED_MESSAGES = DELETE FROM NODEX_JMS_MESSAGES WHERE TXID=? AND TXOP=? | DELETE_MESSAGE = DELETE FROM NODEX_JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? | CREATE_MESSAGE_TABLE = CREATE TABLE NODEX_JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \ | DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \ | MESSAGEBLOB LONG RAW, PRIMARY KEY (MESSAGEID, DESTINATION) ) | CREATE_TX_TABLE = CREATE TABLE NODEX_JMS_TRANSACTIONS ( TXID INTEGER ) | CREATE_TABLES_ON_STARTUP = false | </attribute> | </mbean> | | <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825996#3825996";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825996>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
