Postgres Pro
Downloads
Home   >   mailing lists

Re: org.postgresql.util.PSQLException: ERROR: current transaction - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: org.postgresql.util.PSQLException: ERROR: current transaction
Date
Msg-id 42DCEF18.5070603@opencloud.com
Whole thread Raw
In response to org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block  (Senthoorkumaran Punniamoorthy <senthoor@gmail.com>)
List pgsql-jdbc
Tree view 
Senthoorkumaran Punniamoorthy wrote:

> 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

This means that a *previous* query in the same transaction has failed.
Check for errors caused by an earlier query.

-O

pgsql-jdbc by date:

Previous
From: im i
Date:
Subject: Re: newbie question to setTimestamp( int parameterIndex, Timestamp x, Calendar cal)
Next
From: Dave Cramer
Date:
Subject: Re: Timestamp Conversion Woes Redux