2 Replies Latest reply on Mar 6, 2005 2:13 PM by tomdee

    How to make JBoss JMS works with Oracle in multi-developers

    Ben Truong Newbie

      Can JBoss JMS with Oracle persistence storage works in multi-developers environment where developers run JBoss on their desktops and all have the same persistence configuration that points to the same Oracle database. I noticed the oracle-jdbc-state-service.xml has a line: CREATE_TABLES_ON_STARTUP = TRUE. It implies that a JMS instance expected it own the persistence tables exclusively. If one developer is running Jboss while another developer starts a new instance of JBoss, would it interferes each other? If it does, how can we work around this?

        • 1. Re: How to make JBoss JMS works with Oracle in multi-develop
          Dimitris Andreadis Master

          Please, try the User JMS/Messaging forum

          • 2. Re: How to make JBoss JMS works with Oracle in multi-develop
            tomdee Newbie

            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)