X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 143D85287D
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Jul 2005 05:57:49 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 71642-06
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Jul 2005 08:57:40 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202])
	by svr1.postgresql.org (Postfix) with ESMTP id C5ABA52806
	for <pgsql-jdbc@postgresql.org>; Tue, 19 Jul 2005 05:57:38 -0300 (ADT)
Received: by wproxy.gmail.com with SMTP id i34so1159064wra
	for <pgsql-jdbc@postgresql.org>; Tue, 19 Jul 2005 01:57:41 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=F756RN5Q6eH+o8YLFyvzh7xtdrcDNwMpSv4GsSpn4GuGjWNXAEH6nNeoZuyu85m3ZSnxla2Ki48eUJ8R+FQAlBd5thZk95MG6I9ifY588iFfMGdbySBTvDpsZwWn7W+rO7Eq8KpDSfQHxh+8AW6lLtAEMWKn44Dp3U9Uk/muBk8=
Received: by 10.54.68.4 with SMTP id q4mr659199wra;
	Tue, 19 Jul 2005 01:56:40 -0700 (PDT)
Received: by 10.54.52.9 with HTTP; Tue, 19 Jul 2005 01:56:40 -0700 (PDT)
Message-ID: <4ea55c3305071901563ca33cb8@mail.gmail.com>
Date: Tue, 19 Jul 2005 14:56:40 +0600
From: Senthoorkumaran Punniamoorthy <senthoor@gmail.com>
Reply-To: Senthoorkumaran Punniamoorthy <senthoor@gmail.com>
To: pgsql-jdbc@postgresql.org
Subject: org.postgresql.util.PSQLException: ERROR: current transaction is
	aborted, commands ignored until end of transaction block
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200507/117
X-Sequence-Number: 13265

We are using postgres as our DB for our application based on EJB. I am
using the pg74.216.jdbc3.jar driver.

one of the EJB-QL in the finder method translates to a query in JBoss as=20

Executing SQL: SELECT t0_o.userId, t0_o.deviceId FROM rcp_user_device
t0_o WHERE (t0_o.userId =3D ?)

This query works on the postgres command line interface fine.=20

SELECT t0_o.userId, t0_o.deviceId BEING_VAULT=3D# SELECT t0_o.userId,
t0_o.deviceId FROM rcp_user_device t0_o WHERE (t0_o.userId =3D
'94773059650')
BEING_VAULT-# ;
   userid    |    deviceid    =20
-------------+-----------------
 94773059650 | 351532002206818
(1 row)

However JDBC driver is rasing an exception, and below is the stack trace.=
=20

2005-07-19 12:14:54,506 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.UserDeviceEntityBean#findAll=
ByUser]
Executing SQL: SELECT t0_o.userId, t0_o.deviceId FROM rcp_user_device
t0_o WHERE (t0_o.userId =3D ?)
2005-07-19 12:14:54,509 ERROR
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.UserDeviceEntityBean#findAll=
ByUser]
Find failed
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block

        at org.postgresql.util.PSQLException.parseServerError(PSQLException=
.java:139)
        at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:1=
52)
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100=
)
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc=
1Statement.java:517)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc=
2Statement.java:50)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(Abstrac=
tJdbc1Statement.java:233)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute=
Query(WrappedPreparedStatement.java:296)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(=
JDBCAbstractQueryCommand.java:228)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(=
JDBCAbstractQueryCommand.java:128)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(J=
DBCFindEntitiesCommand.java:40)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDB=
CStoreManager.java:598)
        at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPers=
istenceManager.java:322)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor=
.findEntities(CachedConnectionInterceptor.java:321)
        at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:649=
)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor=
Impl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod=
AccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
        at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(En=
tityContainer.java:1113)
        at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInt=
erceptor.java:90)
        at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHom=
e(EntitySynchronizationInterceptor.java:192)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor=
.invokeHome(CachedConnectionInterceptor.java:212)
        at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInt=
erceptor.java:90)
        at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(Entit=
yInstanceInterceptor.java:117)
        at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLoc=
kInterceptor.java:61)
        at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(Entit=
yCreationInterceptor.java:28)
        at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallV=
alidationInterceptor.java:41)
        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractT=
xInterceptor.java:109)
        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInt=
erceptorCMT.java:335)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorC=
MT.java:146)
        at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInt=
erceptor.java:116)
        at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.j=
ava:121)
        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(P=
roxyFactoryFinderInterceptor.java:93)
        at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer=
.java:508)
        at org.jboss.ejb.Container.invoke(Container.java:894)
        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(Bas=
eLocalProxyFactory.java:342)
        at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy=
.java:118)
        at $Proxy279.findAllByUser(Unknown Source)
        at com.purpleace.ripple.contacts.ejb.session.UnsubscriptionSessionB=
ean.deleteUserDevices(UnsubscriptionSessionBean.java:176)
        at com.purpleace.ripple.contacts.ejb.session.UnsubscriptionSessionB=
ean.unsubscribe(UnsubscriptionSessionBean.java:147)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor=
Impl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod=
AccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.inv=
oke(StatelessSessionContainer.java:214)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor=
.invoke(CachedConnectionInterceptor.java:185)
        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke=
