5 Replies Latest reply on Apr 2, 2008 6:25 AM by Pavel Kadlec

    Management.esb on OracleDB

    Pavel Kadlec Novice

      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