Re: Postgresql and GlassFish - cannot commit when autoCommit is enabled
От | Bill Moran |
---|---|
Тема | Re: Postgresql and GlassFish - cannot commit when autoCommit is enabled |
Дата | |
Msg-id | 20150509062108.cefc3080ea15f7214621c5af@potentialtech.com обсуждение исходный текст |
Ответ на | Postgresql and GlassFish - cannot commit when autoCommit is enabled (Александр Свиридов<ooo_saturn7@mail.ru>) |
Список | pgsql-general |
On Thu, 07 May 2015 10:07:44 +0300 ????????? ???????? <ooo_saturn7@mail.ru> wrote: > > I have postgresql 9.4 and glassfish 4.1. Besides I use MyBatis inside EJB. Now I try to make select from table and thisis what I get: > javax.resource.spi.LocalTransactionException:Cannot commit when autoCommit is enabled. > at com.sun.gjc.spi.LocalTransactionImpl.commit(LocalTransactionImpl.java:112) > at com.sun.enterprise.resource.ConnectorXAResource.commit(ConnectorXAResource.java:124) > at com.sun.enterprise.transaction.JavaEETransactionImpl.commit(JavaEETransactionImpl.java:518) > at com.sun.enterprise.transaction.JavaEETransactionManagerSimplified.commit(JavaEETransactionManagerSimplified.java:854) > at com.sun.ejb.containers.EJBContainerTransactionManager.completeNewTx(EJBContainerTransactionManager.java:719) > at com.sun.ejb.containers.EJBContainerTransactionManager.postInvokeTx(EJBContainerTransactionManager.java:503) > at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4566) > at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2074) > at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2044) > at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:212) > at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:79) > at com.sun.proxy.$Proxy312.getLsist(UnknownSource) > at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:483) > at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie.dispatchToMethod(ReflectiveTie.java:143) > at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:173) > at com.sun.corba.ee.impl.protocol.ServerRequestDispatcherImpl.dispatchToServant(ServerRequestDispatcherImpl.java:528) > at com.sun.corba.ee.impl.protocol.ServerRequestDispatcherImpl.dispatch(ServerRequestDispatcherImpl.java:199) > at com.sun.corba.ee.impl.protocol.MessageMediatorImpl.handleRequestRequest(MessageMediatorImpl.java:1549) > at com.sun.corba.ee.impl.protocol.MessageMediatorImpl.handleRequest(MessageMediatorImpl.java:1425) > at com.sun.corba.ee.impl.protocol.MessageMediatorImpl.handleInput(MessageMediatorImpl.java:930) > at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:213) > at com.sun.corba.ee.impl.protocol.MessageMediatorImpl.handleRequest(MessageMediatorImpl.java:694) > at com.sun.corba.ee.impl.protocol.MessageMediatorImpl.dispatch(MessageMediatorImpl.java:496) > at com.sun.corba.ee.impl.transport.ConnectionImpl$1.dispatch(ConnectionImpl.java:195) > at com.sun.corba.ee.impl.transport.ConnectionImpl.read(ConnectionImpl.java:328) > at com.sun.corba.ee.impl.transport.ReaderThreadImpl.doWork(ReaderThreadImpl.java:112) > at com.sun.corba.ee.impl.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:497) > at com.sun.corba.ee.impl.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:540)Causedby: org.postgresql.util.PSQLException:Cannotcommit when autoCommit is enabled. > at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:811) > at com.sun.gjc.spi.LocalTransactionImpl.commit(LocalTransactionImpl.java:106)...30 more > I even tried the following code: > SqlSession session =ConnectionFactory.getSession().openSession(false);//AUTOCOMMITList list=null; > try{ > session.getConnection().setAutoCommit(false); > TempMapper mapper =(TempMapper)session.getMapper(TempMapper.class); > list=mapper.readAll(); > }catch(SQLException ex){Logger.getLogger(TempBean.class.getName()).log(Level.SEVERE,null, ex);} > finally{ > session.close();} > However the result is the same. When I used gf+mysql+mybatis I changed relaxautocommit but for postgresql driver thereis no such attribute. How to solve it? Best guess, based on experience, is that somehow you're disabling autocommit on a different connection from the one where you're doing the commit. I've seen this sort of thing happen with connection poolers where the developers don't fully understand how the connection pool works. You could confirm this by turning on full query logging in Postgres and see which connection does what. If it turns out to be the case, then you'll have sort out how your code is getting confused. If it's not the case, then I don't have any other ideas, but the full query logging will also tell you whether the command to disable autocommit really is being issued to PostgreSQL as well ... so still might be useful. -- Bill Moran
В списке pgsql-general по дате отправления:
Следующее
От: Stephen FrostДата:
Сообщение: Re: moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information