Re: Batch Processing - Autocommit

Thanks Barry, that was the problem. Batch statements are working now,
I'll re-run the app and see how long the run takes now. Aside from using
batches, are there any other java/jdbc major performance boosters that
anyone cares to suggest? I'm about to tweak the posgtres configuration
files and see what gains I can get from there.

Thanks
Ron

Barry Lind wrote:

> Are you using the 7.4 version of the jdbc driver?  It sound's like you
> are using the 7.3 driver against a 7.4 database.
>
> thanks,
> --Barry
>
>
> Ron wrote:
>
>> 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
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>