[jboss-user] [JBoss jBPM] - Problems jBPM with SQL Sqrver 2000

[leticia.labanda]

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
  | 
  | 

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

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