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

[Mark Little (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBESB-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Little closed JBESB-2467.
------------------------------

    Resolution: Won't Fix


We are moving to using the JON embedded console so we are reducing the work done on the old console as a result.

> 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)
> ...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira