Supported Databases

Which databases are supported by Sun as a persistent store for the Sun JMS Broker? The Admin Guide contains this statement:

"The Persistence Manager is configured by default to access a built-in, file-based data store, but you can reconfigure it to plug in any data store accessible through a JDBC-compliant driver."

This suggests that you can use any db you want. However, since the config file template contains schemas only for Oracle, Pointbase and Cloudscape I assume using anything else is unsupported and untested.

What if in a production environment I want to use mySQL or PostgreSQL, SQL Server or DB2/UDB? Does Sun support such a setup?

[678 byte] By [kibitzer] at [2007-11-13]
# 1
You can find this info in the Release notes for a given version.Here is a ptr to the current docs -- http://docs.sun.com/app/docs/coll/1307.1Specifically, see -- http://docs.sun.com/source/819-2569/index.html#wp35163
gtharakan at 2007-7-5 > top of java,Application & Integration Servers,Sun Java System Message Queue...
# 2
Sure, and that's good to know, but it doesn't answer my question. What if I want to use another database? What if I don't have Oracle or Pointbase?
kibitzer at 2007-7-5 > top of java,Application & Integration Servers,Sun Java System Message Queue...
# 3

We have tried to keep our jdbc database implementation agnostic ...unfortunately SQL changes between databases - so our implementation may or may not work with other databases.

you should be able set up MQ to work with other databases by setting the properties documented in the default.properties file ...

However we DO NOT support it (if you have a problem you will have to duplicate it on a supported databases)

We are expanding our list of supported databases in future releases.

Linda_Schneider at 2007-7-5 > top of java,Application & Integration Servers,Sun Java System Message Queue...
# 4
Linda, thanks for the reply. Just wanted to confirm that was the case. Guess I'll throw away my MS Access implementation ;-)
kibitzer at 2007-7-5 > top of java,Application & Integration Servers,Sun Java System Message Queue...