[esb-issues] [JBoss JIRA] Closed: (JBESB-2467) Management console uses wrong approache to access database.

Management console uses wrong approache to access database. ----------------------------------------------------------- Key: JBESB-2467 URL: https://jira.jboss.org/jira/browse/JBESB-2467 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Management, Tooling Affects Versions: 4.4 CP1 Environment: MySQL or PostgreSQL Reporter: Pavel Macik Priority: Blocker org.jboss.soa.esb.monitoring.server.OperationsHelper class is using org.hibernate.SQLQuery to obtain data from DB, which doesn't work on case-sensitive DBs because hibernate mapping is not applied in that case. This exception is thrown when the button 'Collect Operation' in the JBoss ESB Management Console is clicked: 10:02:44,394 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 10:02:44,394 ERROR [JDBCExceptionReporter] Table 'soaesb1_as.JMXOperation' doesn't exist 10:02:44,395 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.OperationsHelper.getObjectNamesForServer(OperationsHelper.java:66) at org.apache.jsp.app.operations_jsp._jspService(operations_jsp.java:109) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) ...