Bug 777843 (SOA-370)

Summary: JBossESB Management Console fails when configure with MySQL
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Jehudi Castro Sierra <jcastro>
Component: ToolingAssignee: Martin Vecera <mvecera>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 4.2 CR1CC: mvecera
Target Milestone: ---   
Target Release: 4.2 CR3   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-370
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
JBoss SOA Platform ESB Standalone Server - Version 4.2.0.CR1 MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.7
Last Closed: 2008-02-11 19:23:43 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:
Bug Depends On: 778130    
Bug Blocks:    
Attachments:
Description Flags
server.log.tar.gz
none
server.log.tar.gz none

Description Jehudi Castro Sierra 2008-01-27 17:15:20 UTC 
Date of First Response: 2008-01-28 05:04:39
project_key: SOA

JBossESB Management Console fails when configure with MySQL.

To reproduce it:

In the management-esb directory there is a db.properties file. In order to change the database from hsqldb to MySQL, edit this file and change the db property to "mysql". Add the JDBC driver into the server/<instance>/lib directory.
Create the database "statistics" before deploying.
% cd tools/console/management-esb
% ant deploy

When get into the console (http://localhost:8080/jbossesb) this exception is thrown


18:07:38,063 WARN  [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:07:38,063 ERROR [JDBCExceptionReporter] Table 'statistics.JMXAttribute' doesn't exist
18:07:38,068 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2223)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
        at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
        at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
        at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
        at org.jboss.soa.esb.monitoring.server.StatisticsHelper.getObjectNamesForServer(StatisticsHelper.java:220)
        at org.apache.jsp.app.index_jsp._jspService(index_jsp.java:110)
        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: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'statistics.JMXAttribute' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        ... 33 more
Comment 1 Mark Little 2008-01-28 10:04:39 UTC 
PLEASE ATTACH THE LOG!!

Thanks :-)
Comment 2 Jehudi Castro Sierra 2008-01-28 11:30:14 UTC 
Attachment: Added: server.log.tar.gz
Comment 3 Jehudi Castro Sierra 2008-01-28 11:34:51 UTC 
The console was already installed, so I redeployed it following this instructions: https://engineering.redhat.com/docbot/en-US/JBoss_SOA_Platform/4.2/html/SOA_ESB_Monitoring_Guide/ch01s01.html
and then I started up the server.
Comment 4 tcunning 2008-01-29 00:56:19 UTC 
Link: Added: This issue related JBESB-1523
Comment 5 tcunning 2008-01-29 01:01:38 UTC 
Add a dependency on the jbossesbmanagement-service.xml MBean.      

This change has been committed to CP and was added to SOA build by Mike Brock - it is in a different file because of SOA build authorization/authentication changes.


Copying his email :

From Mike Brock :

added.


On 28-Jan-08, at 3:39 PM, Tom Cunningham wrote:

> Mike,
>
> I'm having trouble finding the jboss-web.xml that ends up as management.esb/jbossesb.war/WEB-INF/jboss-web.xml.      I've poked around the SOA branch and can't find it.     Is it in another module or something?     Any chance you can add the line below?
>
> Thanks,
>
> Tom
Comment 6 Len DiMaggio 2008-01-30 16:53:58 UTC 
Link: Added: This issue is a dependency of JBQA-1090
Comment 7 Jehudi Castro Sierra 2008-01-31 13:26:07 UTC 
Link: Added: This issue related JBQA-1090
Comment 8 Jehudi Castro Sierra 2008-02-05 09:37:03 UTC 
the problem is happening again on JBoss SOA Platform, ESB Standalone Server - Version 4.2.0.CR2
Comment 9 Jehudi Castro Sierra 2008-02-05 09:38:41 UTC 
Attaching the logs for the error in CR2
Comment 10 Jehudi Castro Sierra 2008-02-05 09:38:41 UTC 
Attachment: Added: server.log.tar.gz
Comment 11 tcunning 2008-02-05 13:41:54 UTC 
Jehudi, are you rebuilding and deploying the management.esb from the tools/console directory of CR2, or copying an old one in?     I just tried this with standalone, and cannot reproduce.
Comment 12 tcunning 2008-02-05 14:08:07 UTC 
Just to be clear the qa db change stuff probably doesn't contain the changes we need here.
Comment 13 tcunning 2008-02-05 14:50:15 UTC 
Jehudi is doing the right steps and still seeing this - will take a look tonight.
Comment 14 Kevin Conner 2008-02-07 14:36:11 UTC 
Link: Added: This issue depends JBESB-1541
Comment 15 Kevin Conner 2008-02-07 14:42:54 UTC 
Fixed in ESB project, will be in next platform merge.
Comment 16 Jehudi Castro Sierra 2008-02-11 19:23:43 UTC 
verified in CR3