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-25 21:53:26]

# 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?
# 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.