Re: Batch Processing - Autocommit

Kris Jurka wrote:

>On Wed, 17 Sep 2003, Ron wrote:
>
>
>>I am running postgres 7.4 and want the database to process a large
>>number of transactions at once from a java application. I tried to set
>>autocommit = false, but as of postgres 7.4 that is not possible.
>>
>>    java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF is no longer
>>supported
>>
>>
>
>You need to use the Connection's setAutoCommit method instead of issuing
>the above SQL directly.  Auto commit support has been moved from the
>backend into the various client libraries in 7.4.
>
>Kris Jurka
>
>
Sorry I didn't make it clearer, but I was trying to set it in the java app:
    conn = DriverManager.getConnection(
            "jdbc:postgresql://imo:5432/lytic",
            "postgres",
            "postgres");
        stmt = conn.createStatement();
        conn.setAutoCommit(false);

 The error message above was generated when I tried to run the java code.

Ron