Itried everywhere.... can't get JDBC to update. I can't build 7.13 J2EE JDBC, I get build errors.
The driver I have bellow, I can't get to update using bellow code.... Suggestions please? Vic -------- Original Message -------- Subject: Re: JDBC update wont, plz help. Date: Wed, 26 Sep 2001 10:24:30 -0700 From: Vic Cekvneich <[EMAIL PROTECTED]> Organization: Hub.Org Networking Services (http://www.hub.org) Newsgroups: comp.databases.postgresql.general References: <[EMAIL PROTECTED]> I downloaded the 7.13 src and did a JDBC build using J2EE 13, to get the sqlX package. The build failed with errors. Is there someone who can make a build with sqlX java (must have J2EE SDK enviroment) ? Help...... please.... Vic Vic Cekvenich wrote: > I am dead in the water.... > > > 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.updateRow(); >>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 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(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
