Vic Cekvenich wrote: > I used a driver from http://jdbc.fastcrypt.com/ , the latest driver I > could find w/ JDK1.3 and a simple CachedRowSet from SUN Devlopers > connection. > > It will not update via AcceptChages. > Error is This methos is not yet implementd. > > Can someone help me update a tabe using JDBC plz? Please cc [EMAIL PROTECTED] > > TIA, > Vic > > PS: > My source code: > > import sun.jdbc.rowset.*; > // get it from Java Developer's Connection > // or look at Appendix Download > import java.sql.*; > import org.postgresql.*; > > public class pimRDB { > public static void main (String args[]) > { > try > { > > CachedRowSet crs = new CachedRowSet(); > // row set is better than ResultSet, > // configure driver, read more in book JDBC Database Access : > Class.forName("org.postgresql.Driver"); > crs.setUrl("jdbc:postgresql://localhost/template1"); > // yours should not be localhost, but > //an IP address of DBS server. The 5432 is the IP port > crs.setUsername("sysdba"); > > crs.setPassword("sysdba"); > > //select > crs.setCommand("select NAM from NAM where PK = ?"); > crs.setTableName("NAM"); > // use your field names > crs.setInt(1, 8); > > // pass the first argument to the select command to > // retrieve PK id of Name #8, the 8th name entered > crs.execute(); > crs.next(); > > //get the field value > String nam = crs.getString("NAM"); > System.out.println(nam); > // repeat > crs.updateString("NAM","Vic"); > crs.acceptChanges(); > //select > crs.setCommand("select NAM from NAM where PK = ?"); > // use your field names > crs.setInt(1, 8); > // pass the first argument to the select command to > // retrieve PK id of Name #8, the 8th name entered > crs.execute(); > crs.next(); > > //get the field value > nam = crs.getString("NAM"); > System.out.println(nam); > > } // try > catch (Exception e) {System.out.println(e);} // catch > }// main > }// class > //Optional: Make the program take an argument > //of the PK for the record it should retrieve > > ---------------------------(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