(StatelessSessionInstanceInterceptor.java:130)
        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(Se=
rviceEndpointInterceptor.java:51)
        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValid=
ationInterceptor.java:48)
        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractT=
xInterceptor.java:105)
        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInt=
erceptorCMT.java:335)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.j=
ava:166)
        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterce=
ptor.java:139)
        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:=
192)
        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(Proxy=
FactoryFinderInterceptor.java:122)
        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.j=
ava:624)
        at org.jboss.ejb.Container.invoke(Container.java:873)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor=
Impl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod=
AccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDis=
patcher.java:141)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInv=
oker.java:249)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:=
644)
        at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke=
(LocalInvoker.java:155)
        at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java=
:104)
        at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInter=
ceptor.java:179)
        at org.jboss.invocation.InvokerInterceptor.invoke(InvokerIntercepto=
r.java:165)
        at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterce=
ptor.java:46)
        at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.j=
ava:55)
        at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(Stateless=
SessionInterceptor.java:97)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
        at $Proxy379.unsubscribe(Unknown Source)
        at com.purpleace.ripple.contacts.ejb.session.MsisdnUpdaterSessionBe=
an.removeOldUser(MsisdnUpdaterSessionBean.java:248)
        at com.purpleace.ripple.contacts.ejb.session.MsisdnUpdaterSessionBe=
an.updateWhereUserIdEqualsMsisdn(MsisdnUpdaterSessionBean.java:231)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor=
Impl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod=
AccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.inv=
oke(StatelessSessionContainer.java:214)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor=
.invoke(CachedConnectionInterceptor.java:185)
        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke=
(StatelessSessionInstanceInterceptor.java:130)
        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(Se=
rviceEndpointInterceptor.java:51)
        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValid=
ationInterceptor.java:48)
        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractT=
xInterceptor.java:105)
        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInt=
erceptorCMT.java:335)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.j=
ava:166)
        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterce=
ptor.java:139)
        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:=
192)
        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(Proxy=
FactoryFinderInterceptor.java:122)
        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.j=
ava:624)
        at org.jboss.ejb.Container.invoke(Container.java:873)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor=
Impl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod=
AccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDis=
patcher.java:141)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInv=
oker.java:249)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:=
644)
        at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke=
(LocalInvoker.java:155)
        at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java=
:104)
        at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInter=
ceptor.java:179)
        at org.jboss.invocation.InvokerInterceptor.invoke(InvokerIntercepto=
r.java:165)
        at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterce=
ptor.java:46)
        at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.j=
ava:55)
        at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(Stateless=
SessionInterceptor.java:97)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
        at $Proxy361.updateWhereUserIdEqualsMsisdn(Unknown Source)
        at com.purpleace.ripple.contacts.serviceinterface.facade.ChangeMsis=
dnFacade.changeMsisdn(ChangeMsisdnFacade.java:44)
        at com.purpleace.ripple.contacts.web.servlets.ChangeMsisdnServelet.=
controller(ChangeMsisdnServelet.java:166)
        at com.purpleace.ripple.contacts.web.servlets.ChangeMsisdnServelet.=
newHandleRequest(ChangeMsisdnServelet.java:78)
        at com.purpleace.ripple.contacts.web.servlets.ChangeMsisdnServelet.=
doPost(ChangeMsisdnServelet.java:61)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter=
(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applica=
tionFilterChain.java:173)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(Applicatio=
nDispatcher.java:672)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(Ap=
plicationDispatcher.java:463)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(Applica=
tionDispatcher.java:398)
        at org.apache.catalina.core.ApplicationDispatcher.forward(Applicati=
onDispatcher.java:301)
        at com.purpleace.ripple.contacts.web.servlets.RippleServlet.control=
ler(RippleServlet.java:271)
        at com.purpleace.ripple.contacts.web.servlets.RippleServlet.parseSt=
ring(RippleServlet.java:425)
        at com.purpleace.ripple.contacts.web.servlets.RippleServlet.handleR=
equest(RippleServlet.java:124)
        at com.purpleace.ripple.contacts.web.servlets.RippleServlet.doPost(=
RippleServlet.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter=
(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applica=
tionFilterChain.java:173)
        at com.purpleace.ripple.contacts.web.filters.GlobalFilter.doFilter(=
GlobalFilter.java:37)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter=
(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applica=
tionFilterChain.java:173)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHea=
derFilter.java:81)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter=
(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applica=
tionFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWra=
pperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardCon=
textValve.java:178)
        at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Custom=
PrincipalValve.java:39)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Se=
curityAssociationValve.java:153)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContex=
tValve.java:59)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostVa=
lve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportVa=
lve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngi=
neValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapte=
r.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor=
.java:856)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.=
processConnection(Http11Protocol.java:744)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcp=
Endpoint.java:527)
        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSla=
veWorkerThread.java:112)
        at java.lang.Thread.run(Thread.java:534)

Can you help me identify this issue?=20

Regards,
Senthoor