Hi Rawad Your analysis of the code is correct, currently the JDBCMessageStore feature assumes exclusive use of the a schema. This is really a reflection of the way this store module evolved - out of the Derby store. It probably would not be too hard to change the code so that sharing a schema becomes possible, but it is not something on the road map for the near future. If the feature would be useful to you, feel free to submit a patch.
Kind regards, Keith Wall. On 29 November 2016 at 16:19, Rawad Assaf <[email protected]> wrote: > Hi, > > I am trying to use a JDBC message store to persist messages of the default > virtualhost on an Oracle RDBMS. > > Looking at the SQL statements used (as per > https://github.com/apache/qpid-java/blob/trunk/broker-core/src/main/java/org/apache/qpid/server/store/AbstractJDBCMessageStore.java) > it doesn't look as if I can persist messages from multiple brokers in the > same Database Instance. > > Is this really the case? If yes, are there any plans to add such a feature > in future? It would be really practical not to have to create a separate > Database Instance for each broker. > > > Best regards, > Rawad. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
