jfinal 2.2 oracle 事务级别问题

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: 仅 READ_COMMITTED 和 SERIALIZABLE 是有效的事务处理级
	at com.jfinal.plugin.activerecord.DbPro.tx(DbPro.java:723)
	at com.jfinal.plugin.activerecord.DbPro.tx(DbPro.java:748)
	at com.jfinal.plugin.activerecord.Db.tx(Db.java:460)
	at com.lt.service.S2120Service.save(S2120Service.java:59)
	at com.lt.service.S2120Service$$EnhancerByCGLIB$$520e025.CGLIB$save$0(<generated>)
	at com.lt.service.S2120Service$$EnhancerByCGLIB$$520e025$$FastClassByCGLIB$$7c9cb132.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:82)
	at com.jfinal.aop.Callback.intercept(Callback.java:96)
	at com.lt.service.S2120Service$$EnhancerByCGLIB$$520e025.save(<generated>)
	at com.lt.controller.C2120Controller.save(C2120Controller.java:61)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:73)
	at com.lt.Interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:22)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
	at com.jfinal.core.ActionHandler.handle(ActionHandler.java:74)
	at com.lt.handler.PermissionHandler.handle(PermissionHandler.java:58)
	at com.jfinal.ext.handler.ContextPathHandler.handle(ContextPathHandler.java:47)
	at com.jfinal.plugin.druid.DruidStatViewHandler.handle(DruidStatViewHandler.java:75)
	at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: 仅 READ_COMMITTED 和 SERIALIZABLE 是有效的事务处理级
	at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:4611)
	at com.alibaba.druid.filter.FilterChainImpl.connection_setTransactionIsolation(FilterChainImpl.java:633)
	at com.alibaba.druid.filter.FilterAdapter.connection_setTransactionIsolation(FilterAdapter.java:1031)
	at com.alibaba.druid.filter.FilterChainImpl.connection_setTransactionIsolation(FilterChainImpl.java:629)
	at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setTransactionIsolation(ConnectionProxyImpl.java:488)
	at com.alibaba.druid.pool.DruidPooledConnection.setTransactionIsolation(DruidPooledConnection.java:899)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.jfinal.plugin.activerecord.SqlReporter.invoke(SqlReporter.java:58)
	at com.sun.proxy.$Proxy5.setTransactionIsolation(Unknown Source)
	at com.jfinal.plugin.activerecord.DbPro.tx(DbPro.java:709)
	... 45 more

@Jfinal 这个应该怎么设置呢?各位大神?

评论区

FS心情

2016-12-12 20:15

Db.tx(2,new IAtom()...........这么改?????

JFinal

2016-12-12 20:30

arp.setTransactionLevel(2)

FS心情

2016-12-13 09:47

独享一人时光

2017-10-27 09:54

@FS心情 我改了怎么也不行。。还是报一样的错。

热门反馈

扫码入社