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@xxxxxxxxxxxxxx



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings