1 Reply Latest reply on Apr 29, 2011 12:05 PM by Tom Cunningham

    Muliple JBOSSESB Oracle schema on Single Db instance

    Raghavan TV Newbie

      We are doing a POC to cluster the JBOSSESB-4.8 using Oracle as the persistence store.


      We already have a JBOSSESB-server (not bundled with AS) running in a standalone mode with ORACLE as the persistence layer.

      (Schema name: JBOSSESB)


      We are planning to perform a POC to setup a clustered JBOSSESB setup before replacing the standalone instance with a clustered instance.

      - Created a new schema called JBOSSESB_CLUSTER for the new instance.

      - Apart from the normal db switch configuration added

      <property name="hibernate.default_schema" value="JBOSSESB_CLUSTER"/>

      to jbossesb-registry.sar\META-INF\persistence.xml


      Now, when we start the new instance, we observe from the logs that the registry layer is interaction with the other schema (JBOSSESB) as well

      Attached herewith the startup logs for reference.


      Is it wrong to have more than one instance of schema on the same DB ?

      Is there any other configuration that is missing ?