Re: JDBC 7.3 dev (Java 2 SDK 1.4.0)

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