Another idea is to use an additional column to identify your different users, and each user should have his/her own datasource *-ds.xml with his/her Oracle user in tag <user-name>.
Example : oracle-ds.xml | <datasources> | <local-tx-datasource> | <jndi-name>OracleDS</jndi-name> | <connection-url>jdbc:oracle:thin:@youroraclehost:1521:yoursid</connection-url> | <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> | <user-name>SCOTT</user-name> | <password>TIGER</password> | </local-tx-datasource> | </datasources> | 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 JMS_TRANSACTIONS (TXID,USERNAME) values(?,USER) | INSERT_MESSAGE = INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP, USERNAME) VALUES(?,?,?,?,?,USER) | SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM JMS_TRANSACTIONS WHERE USERNAME=USER | SELECT_MAX_TX = SELECT MAX(TXID) FROM JMS_MESSAGES WHERE USERNAME=USER | SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE DESTINATION=? AND USERNAME = USER | SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? AND USERNAME = USER | MARK_MESSAGE = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=? AND USERNAME = USER | UPDATE_MESSAGE = UPDATE JMS_MESSAGES SET MESSAGEBLOB=? WHERE MESSAGEID=? AND DESTINATION=? AND USERNAME = USER | UPDATE_MARKED_MESSAGES = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND USERNAME = USER | UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND TXID=? AND USERNAME = USER | DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IN (SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP=? AND USERNAME = USER | DELETE_TX = DELETE FROM JMS_TRANSACTIONS WHERE TXID = ? AND USERNAME = USER | DELETE_MARKED_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXID=? AND TXOP=? AND USERNAME = USER | DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? AND USERNAME = USER | CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \ | DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), USERNAME VARCHAR2(50), \ | MESSAGEBLOB LONG RAW, PRIMARY KEY (MESSAGEID, DESTINATION) ) | CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER, USERNAME VARCHAR2(50) ) | CREATE_TABLES_ON_STARTUP = false | </attribute> | </mbean> | | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831681#3831681 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831681 ------------------------------------------------------- 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
