Date of First Response: 2008-06-26 23:43:17
project_key: SOA

Trying to configure the management console to use MySQL:
cd jboss-as/tools/console/management-esb
set db to mysql in db.properties
set values in src/main/resources/mysql/management-ds.xml and copy this file to jboss-as/server/production/deploy
copy mysql-connector-java-5.0.7-bin.jar to jboss-as/server/production/lib
ant
copy build/management.esb to jboss-as/server/production/deploy
start MySQL
create statistics db
start AS

everything looks good, tables are created during startup, logging into the console and get:

17:35:45,778 INFO  [Configuration] configuring from resource: monitoring.cfg.xml
17:35:45,778 INFO  [Configuration] Configuration resource: monitoring.cfg.xml
17:35:45,783 INFO  [Configuration] Reading mappings from resource : org/jboss/soa/esb/monitoring/monitoring-mappings.hbm.xml
17:35:45,796 INFO  [HbmBinder] Mapping class: org.jboss.soa.esb.monitoring.pojo.JMXPattern -> JMXPATTERN
17:35:45,797 INFO  [HbmBinder] Mapping class: org.jboss.soa.esb.monitoring.pojo.JMXData -> JMXDATA
17:35:45,803 INFO  [HbmBinder] Mapping class: org.jboss.soa.esb.monitoring.pojo.JMXOperationResult -> JMXOPERATIONRESULT
17:35:45,815 INFO  [HbmBinder] Mapping class: org.jboss.soa.esb.monitoring.pojo.JMXAttribute -> JMXATTRIBUTE
17:35:45,825 INFO  [HbmBinder] Mapping class: org.jboss.soa.esb.monitoring.pojo.JMXOperation -> JMXOPERATION
17:35:45,827 INFO  [Configuration] Configured SessionFactory: null
17:35:45,844 INFO  [NamingHelper] JNDI InitialContext properties:{}
17:35:45,845 INFO  [DatasourceConnectionProvider] Using datasource: java:/ManagementDS
17:35:45,848 INFO  [SettingsFactory] RDBMS: MySQL, version: 5.0.27-standard
17:35:45,849 INFO  [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.7 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )
17:35:45,901 INFO  [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
17:35:45,904 INFO  [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
17:35:45,907 INFO  [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:35:45,907 INFO  [SettingsFactory] Automatic flush during beforeCompletion(): disabled
17:35:45,907 INFO  [SettingsFactory] Automatic session close at end of transaction: disabled
17:35:45,907 INFO  [SettingsFactory] JDBC batch size: 15
17:35:45,907 INFO  [SettingsFactory] JDBC batch updates for versioned data: disabled
17:35:45,907 INFO  [SettingsFactory] Scrollable result sets: enabled
17:35:45,907 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
17:35:45,907 INFO  [SettingsFactory] Connection release mode: auto
17:35:45,908 INFO  [SettingsFactory] Maximum outer join fetch depth: 2
17:35:45,908 INFO  [SettingsFactory] Default batch fetch size: 1
17:35:45,908 INFO  [SettingsFactory] Generate SQL with comments: disabled
17:35:45,908 INFO  [SettingsFactory] Order SQL updates by primary key: disabled
17:35:45,908 INFO  [SettingsFactory] Order SQL inserts for batching: disabled
17:35:45,908 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:35:45,908 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
17:35:45,909 INFO  [SettingsFactory] Query language substitutions: {}
17:35:45,909 INFO  [SettingsFactory] JPA-QL strict compliance: disabled
17:35:45,909 INFO  [SettingsFactory] Second-level cache: enabled
17:35:45,909 INFO  [SettingsFactory] Query cache: disabled
17:35:45,909 INFO  [SettingsFactory] Cache provider: org.hibernate.cache.NoCacheProvider
17:35:45,909 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled
17:35:45,909 INFO  [SettingsFactory] Structured second-level cache entries: disabled
17:35:45,910 INFO  [SettingsFactory] Statistics: disabled
17:35:45,910 INFO  [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
17:35:45,910 INFO  [SettingsFactory] Default entity-mode: pojo
17:35:45,910 INFO  [SettingsFactory] Named query checking : enabled
17:35:45,919 INFO  [SessionFactoryImpl] building session factory
17:35:45,921 ERROR [MonitoringSessionFactory] MonitoringSessionFactory failed to initialize!
org.hibernate.MappingException: could not instantiate id generator
        at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:98)
        at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:192)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
        at org.jboss.soa.esb.monitoring.MonitoringSessionFactory.init(MonitoringSessionFactory.java:80)
        at org.jboss.soa.esb.monitoring.MonitoringSessionFactory.getInstance(MonitoringSessionFactory.java:68)
        at org.apache.jsp.app.index_jsp._jspService(index_jsp.java:97)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.MappingException: Dialect does not support sequences
        at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:596)
        at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
        at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:94)
        ... 31 more
17:35:45,975 ERROR [STDERR] java.lang.NullPointerException
17:35:45,975 ERROR [STDERR]     at org.apache.jsp.app.index_jsp._jspService(index_jsp.java:97)
17:35:45,976 ERROR [STDERR]     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
17:35:45,976 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
17:35:45,976 ERROR [STDERR]     at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387)
17:35:45,976 ERROR [STDERR]     at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
17:35:45,976 ERROR [STDERR]     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
17:35:45,976 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
17:35:45,976 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
17:35:45,976 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
17:35:45,976 ERROR [STDERR]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
17:35:45,976 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
17:35:45,976 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
17:35:45,976 ERROR [STDERR]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
17:35:45,976 ERROR [STDERR]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
17:35:45,977 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
17:35:45,977 ERROR [STDERR]     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
17:35:45,977 ERROR [STDERR]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
17:35:45,977 ERROR [STDERR]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
17:35:45,977 ERROR [STDERR]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
17:35:45,977 ERROR [STDERR]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
17:35:45,977 ERROR [STDERR]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
17:35:45,977 ERROR [STDERR]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
17:35:45,977 ERROR [STDERR]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
17:35:45,977 ERROR [STDERR]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
17:35:45,977 ERROR [STDERR]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
17:35:45,982 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:595)
17:35:46,073 ERROR [ContainerBase] Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
        at org.apache.jsp.app.index_jsp._jspService(index_jsp.java:159)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:595)