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

Hello Barry,
  JDBC driver must find autocommit (off or on) and set autoCommit field
when open connection.
regards
On Friday 06 September 2002 06:52 pm, Barry Lind wrote:
> 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