Re: question about rollback and SQLException

I don't really have something I can easily reduce out of my code.

I started a transaction with Connection.setAutoCommit(false)
Ran some SQL queries using PreparedStatements
Ran a query that I knew would fail, throwing a SQLException
Then I rolledback the transaction (just to be sure) with
Connection.rollback()

It was during Connection.rollback() that I received the exception that's in
my first email. The stack trace picks up from my code as it enters the Resin
& driver code.

-----Original Message-----
From: Dave Cramer [mailto:Dave@micro-automation.net]
Sent: Thursday, January 23, 2003 12:32
To: Andy Kriger
Cc: Resin-Interest; Pgsql-Jdbc
Subject: Re: [JDBC] question about rollback and SQLException


can you send us logs from the server?

or a test case which demonstrates this?

Dave

On Thu, 2003-01-23 at 12:07, Andy Kriger wrote:
> I received this exception when trying to rollback a transaction through
the
> Postgres JDBC driver (build106) used by a webapp running in Resin (2.0.6).
I
> have tried setting up the connection pool in my web.xml to use both
> javax.sql.DataSource and javax.sql.XADataSource, but both give me this
> exception:
>
> java.sql.SQLException: ERROR:  parser: parse error at or near "qrollback"
>         at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
>         at
>
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
> .java:482)
>         at
>
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
> .java:461)
>         at
>
org.postgresql.jdbc1.AbstractJdbc1Connection.rollback(AbstractJdbc1Connectio
> n.java:1031)
>         at
>
com.caucho.sql.UserConnectionAdapter.rollback(UserConnectionAdapter.java:470
> )
>         at com.gto.db.SqlTransaction.rollback(SqlTransaction.java:132)
>
> Any idea what that means and how I can prevent it from occuring?
>
> thx
> andy kriger
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <Dave@micro-automation.net>