Please, try the User JMS/Messaging forum
WHen you said 'same Oracle database' you didn't mention whether it's
Dev shares the same Oracle Instance (or SID) or are they also sharing the same JMS* tables.
You can setup JBoss to do either cases.
a) sharing the same SID - different tables same login user
If you are just sharing the same SID but each DEV uses their own set of JMS tables, just modify the oracle-jdbc-state-service.xml file and change all table names to a prefix
e.g. JMS_TABLES --> BTRUONG_JMS_TABLES for u
and YOURBUDDY_JMS_TABLES for your buddy.
you can embed a perl script to mod the xml file inside your run.bat or run.sh to do that
b) sharing the same SID - same tables , differnt login user
each Oracle login user can own his own set of JMS* tables.. so all you
need to do is config your Oracle-ds.xml to have different user.
c) different SID - well this is easy. just do what you did in b)