I havent used JDBC but its showing error as JDBC connectivity issue

0
An error occurred while initializing the Runtime: Error on initializing database connection. -------- com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: Error on initializing database connection.     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:350) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Error on initializing database connection.     at com.mendix.connectionbus.ConnectionBusInitializer.throwDefault$1(ConnectionBusInitializer.scala:58) Caused by: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@5d1d073a[file =C:\Users\ADMIN\Documents\Mendix\form-main\deployment\data\database\hsqldb\default\default.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-10-08 09:10:32 heartbeat - read: -7107 ms.     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:83)     at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)     at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:874)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:417)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:346)     at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49)     at com.mendix.connectionbus.ConnectionBusInitializer.$anonfun$createConnection$1(ConnectionBusInitializer.scala:52)     at scala.util.Try$.apply(Try.scala:213)     at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:60)     at com.mendix.connectionbus.ConnectionBusInitializer.createConnection(ConnectionBusInitializer.scala:52)     at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:42)     at com.mendix.connectionbus.ConnectionBusImpl.initialize(ConnectionBusImpl.java:361)     at com.mendix.basis.impl.MxRuntimeImplBase.initializeConnectionBus(MxRuntimeImplBase.java:502)     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:316)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:48)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:30)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)     at org.eclipse.jetty.server.Server.handle(Server.java:501)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:272)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)     at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)     at java.base/java.lang.Thread.run(Thread.java:834) Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@5d1d073a[file =C:\Users\ADMIN\Documents\Mendix\form-main\deployment\data\database\hsqldb\default\default.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-10-08 09:10:32 heartbeat - read: -7107 ms.     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)     at org.hsqldb.persist.Logger.acquireLock(Unknown Source)     at org.hsqldb.persist.Logger.open(Unknown Source)     at org.hsqldb.Database.reopen(Unknown Source)     at org.hsqldb.Database.open(Unknown Source)     at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)     at org.hsqldb.DatabaseManager.newSession(Unknown Source)     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:83)     at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355)     at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:874)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:417)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:346)     at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49)     at com.mendix.connectionbus.ConnectionBusInitializer.$anonfun$createConnection$1(ConnectionBusInitializer.scala:52)     at scala.util.Try$.apply(Try.scala:213)     at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:60)     at com.mendix.connectionbus.ConnectionBusInitializer.createConnection(ConnectionBusInitializer.scala:52)     at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:42)     at com.mendix.connectionbus.ConnectionBusImpl.initialize(ConnectionBusImpl.java:361)     at com.mendix.basis.impl.MxRuntimeImplBase.initializeConnectionBus(MxRuntimeImplBase.java:502)     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:316)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:48)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:30)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)     at org.eclipse.jetty.server.Server.handle(Server.java:501)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:272)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)     at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)     at java.base/java.lang.Thread.run(Thread.java:834)  
asked
1 answers
1

Try to Delete File C:\Users\ADMIN\Documents\Mendix\form-main\deployment\data\database\hsqldb\default\default.lck and restart the modeler and application.

answered