Management.esb on OracleDB
kadlecp Mar 30, 2008 9:49 AMHello,
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