Lola Lee wrote:

> I have Postgresql 7.4 installed.  Have a form and I'm trying to
> insert the form contents into several tables in the database.
>
> Whenever I wrap the queries with the cftransaction tags and I try to
> run this insert template, I get the following message:
>
>
> The root cause was that: java.sql.SQLException: ERROR: SET AUTOCOMMIT
> TO OFF is no longer supported

> Yet, it works when I comment out the cftransaction tags.  So, what
> does this error message mean?

It probably means you have an outdated JDBC driver:
http://archives.postgresql.org/pgsql-jdbc/2003-11/msg00184.php

Make sure you have at least the the 7.4 driver:
http://jdbc.postgresql.org/download.html

Jochem

--
When you don't want to be surprised by the revolution
organize one yourself
     - Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to