Management.esb on OracleDB

[kadlecp]

Hello,

I've tried to connect ESB Management component with oracle. I've checked out JBoss-4.2.1.GA-CP2-IR1 from SVN. Before I run "ant dist" I've changed db property to oracle according to MANAGEMENT_README.TXT file. I've changed management-ds.xml according to my settings. Then ant deploy.....

After starting jboss, I can see following exceptions

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.hql.QueryLoader.list(QueryLoader.java:378)
 at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
 at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
 at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
 at org.jboss.soa.esb.monitoring.server.OperationsFiler.getOperation(OperationsFiler.java:80)
 at org.jboss.soa.esb.monitoring.server.OperationsFiler.insertOperations(OperationsFiler.java:116)
 at org.jboss.soa.esb.monitoring.server.OperationsFiler.persistData(OperationsFiler.java:222)
 at org.jboss.soa.esb.monitoring.server.FilerAction.fileMessage(FilerAction.java:70)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.soa.esb.listeners.message.ActionProcessorMethodInfo.processMethods(ActionProcessorMethodInfo.java:102)
 at org.jboss.soa.esb.listeners.message.OverriddenActionLifecycleProcessor.process(OverriddenActionLifecycleProcessor.java:74)
 at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:316)
 at org.jboss.soa.esb.listeners.message.MessageAwareListener$1.run(MessageAwareListener.java:303)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-00904: "JMXOPERATI0_"."ATTRIBUTE": invalid identifier
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPr
 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleSt
 at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4C
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePr
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute
 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.
 at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
 at org.hibernate.loader.Loader.doQuery(Loader.java:674)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollectio
 at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 22 more

and

15:23:11,856 ERROR [DataFiler]
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
 at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
 at org.jboss.soa.esb.monitoring.server.DataFiler.insertStatistics(DataFiler.java:194)
 at org.jboss.soa.esb.monitoring.server.DataFiler.persistData(DataFiler.java:230)
 at org.jboss.soa.esb.monitoring.server.FilerAction.fileMessage(FilerAction.java:70)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.soa.esb.listeners.message.ActionProcessorMethodInfo.processMethods(ActionProcessorMethodInfo.java:102)
 at org.jboss.soa.esb.listeners.message.OverriddenActionLifecycleProcessor.process(OverriddenActionLifecycleProcessor.java:74)
 at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:316)
 at org.jboss.soa.esb.listeners.message.MessageAwareListener$1.run(MessageAwareListener.java:303)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "JBOSS01"."JMXDATA"."TEXTVALUE" (actual: 379, maximum: 255)

 at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
 at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
 at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
 ... 21 more

I am able to solve second exception, but the I don't know what to do with the first one.

I have tried older releases of esb with the same result.

Thank you for help.
Pavel

[tcunning]

Pavel, is there a reason you are using IR1 rather than a more recent version?

My suggestion would be to up the size of the JMXDATA.TEXTVALUE field to 2000 (from 255). There's a bug tracking this issue (JBESB-1621) and I've added this post as a reference.

[kadlecp]

What is the most recent version now? I thought it is JBESB_4_2_1_GA_CP2_IR1 from SVN.

Pavel

[mleino]

Pavel, I've run across the first issue as well. (See http://jira.jboss.org/jira/browse/JBESB-1605) I've fixed this in our environment by changing the configuration in console/management/src/main/resources/oracle/monitoring-mappings.hbm.xml.

There is also another issue (JBESB-1604) regarding the second issue.

Hopefully this helps you.
Mika

[bcarothers]

I have just attached proposed fixes for both JIRA issues to the respective issues. Please let me know if you run into any problems with them (or not).

Thanks

[kadlecp]

Hello,

Now it works with the patch from http://jira.jboss.org/jira/browse/JBESB-1605 and increasing the size of the JMXDATA.TEXTVALUE field to 2000 (from 255).

Thanks for help!
Pavel