咨询 jfinal 连接oceanbase(mysql 模式)不支持事务处理

 jfinal 项目连接 oceanbase 数据(mysql 模式),使用 succeed = Db.tx(new IAtom() { } 事务处理,报com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Not supported feature or function。详情如下:

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Not supported feature or function
at com.jfinal.plugin.activerecord.DbPro.save(DbPro.java:588)
at com.jfinal.plugin.activerecord.DbPro.save(DbPro.java:598)
at com.jfinal.plugin.activerecord.Db.save(Db.java:390)
at com.controller.CloudSail.CloudSailController$2.run(SailController.java:219)
     at com.jfinal.plugin.activerecord.DbPro.tx(DbPro.java:711)
at com.jfinal.plugin.activerecord.DbPro.tx(DbPro.java:748)
at com.jfinal.plugin.activerecord.Db.tx(Db.java:460)
at com.controller.Sail.SailController.setPushCustomerList(SailController.java:216)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.jfinal.aop.Invocation.invoke(Invocation.java:73)
at com.intercepter.SessionTimeOutIntercepter.intercept(SessionTimeOutIntercepter.java:32)
at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
at com.intercepter.SessionCrossInterceptor.intercept(SessionCrossInterceptor.java:30)
at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
at com.jfinal.core.ActionHandler.handle(ActionHandler.java:74)
at com.common.XssHandler.handle(XssHandler.java:18)
at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Not supported feature or function
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2136)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2070)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5187)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2055)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3253)
at com.alibaba.druid.wall.WallFilter.preparedStatement_executeUpdate(WallFilter.java:661)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3251)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1092)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3251)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:194)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
at com.jfinal.plugin.activerecord.DbPro.save(DbPro.java:552)
at com.jfinal.plugin.activerecord.DbPro.save(DbPro.java:586)


评论区

JFinal

2022-11-15 00:07

可能是对 oceanbase 不兼容,升级一下 JDBC 驱动试一下

李白一刀

2022-11-15 11:14

@JFinal 请问老师, jfinal 历史版本去哪里可以下载,比如我想下载 3.6 版本

杜福忠

2022-11-16 09:24

@李白一刀
https://developer.aliyun.com/mvn/search

热门反馈

扫码入社