3 Replies Latest reply on Dec 27, 2007 5:14 AM by Ronald van Kuijk

    Help about Jbpm deployed to Oracle 10g

    guo hui Newbie

      It's in good condition when I deploy Jbpm to Oracle 9i,but when I deploy to Oracle 10g, some problem is happen

      my os: windows 2003 64bit
      jbpm version: jbpm 3.1.4
      hibernate version: 3.0
      datebase: oracle 10g

      hibernate.cfg.xml is used jbpm default configuration

      ojdbc14.jar is also newest

      Manifest-Version: 1.0
      Specification-Title: Oracle JDBC driver classes for use with JDK14
      Sealed: true
      Created-By: 1.4.2_08 (Sun Microsystems Inc.)
      Implementation-Title: ojdbc14.jar
      Specification-Vendor: Oracle Corporation
      Specification-Version: Oracle JDBC Driver version - "10.2.0.3.0"
      Implementation-Version: Oracle JDBC Driver version - "10.2.0.3.0"
      Implementation-Vendor: Oracle Corporation
      Implementation-Time: Fri Sep 29 09:43:24 2006
      


      this's my run process , error log is this:
      2007-12-26 11:06:16,899 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 17002, SQLState: null
      2007-12-26 11:06:16,899 ERROR [org.hibernate.util.JDBCExceptionReporter] - IO ²§±`: Connection reset
      2007-12-26 11:06:16,915 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 17002, SQLState: null
      2007-12-26 11:06:16,915 ERROR [org.hibernate.util.JDBCExceptionReporter] - IO ²§±`: Connection reset
      2007-12-26 11:06:16,915 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] - Could not synchronize database state with session
      org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
      at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2048)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
      at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:353)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
      at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:169)
      at org.jbpm.svc.Services.close(Services.java:211)
      at org.jbpm.JbpmContext.close(JbpmContext.java:139)
      at org.jbpm.web.JbpmContextFilter.doFilter(JbpmContextFilter.java:85)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
      at java.lang.Thread.run(Unknown Source)
      Caused by: java.sql.BatchUpdateException: IO ²§±`: Connection reset
      at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)
      at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
      ... 34 more


      thinks for help!