Re: WARNING: ROLLBACK: no transaction in progress

Hmmm, I am using the connection pooling in Tomcat to get database
connection, don't know if that would make a difference....


BTJ

On Thu, 2003-06-05 at 02:55, Barry Lind wrote:
> Bjørn,
>
> I can't reproduce your problem.  I used the attached program that I
> wrote from the information you provided below and it doesn't have any
> such warning in the log files.
>
> thanks,
> --Barry
>
>
> Bjørn T Johansen wrote:
> > 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)
> >>>
>
> ______________________________________________________________________
>
> import java.sql.*;
>
> public final class test25 {
>     private static String DB_URL  = "jdbc:postgresql://localhost:5432/test";
>     private static String DB_USER = "test";
>     private static String DB_PASS = "test";
>
>     public static void main(String[] args) throws Exception {
>         // load driver
>         Class.forName("org.postgresql.Driver");
>         // open connection to postgres
>         Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
>         PreparedStatement stmt = null;
>
>         try
>         {
>             conn.setAutoCommit(false);
>             //This test assumes a table 'test' exists with one column 'cola' of type text
>             String sql= "Insert into test (cola) values (?)";
>             stmt = conn.prepareStatement(sql);
>             stmt.setString(1,"foo");
>             int ant = stmt.executeUpdate();
>             stmt.close();
>             stmt = null;
>             conn.commit();
>             conn.close();
>             conn = null;
>         }
>         catch (SQLException ex)
>         {
>             conn.rollback();
>             conn.close();
>             throw ex;
>         }
>     }
> }
--
-----------------------------------------------------------------------------------------------
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."
-----------------------------------------------------------------------------------------------