kie workbench sql server database issue

[jagan reddy]

Hi,

i am using kie workbench6.5.0.Final ki server6.5.0.Final
resource.ds1.className=bitronix.tm.resource.jdbc.lrc.LrcXADataSource
resource.ds1.uniqueName=jdbc/jbpmDS
resource.ds1.minPoolSize=0
resource.ds1.maxPoolSize=10
resource.ds1.driverProperties.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
resource.ds1.driverProperties.url=jdbc:sqlserver://localhost:port number;databaseName=jbpm;
resource.ds1.driverProperties.user=sa
resource.ds1.driverProperties.password=Qruize@321
resource.ds1.allowLocalTransactions=true



Mar 07, 2018 1:49:56 PM bitronix.tm.recovery.Recoverer recoverAllResources
WARNING: error running recovery on resource 'jdbc/jbpmDS', resource marked as failed (background recoverer will retry recovery)
bitronix.tm.recovery.RecoveryException: cannot start recovery on a PoolingDataSource containing an XAPool of resource jdbc/jbpmDS with 2 connection(s) (0 still available)
    at bitronix.tm.resource.jdbc.PoolingDataSource.startRecovery(PoolingDataSource.java:288)
    at bitronix.tm.recovery.Recoverer.recover(Recoverer.java:258)
    at bitronix.tm.recovery.Recoverer.recoverAllResources(Recoverer.java:226)
    at bitronix.tm.recovery.Recoverer.run(Recoverer.java:142)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: unable to connect to non-XA resource com.microsoft.sqlserver.jdbc.SQLServerDriver
    at bitronix.tm.resource.jdbc.lrc.LrcXADataSource.getXAConnection(LrcXADataSource.java:108)
    at bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(PoolingDataSource.java:341)
    at bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:283)
    at bitronix.tm.resource.common.XAPool.grow(XAPool.java:391)
    at bitronix.tm.resource.common.XAPool.getInPool(XAPool.java:371)
    at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:123)
    at bitronix.tm.resource.jdbc.PoolingDataSource.startRecovery(PoolingDataSource.java:284)
    ... 4 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1339)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1586)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.Prelogin(SQLServerConnection.java:1117)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1038)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)


thanks,
Jagan