Hello EveryOne ,
i am trying to change database connections from H2 database to MSSQL
i did changes
/flowable-idm/build/classes/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-idm/src/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-admin/src/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-admin/build/classes/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-modeler/src/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-modeler/build/classes/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-rest/src/db.properties
/flowable-rest/build/classes/db.properties
/flowable-task/src/META-INF/flowable-ui-app/flowable-ui-app.properties
/flowable-task/build/classes/META-INF/flowable-ui-app/flowable-ui-app.properties
In thsese all the files from H2 data base properties to MSSQL properties
#datasource.driver=org.h2.Driver
#datasource.url=jdbc:h2:mem:flowable;DB_CLOSE_DELAY=-1 to datasource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.url=jdbc:sqlserver://************;databaseName=flowable
with Their respective databases like for the flowableidm /flowableidm database
after that while running the flowableidm. I am getting ERRORS like this please help me with that
Error::
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-HelperThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2044)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1773)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1081)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:616)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-HelperThread-#2,5,main]
java.lang.Thread.sleep(Native Method)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2044)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1773)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1081)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:616)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
01:55:25,962 [C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-AdminTaskTimer] WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@43523b12 – APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
01:55:25,966 [C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-AdminTaskTimer] WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@43523b12 – APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6648997b
on thread: C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-HelperThread-#0
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4ee7d1b3
on thread: C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-HelperThread-#1
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6739c0c1
on thread: C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-HelperThread-#2
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@58cd0629
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7aeccf0a
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@a76f3ad
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@236005ea
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@13acb3e1
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@fa4ba01
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@32f2dbc3
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->1hge3299s1p46wdm14c835|79adc343]-HelperThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.microsoft.sqlserver.jdbc.SQLServerCo