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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]) > >> > >>---------------------------(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 [EMAIL PROTECTED] so that your > >message can get through to the mailing list cleanly
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster