JBossMQ should use the <type-mapping> from the DataSource --------------------------------------------------------- Key: JBAS-2120 URL: http://jira.jboss.com/jira/browse/JBAS-2120 Project: JBoss Application Server Issue Type: Feature Request Security Level: Public(Everyone can see) Components: JMS service Affects Versions: JBossAS-4.0.3RC1 Reporter: Adrian Brock Priority: Minor Currently JBossMQ's JDBC2 persistence manager (http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQJDBC2Persistence) JDBC statemanager (http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQStateJDBC) have their SQL configured through a big map of system properties. This means that you need different configurations for each backend DB. See docs/examples/jms or http://www.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQDB Instead, we should use the <type-mapping> from the DataSource which uses the standardjbosscmp-jdbc.xml to map queries to the database. The only configuration required, would then be * The DataSource * Table Names * Column Names with default names for each. This should be done as a "fork", e.g. create a JDBC4 since we still want to support people with the old configurations.