Hello,

While checking the implementation of the JDBC Message Store I noticed that
the implementation starts by checking if the tables exist (as
per AbstractJDBCMessageStore#upgrade).

However, the check for table existence in JdbcUtils doesn't filter on a
specific schema:

ResultSet rs = metaData.getTables(null, null /*Schema Pattern*/, "%", null);

If we have previously persisted messages on schema A, and we are currently
launching another broker instance on schema B the above "schema-less" check
would consider that the tables already exist. Wouldn't this wrongly skip
the creation of tables on schema B. Or have I misunderstood the above
check?

Best regards,
Rawad.

Reply via email to