Re: WARNING: ROLLBACK: no transaction in progress

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(at)havleik(dot)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(at)postgresql(dot)org)
> >
--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen (BSc,MNIF)
Executive Manager
btj(at)havleik(dot)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."
-----------------------------------------------------------------------------------------------