PostgreSQL JDBC - Re: org.postgresql.util.PSQLException: ERROR: current transaction

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: org.postgresql.util.PSQLException: ERROR: current transaction

Oliver Jowett

2005-07-19, 7:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links