Re: WARNING: ROLLBACK: no transaction in progress - Mailing list pgsql-jdbc

I am using the new version 7.3.3 where I also compiled the jdbc driver..

The code I use looks something like this..:

    Connection conn = DBPool.getInstance().getConnection();
    PreparedStatement stmt = null;
    Statement stmt2 = null;

    try
    {
      conn.setAutoCommit(false);

      String sql= "Insert into table () Values (?)";
      stmt = conn.prepareStatement(sql);
      int ant = stmt.executeUpdate();
      stmt.close();
      stmt = null;
      conn.commit();
      conn.close();
      conn = null;
    }
    catch (SQLException ex)
    {
      conn.rollback();
      conn.close();
      throw new Exception;
    }



Hope this helps...

BTJ


On Wed, 2003-05-28 at 11:53, Dave Cramer wrote:
> What version of the driver are you using, this sounds like a bug
>
> Can you send some code to re-create it?
>
> Dave
> On Tue, 2003-05-27 at 06:33, Bjorn T Johansen wrote:
> > Why do I get this in my logfile, when I never call rollback, only
> > commit? Should I just ignore this or??
> >
> >
> > Regards,
> >
> > BTJ
> >
> >
> > -----------------------------------------------------------------------------------------------
> > Bjørn T Johansen (BSc,MNIF)
> > Executive Manager
> > btj@havleik.no                  Havleik Consulting
> > Phone: +47 67 54 15 17         Conradisvei 4
> > Fax: +47 67 54 13 91           N-1338 Sandvika
> > Cellular: +47 926 93 298       http://www.havleik.no
> > -----------------------------------------------------------------------------------------------
> > "The stickers on the side of the box said "Supported Platforms: Windows
> > 98, Windows NT 4.0,
> > Windows 2000 or better", so clearly Linux was a supported platform."
> > -----------------------------------------------------------------------------------------------
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen (BSc,MNIF)
Executive Manager
btj@havleik.no                  Havleik Consulting
Phone : +47 67 54 15 17         Conradisvei 4
Fax : +47 67 54 13 91           N-1338 Sandvika
Cellular : +47 926 93 298       http://www.havleik.no
-----------------------------------------------------------------------------------------------
"The stickers on the side of the box said "Supported Platforms: Windows
98, Windows NT 4.0,
Windows 2000 or better", so clearly Linux was a supported platform."
-----------------------------------------------------------------------------------------------