| Senthoorkumaran Punniamoorthy 2005-07-19, 7:24 am |
| 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
Executing SQL: SELECT t0_o.userId, t0_o.deviceId FROM rcp_user_device
t0_o WHERE (t0_o.userId = ?)
This query works on the postgres command line interface fine.
SELECT t0_o.userId, t0_o.deviceId BEING_VAULT=# SELECT t0_o.userId,
t0_o.deviceId FROM rcp_user_device t0_o WHERE (t0_o.userId =
'94773059650')
BEING_VAULT-# ;
userid | deviceid
-------------+-----------------
94773059650 | 351532002206818
(1 row)
However JDBC driver is rasing an exception, and below is the stack trace.
2005-07-19 12:14:54,506 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. UserDeviceEntityBean
#findAllByUser]
Executing SQL: SELECT t0_o.userId, t0_o.deviceId FROM rcp_user_device
t0_o WHERE (t0_o.userId = ?)
2005-07-19 12:14:54,509 ERROR
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. UserDeviceEntityBean
#findAllByUser]
Find failed
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block
at org.postgresql.util.PSQLException. parseServerError(PSQ
LException.java:139)
at org.postgresql.core.QueryExecutor. executeV3(QueryExecu
tor.java:152)
at org.postgresql.core.QueryExecutor. execute(QueryExecuto
r.java:100)
at org.postgresql.core.QueryExecutor. execute(QueryExecuto
r.java:43)
at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. execute(AbstractJdbc
1Statement.java:517)
at org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. execute(AbstractJdbc
2Statement.java:50)
at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. executeQuery(Abstrac
tJdbc1Statement.java:233)
at org.jboss.resource.adapter.jdbc. WrappedPreparedState
ment. executeQuery(Wrapped
PreparedStatement.java:296)
at org.jboss.ejb.plugins.cmp.jdbc. JDBCAbstractQueryCom
mand. execute(JDBCAbstract
QueryCommand.java:228)
at org.jboss.ejb.plugins.cmp.jdbc. JDBCAbstractQueryCom
mand. execute(JDBCAbstract
QueryCommand.java:128)
at org.jboss.ejb.plugins.cmp.jdbc. JDBCFindEntitiesComm
and. execute(JDBCFindEnti
tiesCommand.java:40)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager. findEntities(JDBCSto
reManager.java:598)
at org.jboss.ejb.plugins. CMPPersistenceManage
r. findEntities(CMPPers
istenceManager.java:322)
at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. findEntities(CachedC
onnectionInterceptor
.java:321)
at org.jboss.ejb.EntityContainer. findLocal(EntityCont
ainer.java:649)
at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation. performCall(Invocati
on.java:345)
at org.jboss.ejb. EntityContainer$Cont
ainerInterceptor. invokeHome(EntityCon
tainer.java:1113)
at org.jboss.ejb.plugins.AbstractInterceptor. invokeHome(AbstractI
nterceptor.java:90)
at org.jboss.ejb.plugins. EntitySynchronizatio
nInterceptor. invokeHome(EntitySyn
chronizationIntercep
tor.java:192)
at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. invokeHome(CachedCon
nectionInterceptor.java:212)
at org.jboss.ejb.plugins.AbstractInterceptor. invokeHome(AbstractI
nterceptor.java:90)
at org.jboss.ejb.plugins. EntityInstanceInterc
eptor. invokeHome(EntityIns
tanceInterceptor.java:117)
at org.jboss.ejb.plugins. EntityLockIntercepto
r. invokeHome(EntityLoc
kInterceptor.java:61)
at org.jboss.ejb.plugins. EntityCreationInterc
eptor. invokeHome(EntityCre
ationInterceptor.java:28)
at org.jboss.ejb.plugins. CallValidationInterc
eptor. invokeHome(CallValid
ationInterceptor.java:41)
at org.jboss.ejb.plugins. AbstractTxIntercepto
r. invokeNext(AbstractT
xInterceptor.java:109)
at org.jboss.ejb.plugins.TxInterceptorCMT. runWithTransactions(
TxInterceptorCMT.java:335)
at org.jboss.ejb.plugins.TxInterceptorCMT. invokeHome(TxInterce
ptorCMT.java:146)
at org.jboss.ejb.plugins.SecurityInterceptor. invokeHome(SecurityI
nterceptor.java:116)
at org.jboss.ejb.plugins.LogInterceptor. invokeHome(LogInterc
eptor.java:121)
at org.jboss.ejb.plugins. ProxyFactoryFinderIn
terceptor. invokeHome(ProxyFact
oryFinderInterceptor
.java:93)
at org.jboss.ejb.EntityContainer. internalInvokeHome(E
ntityContainer.java:508)
at org.jboss.ejb.Container.invoke(Container.java:894)
at org.jboss.ejb.plugins.local. BaseLocalProxyFactor
y. invokeHome(BaseLocal
ProxyFactory.java:342)
at org.jboss.ejb.plugins.local.LocalHomeProxy. invoke(LocalHomeProx
y.java:118)
at $Proxy279. findAllByUser(Unknow
n Source)
at com.purpleace.ripple.contacts.ejb.session. UnsubscriptionSessio
nBean. deleteUserDevices(Un
subscriptionSessionB
ean.java:176)
at com.purpleace.ripple.contacts.ejb.session. UnsubscriptionSessio
nBean. unsubscribe(Unsubscr
iptionSessionBean.java:147)
at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation. performCall(Invocati
on.java:345)
at org.jboss.ejb. StatelessSessionCont
ainer$ContainerInter
ceptor. invoke(StatelessSess
ionContainer.java:214)
at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. invoke(CachedConnect
ionInterceptor.java:185)
at org.jboss.ejb.plugins. StatelessSessionInst
anceInterceptor. invoke(StatelessSess
ionInstanceIntercept
or.java:130)
at org.jboss.webservice.server. ServiceEndpointInter
ceptor. invoke(ServiceEndpoi
ntInterceptor.java:51)
at org.jboss.ejb.plugins. CallValidationInterc
eptor. invoke(CallValidatio
nInterceptor.java:48)
at org.jboss.ejb.plugins. AbstractTxIntercepto
r. invokeNext(AbstractT
xInterceptor.java:105)
at org.jboss.ejb.plugins.TxInterceptorCMT. runWithTransactions(
TxInterceptorCMT.java:335)
at org.jboss.ejb.plugins.TxInterceptorCMT. invoke(TxInterceptor
CMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor. invoke(SecurityInter
ceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor. invoke(LogIntercepto
r.java:192)
at org.jboss.ejb.plugins. ProxyFactoryFinderIn
terceptor. invoke(ProxyFactoryF
inderInterceptor.java:122)
at org.jboss.ejb.SessionContainer. internalInvoke(Sessi
onContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher. invoke(ReflectedDisp
atcher.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(AbstractMBean
Invoker.java:249)
at org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:644)
at org.jboss.invocation.local. LocalInvoker$MBeanSe
rverAction.invoke(LocalInvoker.java:155)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
at org.jboss.invocation.InvokerInterceptor. invokeLocal(InvokerI
nterceptor.java:179)
at org.jboss.invocation.InvokerInterceptor. invoke(InvokerInterc
eptor.java:165)
at org.jboss.proxy. TransactionIntercept
or. invoke(TransactionIn
terceptor.java:46)
at org.jboss.proxy.SecurityInterceptor. invoke(SecurityInter
ceptor.java:55)
at org.jboss.proxy.ejb. StatelessSessionInte
rceptor. invoke(StatelessSess
ionInterceptor.java:97)
at org.jboss.proxy.ClientContainer. invoke(ClientContain
er.java:86)
at $Proxy379.unsubscribe(Unknown Source)
at com.purpleace.ripple.contacts.ejb.session. MsisdnUpdaterSession
Bean. removeOldUser(Msisdn
UpdaterSessionBean.java:248)
at com.purpleace.ripple.contacts.ejb.session. MsisdnUpdaterSession
Bean. updateWhereUserIdEqu
alsMsisdn(MsisdnUpda
terSessionBean.java:231)
at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.invocation.Invocation. performCall(Invocati
on.java:345)
at org.jboss.ejb. StatelessSessionCont
ainer$ContainerInter
ceptor. invoke(StatelessSess
ionContainer.java:214)
at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. invoke(CachedConnect
ionInterceptor.java:185)
at org.jboss.ejb.plugins. StatelessSessionInst
anceInterceptor. invoke(StatelessSess
ionInstanceIntercept
or.java:130)
at org.jboss.webservice.server. ServiceEndpointInter
ceptor. invoke(ServiceEndpoi
ntInterceptor.java:51)
at org.jboss.ejb.plugins. CallValidationInterc
eptor. invoke(CallValidatio
nInterceptor.java:48)
at org.jboss.ejb.plugins. AbstractTxIntercepto
r. invokeNext(AbstractT
xInterceptor.java:105)
at org.jboss.ejb.plugins.TxInterceptorCMT. runWithTransactions(
TxInterceptorCMT.java:335)
at org.jboss.ejb.plugins.TxInterceptorCMT. invoke(TxInterceptor
CMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor. invoke(SecurityInter
ceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor. invoke(LogIntercepto
r.java:192)
at org.jboss.ejb.plugins. ProxyFactoryFinderIn
terceptor. invoke(ProxyFactoryF
inderInterceptor.java:122)
at org.jboss.ejb.SessionContainer. internalInvoke(Sessi
onContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher. invoke(ReflectedDisp
atcher.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(AbstractMBean
Invoker.java:249)
at org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:644)
at org.jboss.invocation.local. LocalInvoker$MBeanSe
rverAction.invoke(LocalInvoker.java:155)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
at org.jboss.invocation.InvokerInterceptor. invokeLocal(InvokerI
nterceptor.java:179)
at org.jboss.invocation.InvokerInterceptor. invoke(InvokerInterc
eptor.java:165)
at org.jboss.proxy. TransactionIntercept
or. invoke(TransactionIn
terceptor.java:46)
at org.jboss.proxy.SecurityInterceptor. invoke(SecurityInter
ceptor.java:55)
at org.jboss.proxy.ejb. StatelessSessionInte
rceptor. invoke(StatelessSess
ionInterceptor.java:97)
at org.jboss.proxy.ClientContainer. invoke(ClientContain
er.java:86)
at $Proxy361. updateWhereUserIdEqu
alsMsisdn(Unknown Source)
at com.purpleace.ripple.contacts.serviceinterface.facade.ChangeMsisdnFacade. changeMsisdn(ChangeM
sisdnFacade.java:44)
at com.purpleace.ripple.contacts.web.servlets. ChangeMsisdnServelet
. controller(ChangeMsi
sdnServelet.java:166)
at com.purpleace.ripple.contacts.web.servlets. ChangeMsisdnServelet
. newHandleRequest(Cha
ngeMsisdnServelet.java:78)
at com.purpleace.ripple.contacts.web.servlets. ChangeMsisdnServelet
. doPost(ChangeMsisdnS
ervelet.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. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:252)
at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
at org.apache.catalina.core. ApplicationDispatche
r. invoke(ApplicationDi
spatcher.java:672)
at org.apache.catalina.core. ApplicationDispatche
r. processRequest(Appli
cationDispatcher.java:463)
at org.apache.catalina.core. ApplicationDispatche
r. doForward(Applicatio
nDispatcher.java:398)
at org.apache.catalina.core. ApplicationDispatche
r. forward(ApplicationD
ispatcher.java:301)
at com.purpleace.ripple.contacts.web.servlets.RippleServlet. controller(RippleSer
vlet.java:271)
at com.purpleace.ripple.contacts.web.servlets.RippleServlet. parseString(RippleSe
rvlet.java:425)
at com.purpleace.ripple.contacts.web.servlets.RippleServlet. handleRequest(Ripple
Servlet.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. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:252)
at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
at com.purpleace.ripple.contacts.web.filters.GlobalFilter. doFilter(GlobalFilte
r.java:37)
at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:202)
at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter. doFilter(ReplyHeader
Filter.java:81)
at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:202)
at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
at org.apache.catalina.core. StandardWrapperValve
. invoke(StandardWrapp
erValve.java:213)
at org.apache.catalina.core. StandardContextValve
. invoke(StandardConte
xtValve.java:178)
at org.jboss.web.tomcat.security. CustomPrincipalValve
. invoke(CustomPrincip
alValve.java:39)
at org.jboss.web.tomcat.security. SecurityAssociationV
alve. invoke(SecurityAssoc
iationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve. invoke(JaccContextVa
lve.java:59)
at org.apache.catalina.core.StandardHostValve. invoke(StandardHostV
alve.java:126)
at org.apache.catalina.valves.ErrorReportValve. invoke(ErrorReportVa
lve.java:105)
at org.apache.catalina.core.StandardEngineValve. invoke(StandardEngin
eValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter. service(CoyoteAdapte
r.java:148)
at org.apache.coyote.http11.Http11Processor. process(Http11Proces
sor.java:856)
at org.apache.coyote.http11. Http11Protocol$Http1
1ConnectionHandler. processConnection(Ht
tp11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint. processSocket(PoolTc
pEndpoint.java:527)
at org.apache.tomcat.util.net. MasterSlaveWorkerThr
ead. run(MasterSlaveWorke
rThread.java:112)
at java.lang.Thread.run(Thread.java:534)
Can you help me identify this issue?
Regards,
Senthoor
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
|