problem with new autocommit config parameter and jdbc - Mailing list pgsql-hackers

Haris,

You can't use jdbc (and probably most other postgres clients) with
autocommit in postgresql.conf turned off.

Hackers,

How should client interfaces handle this new autocommit feature?  Is it
best to just issue a set at the beginning of the connection to ensure
that it is always on?

thanks,
--Barry



snpe wrote:

   >Hi Dave,
   >That is same.Program work with and without quote but row don't deleted.
   >Postgresql is 7.3 beta (from cvs) and parameter autocommit in
postgresql.conf
   >is off (no auto commit).
   >I am tried with db.autocommit(true) after getConnection, but no success
   >
   >I thin that is bug in JDBC
   >PGSql 7.3 beta have new features autocommit on/off and JDBC driver
don't work
   >with autocommit off
   >
   >Thanks
   >
   >P.S
   >I am play ith Oracle JDeveloper 9i and Postgresql and I get error in
prepared
   >statement like this error :
   >(oracle.jbo.SQLStmtException) JBO-27123: SQL error during call statement
   >preparation.  Statement:  DELETE FROM org_ban WHERE "id"=?
   >
   >and pgsqlerror is :
   >(org.postgresql.util.PSQLException) Malformed stmt [DELETE FROM
org_ban WHERE
   >"id"=?] usage : {[? =] call <some_function> ([? [,?]*]) }
   >
   >I think that JDeveloper call CallableStatement for insert or delete
(select
   >and update work fine), but I don't know how.
   >
   >On Friday 06 September 2002 04:35 pm, Dave Cramer wrote:
   >
   >
   >>Remove the quotes around id, and let me know what happens
   >>
   >>Dave
   >>
   >>On Fri, 2002-09-06 at 10:52, snpe wrote:
   >>
   >>
   >>>Hello Dave,
   >>>  There isn't any error.Program write 'Rows deleted 1', but row hasn't
   >>>been deleted
   >>>
   >>>Thanks
   >>>Haris Peco
   >>>
   >>>On Friday 06 September 2002 04:05 pm, Dave Cramer wrote:
   >>>
   >>>
   >>>>Harris,
   >>>>
   >>>>What error do you get?
   >>>>
   >>>>Also you don't need  the quotes around id
   >>>>
   >>>>Dave
   >>>>
   >>>>On Fri, 2002-09-06 at 10:06, snpe wrote:
   >>>>
   >>>>
   >>>>>Hello,
   >>>>>  I have simple table with column ID and values '4' in this.
   >>>>>I user 7.3 beta1 (from cvs 05.09.2002) and autocommit off in
   >>>>>postgresql.conf. Next program don't work .
   >>>>>I am tried with compiled postgresql.jar form CVS and with
   >>>>>pg73b1jdbc3.jar from 05.09.2002 on jdbc.postgresql.org
   >>>>>
   >>>>>What is wrong ?
   >>>>>
   >>>>>regards
   >>>>>Haris Peco
   >>>>>import java.io.*;
   >>>>>import java.sql.*;
   >>>>>import java.text.*;
   >>>>>
   >>>>>public class PrepStatTest
   >>>>>{
   >>>>>    Connection db;
   >>>>>    String stat="DELETE FROM org_ban WHERE \"id\" = ?";
   >>>>>    String delid = "4";
   >>>>>    public PrepStatTest() throws ClassNotFoundException,
   >>>>>FileNotFoundException, IOException, SQLException
   >>>>>    {
   >>>>>
    Class.forName("org.postgresql.Driver");
   >>>>>
    db = DriverManager.getConnection("jdbc:postgresql://spnew/snpe",
   >>>>>"snpe", "snpe");
   >>>>>
    PreparedStatement st = db.prepareStatement(stat);
   >>>>>            st.setString(1, delid);
   >>>>>            int rowsDeleted = st.executeUpdate();
   >>>>>
    System.out.println("Rows deleted " + rowsDeleted);
   >>>>>
    db.commit();
   >>>>>
    st.close();
   >>>>>
    db.close();
   >>>>>    }
   >>>>>
   >>>>>    public static void main(String args[])
   >>>>>    {
   >>>>>
    try
   >>>>>
    {
   >>>>>
        PrepStatTest test = new PrepStatTest();
   >>>>>
    }
   >>>>>
    catch (Exception ex)
   >>>>>
    {
   >>>>>
        System.err.println("Exception caught.\n" + ex);
   >>>>>
        ex.printStackTrace();
   >>>>>
    }
   >>>>>    }
   >>>>>}
   >>>>>
   >>>>>
   >>>>>---------------------------(end of
   >>>>>broadcast)--------------------------- TIP 3: if posting/reading
   >>>>>through Usenet, please send an appropriate subscribe-nomail command
   >>>>>to majordomo@postgresql.org so that your message can get through to
   >>>>>the mailing list cleanly
   >>>>>
   >>>>>
   >>>---------------------------(end of
broadcast)---------------------------
   >>>TIP 2: you can get off all lists at once with the unregister command
   >>>    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
   >>>
   >>>
   >>---------------------------(end of
broadcast)---------------------------
   >>TIP 4: Don't 'kill -9' the postmaster
   >>
   >>
   >
   >
   >---------------------------(end of broadcast)---------------------------
   >TIP 3: if posting/reading through Usenet, please send an appropriate
   >subscribe-nomail command to majordomo@postgresql.org so that your
   >message can get through to the mailing list cleanly
   >
   >
   >