| Summary: | Management console doesn't work with MySQL | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 4 | Reporter: | Jaroslaw Kijanowski <kijanowski> |
| Component: | Tooling | Assignee: | Jaroslaw Kijanowski <kijanowski> |
| Status: | CLOSED DUPLICATE | QA Contact: | |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 4.2 CP02 | ||
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| URL: | http://jira.jboss.org/jira/browse/SOA-612 | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: |
mysql 5.0.27-standard
soa platform CP02_RC4
|
|
| Last Closed: | 2008-06-27 13:41:41 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
Looks like I'm using the wrong mapping file... works fine (obviously) with correct mapping file ... First I have build the management console for oracle, so the oracle mapping file has been picked up and packaged into management/build/management-server.jar Then I did the same for mysql, but the management-server.jar file hasn't been modified, hence the management.esb archive picked up the old jar with the wrong mapping file. See linked issue and my comments why this is caused Link: Added: This issue is related to SOA-512 The linked issue was documented. Link: Added: This issue is related to SOA-860 |
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)