[JBoss JIRA] Created: (JBESB-2467) Management console uses wrong approache to access database.
by Pavel Macik (JIRA)
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
17 years, 1 month
[JBoss JIRA] Created: (JBESB-2185) Patch for [jUDDI retains invalid EPRs]
by Joakim Sandström (JIRA)
Patch for [jUDDI retains invalid EPRs]
--------------------------------------
Key: JBESB-2185
URL: https://jira.jboss.org/jira/browse/JBESB-2185
Project: JBoss ESB
Issue Type: Sub-task
Security Level: Public (Everyone can see)
Affects Versions: 4.4
Reporter: Joakim Sandström
Patch for 'jUDDI retains invalid EPRs' issue (JBESB-866).
Patch:
The RegistryUtil.register method unregisters matching EPR's using unregister(category, name, epr) before (re)registering the same EPR.
Not included in the patch:
Registry.unRegisterEPR(serviceCategoryName, serviceName, epr) could return a boolean true/false and not raise a ServiceNotFoundException if the service isn't found - to avoid unneccesary stack traces in the log.
--
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
17 years, 1 month