Tag Archives: gbase8s

[Solved] gbase8s Error: Caused by: java.sql.SQLException: Transactions not supported

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.