10:32:54,936 FIN | [SQL]
select
deployment0_.DBID_ as
DBID1_0_0_,
deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_,
deployment0_.STATE_ as
STATE4_0_0_
from
JBPM4_DEPLOYMENT deployment0_
where
deployment0_.DBID_=?
10:32:54,936 FST | [LongType] binding
'1' to parameter: 1
10:32:54,941 FST | [TextType] returning 'uploadProcess'
as column: NAME2_0_0_
10:32:54,941 FST | [LongType] returning '1294327812018'
as column: TIMESTAMP3_0_0_
10:32:54,941 FST | [StringType] returning 'active'
as column: STATE4_0_0_
10:32:54,945 FIN | [SQL]
select
resources0_.DEPLOYMENT_ as DEPLOYMENT4_0_1_,
resources0_.DBID_ as
DBID1_1_,
resources0_.NAME_ as NAME5_1_,
resources0_.DBID_
as DBID1_5_0_,
resources0_.DBVERSION_ as DBVERSION2_5_0_,
resources0_.BLOB_VALUE_ as BLOB3_5_0_
from
JBPM4_LOB
resources0_
where
resources0_.DEPLOYMENT_=?
10:32:54,945
FST | [LongType] binding '1' to parameter: 1
10:32:54,948 FST | [LongType]
returning '2' as column: DBID1_5_0_
10:32:54,949 FST | [IntegerType]
returning '0' as column: DBVERSION2_5_0_
10:32:54,958 FST | [LongType]
returning '1' as column: DEPLOYMENT4_0_1_
10:32:54,958 FST | [LongType]
returning '2' as column: DBID1_1_
10:32:54,981 INF | [TextType] could not
read column value from result set: NAME5_1_; 流已被關閉
10:32:54,985 WRN |
[JDBCExceptionReporter] SQL Error: 17027, SQLState: null
10:32:54,985 SEV |
[JDBCExceptionReporter] 流已被關閉
### EXCEPTION
###########################################
10:32:54,985 INF |
[DefaultCommandService] exception while executing command
org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl@59a331
org.hibernate.exception.GenericJDBCException:
could not initialize a collection:
[org.jbpm.pvm.internal.repository.DeploymentImpl.resources#1]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.loader.Loader.loadCollection(Loader.java:2089)
at
org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62)
at
org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:628)
at
org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
at
org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1853)
at
org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:369)
at
org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111)
at
org.hibernate.collection.PersistentMap.keySet(PersistentMap.java:249)
at
org.jbpm.pvm.internal.repository.DeploymentImpl.getResourceNames(DeploymentImpl.java:166)
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:597)
at
org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:198)
at
org.jbpm.pvm.internal.repository.DeploymentImpl_$$_javassist_43.getResourceNames(DeploymentImpl_$$_javassist_43.java)
at
org.jbpm.pvm.internal.repository.ProcessDeployer.deploy(ProcessDeployer.java:59)
at
org.jbpm.pvm.internal.repository.DeployerManager.deploy(DeployerManager.java:46)
at
org.jbpm.pvm.internal.repository.RepositorySessionImpl.getObject(RepositorySessionImpl.java:130)
at
org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.getProcessDefinition(ProcessDefinitionQueryImpl.java:92)
at
org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:72)
at
org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:83)
at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at
org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
at
org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at
org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at
org.jbpm.pvm.internal.query.AbstractQuery.untypedUniqueResult(AbstractQuery.java:74)
at
org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.uniqueResult(ProcessDefinitionQueryImpl.java:161)
at
com.smapp.service.workflow.business.core.impl.CoreServiceWorkflowImpl.listProcess(CoreServiceWorkflowImpl.java:823)
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:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at
$Proxy5.listProcess(Unknown Source)
at
com.smapp.service.workflow.core.CoreServiceWorkflowProcessTest.testGetActiveRectangle(CoreServiceWorkflowProcessTest.java:94)
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:597)
at
junit.framework.TestCase.runTest(TestCase.java:164)
at
junit.framework.TestCase.runBare(TestCase.java:130)
at
junit.framework.TestResult$1.protect(TestResult.java:106)
at
junit.framework.TestResult.runProtected(TestResult.java:124)
at
junit.framework.TestResult.run(TestResult.java:109)
at
junit.framework.TestCase.run(TestCase.java:120)
at
junit.framework.TestSuite.runTest(TestSuite.java:230)
at
junit.framework.TestSuite.run(TestSuite.java:225)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused
by: java.sql.SQLException: 流已被關閉
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at
oracle.jdbc.driver.LongAccessor.getCharacterStream(LongAccessor.java:340)
at
oracle.jdbc.driver.OracleResultSetImpl.getCharacterStream(OracleResultSetImpl.java:1519)
at
oracle.jdbc.driver.OracleResultSet.getCharacterStream(OracleResultSet.java:2007)
at
org.hibernate.type.AbstractLongStringType.get(AbstractLongStringType.java:54)
at
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:186)
at
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:175)
at
org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:769)
at
org.hibernate.collection.PersistentMap.readFrom(PersistentMap.java:281)
at
org.hibernate.loader.Loader.readCollectionElement(Loader.java:1072)
at
org.hibernate.loader.Loader.readCollectionElements(Loader.java:690)
at
org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:630)
at
org.hibernate.loader.Loader.doQuery(Loader.java:745)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at
org.hibernate.loader.Loader.loadCollection(Loader.java:2082)
... 62
more
### EXCEPTION
###########################################
10:32:54,989 WRN | [LoadContexts]
fail-safe cleanup (collections) :
org.hibernate.engine.loading.CollectionLoadContext@17ae020<rs=oracle.jdbc.driver.OracleResultSetImpl@1c2ab6c>
10:32:54,989
WRN | [CollectionLoadContext] On CollectionLoadContext#cleanup,
localLoadingCollectionKeys contained [1] entries
jbpm4_lob 表NAME_ HIBERNATE類型為TEXT ,Hibernate自動創建的類型為long。導致10:32:54,981 INF | [TextType] could not read column value from result set: NAME5_1_; 流已被關閉
確保生成的字段類型為clob