Hosting bonita database in SQL Server

pet's picture
Post submitted by pet Wed, 09/11/2013 - 15:44

Hi everyone,



I've downloaded "Bonita BPM Tomcat bundle" and followed instructions from

http://documentation.bonitasoft.com/tomcat-bundle/#verify

to host bonita database in SQL Server.



When I start the bundle by running startup.bat I get errors - see the log attached:

What could I do to make it work?

Thank you.



Sep 11, 2013 4:12:14 PM org.bonitasoft.console.common.server.servlet.PlatformTenantListener contextInitialized

SEVERE: Error while starting the platform and tenant

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:140)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: .Caused By:(unable to initialize platform structure)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:233)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

... 36 more

Caused by: .Caused By:(Unable to execute command of file /org/bonitasoft/engine/dependency-platform/model/impl/db/sqlserver-initTables.sql content:

INSERT INTO sequence VALUES (-1, 2, 1))

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:708)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

... 37 more

Caused by: .Caused By:(Cannot open connection)

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.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:698)

... 42 more

Caused by: .Caused By:(unable to get a connection from pool of a PoolingDataSource containing an XAPool of resource jdbc/bonitaDSXA with 1 connection(s) (1 still available) -failed-)

at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:262)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

... 49 more

Caused by: .Caused By:(incremental recovery failed when trying to acquire a connection from failed resource 'jdbc/bonitaDSXA')

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:103)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:91)

at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:258)

... 51 more

Caused by: .Caused By:(failed recovering resource jdbc/bonitaDSXA)

at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:100)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:100)

... 53 more

Caused by: .Caused By:(The function RECOVER: failed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ")

at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:550)

at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:728)

at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:103)

at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:61)

at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:63)

... 54 more

org.bonitasoft.engine.exception.CreationException: Platform Creation failed.

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:140)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at ══════════════════════════.()

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:233)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(unable to initialize platform structure)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:708)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(Unable to execute command of file /org/bonitasoft/engine/dependency-platform/model/impl/db/sqlserver-initTables.sql content:

INSERT INTO sequence VALUES (-1, 2, 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.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:698)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(Cannot open connection)

at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:262)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:698)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(unable to get a connection from pool of a PoolingDataSource containing an XAPool of resource jdbc/bonitaDSXA with 1 connection(s) (1 still available) -failed-)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:103)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:91)

at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:258)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:698)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(incremental recovery failed when trying to acquire a connection from failed resource 'jdbc/bonitaDSXA')

at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:100)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:100)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:91)

at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:258)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:698)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(failed recovering resource jdbc/bonitaDSXA)

at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:550)

at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:728)

at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:103)

at bitronix.tm.recovery.RecoveryHelper.recover(RecoveryHelper.java:61)

at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:63)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:100)

at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:91)

at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:258)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughHibernate(AbstractHibernatePersistenceService.java:698)

at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:690)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:184)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:160)

at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.initializeStructure(AbstractDBPersistenceService.java:154)

at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:231)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)

at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:177)

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 org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:206)

at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:87)

at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)

at com.sun.proxy.$Proxy1.createAndInitializePlatform(Unknown Source)

at org.bonitasoft.console.common.server.servlet.PlatformTenantManager.createPlatform(PlatformTenantManager.java:83)

at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:58)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

at .Caused By:(The function RECOVER: failed. The status is: -3. Error: "
SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***")

Comments

Submitted by ttoine Tue, 09/17/2013 - 18:53

Hello,



Two questions for you:

- Did you started once the Bundle with the default H2 database? Because you will have to initiate it again, and this is explained in the same doc page

- Did you set the jdbc driver? For without the JDBC driver, Bonita Engine can not use the database, and so can not create tables.

Submitted by domenico.giordano Sat, 10/12/2013 - 13:41

Hi Pet

I had the problem trrying to install Bonita on MS Sql Server 2008 R2.

I solved the problem using JTDS driver.

I am going to briefly explain the steps that aren't in accord woth the documentation:



1. download the driver http://sourceforge.net/projects/jtds/files/

2. Copy \jtds\x86\XA\JtdsXA.dll in \MSSQL\Binn

3. Edit the file \jtds\x86\XA\instjtds.sql and run it into SQL Studio (we removed the line “dump trans” because there is no compatibility with SQL Server 2008). After this we had a new stored procedure under master/Programmability/Extended Stored Procedures. There is no need to run the SQL script reported under “Apply role to J2EE APPserver JDBC User” chapter into documentation.

4. alter database to avoid deadloack according with documentation

5. DTC configuration: as reported on doc

6. Data Source configuration:

JTA Bitronix:

resource.ds1.className=net.sourceforge.jtds.jdbcx.JtdsDataSource

resource.ds1.driverProperties.user=

resource.ds1.driverProperties.password=

resource.ds1.driverProperties.serverName=

resource.ds1.driverProperties.portNumber=

resource.ds1.driverProperties.databaseName=

note that you can use URL properties in jtds XA driver



No JTA (bonita.xml)


auth="Container"

type="javax.sql.DataSource"

maxActive="17"

minIdle="5"

maxWait="10000"

initialSize="3"

validationQuery="SELECT 1"

validationInterval="30000"

removeAbandoned="true"

logAbandoned="true"

username=""

password=""

driverClassName="net.sourceforge.jtds.jdbc.Driver"

url="jdbc:jtds:sqlserver://:/"/>



Copy jtds-1.3.1.jar file in /lib folder and start Tomcat



After this steps everything works fine in my enviroment.

Let me know.

Submitted by adityakhedikar Thu, 05/29/2014 - 08:46

have you deleted H2 listner from server.xml and jar files from /lib?