[jboss-user] [JBoss jBPM] - Help about Jbpm deployed to Oracle 10g

[feigme]

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!

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4115454#4115454

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4115454