1 Reply Latest reply on Feb 1, 2007 12:42 PM by Leticia Labanda

    Problems jBPM with SQL Sqrver 2000

    Leticia Labanda Newbie

      Hi.

      I'm trying to configure jBPM to work with Ms SQL Server 2000 database. When I try to run websale example I get the following error. May someone help me?

      org.hibernate.exception.JDBCConnectionException: could not load an entity: [org.jbpm.graph.exe.Token#1]
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:72)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.Loader.loadEntity(Loader.java:1799)
       at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:93)
       at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:81)
       at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)
       at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
       at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
       at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
       at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:82)
       at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:869)
       at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:828)
       at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:62)
       at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:98)
       at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:158)
       at org.jbpm.graph.exe.Token$$EnhancerByCGLIB$$65b761f9.hashCode(<generated>)
       at java.util.HashMap.hash(Unknown Source)
       at java.util.HashMap.put(Unknown Source)
       at org.hibernate.collection.PersistentMap.readFrom(PersistentMap.java:223)
       at org.hibernate.loader.Loader.readCollectionElement(Loader.java:994)
       at org.hibernate.loader.Loader.readCollectionElements(Loader.java:635)
       at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
       at org.hibernate.loader.Loader.doQuery(Loader.java:689)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
       at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
       at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:71)
       at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)
       at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
       at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1627)
       at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
       at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
       at org.hibernate.collection.AbstractPersistentCollection.readIndexExistence(AbstractPersistentCollection.java:125)
       at org.hibernate.collection.PersistentMap.containsKey(PersistentMap.java:109)
       at org.jbpm.context.exe.ContextInstance.getTokenVariableMap(ContextInstance.java:317)
       at org.jbpm.context.exe.ContextInstance.getVariable(ContextInstance.java:131)
       at org.jbpm.context.exe.ContextInstance.getVariable(ContextInstance.java:121)
       at org.jbpm.websale.WebsaleTest.testUnwritableVariableException(WebsaleTest.java:173)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at junit.framework.TestCase.runTest(TestCase.java:154)
       at junit.framework.TestCase.runBare(TestCase.java:127)
       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:118)
       at junit.framework.TestSuite.runTest(TestSuite.java:208)
       at junit.framework.TestSuite.run(TestSuite.java:203)
       at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
       at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
       at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
      Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
       at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
       at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
       at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
       at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
       at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
       at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
       at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
       at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.Loader.doQuery(Loader.java:661)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
       at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
       ... 49 more