That's what I thought too, except I'm not sending the rollback cmd as a
String, I'm using JDBC's Connection.rollback(), which would seem to suggest
that the error is in the driver (which is why I'm posting to pgsql-jdbc ->
hoping a driver developer can comment on this).
-----Original Message-----
From: Ross J. Reedstrom [mailto:reedstrm@rice.edu]
Sent: Thursday, January 23, 2003 12:32
To: Andy Kriger
Cc: Pgsql-Jdbc
Subject: Re: [JDBC] question about rollback and SQLException
On Thu, Jan 23, 2003 at 12:07:31PM -0500, 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"
"qrollback"? Sure looks like a typo in your code somewhere, to me.
Ross