Error Messages:
ERROR [Thread-58] 2021-12-09 15:45:22 (AcquireTimerJobsRunnable.java:85) exception during timer job acquisition: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Transactions not supported org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Transactions not supported at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:304) ~[spring-jdbc-5.1.18.RELEASE.jar:5.1.18.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378) ~[spring-tx-5.1.18.RELEASE.jar:5.1.18.RELEASE] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137) ~[spring-tx-5.1.18.RELEASE.jar:5.1.18.RELEASE] at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) ~[activiti-spring-5.22.0.jar:5.22.0] at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) ~[activiti-engine-5.22.0-hussar-1.jar:5.22.0] at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) ~[activiti-engine-5.22.0-hussar-1.jar:5.22.0] at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35) ~[activiti-engine-5.22.0-hussar-1.jar:5.22.0] at org.activiti.engine.impl.asyncexecutor.AcquireTimerJobsRunnable.run(AcquireTimerJobsRunnable.java:52) [activiti-engine-5.22.0-hussar-1.jar:5.22.0] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181] Caused by: java.sql.SQLException: Transactions not supported at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408) ~[gbase8s-jdbc-2.0.jar:?] at com.gbasedbt.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:2274) ~[gbase8s-jdbc-2.0.jar:?] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:738) ~[druid-1.99.2.jar:1.99.2] at com.alibaba.druid.filter.logging.LogFilter.connection_setAutoCommit(LogFilter.java:445) ~[druid-1.99.2.jar:1.99.2] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:733) ~[druid-1.99.2.jar:1.99.2] at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:986) ~[druid-1.99.2.jar:1.99.2] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:733) ~[druid-1.99.2.jar:1.99.2] at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:429) ~[druid-1.99.2.jar:1.99.2] at com.alibaba.druid.pool.DruidPooledConnection.setAutoCommit(DruidPooledConnection.java:713) ~[druid-1.99.2.jar:1.99.2] at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:282) ~[spring-jdbc-5.1.18.RELEASE.jar:5.1.18.RELEASE] ... 8 more ERROR [Thread-59] 2021-12-09 15:45:22 (AcquireAsyncJobsDueRunnable.java:85) exception during async job acquisition: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Transactions not supported
Cause.
When the database is imported, the logging mode is not set, so transactions are not supported
Solution.
Execute the following command
Modify to unbuffer logging mode
ontape -s -L 0 -t /dev/null -U database name
[gbasedbt@localhost bin]$ ontape -s -L 0 -t /dev/null -U test
Your evaluation license will expire on 2022-06-04 00:00:00
Archive to tape device '/dev/null' is complete.