Re: JDBC update wont, plz help. - Mailing list pgsql-general
From | Vic Cekvneich |
---|---|
Subject | Re: JDBC update wont, plz help. |
Date | |
Msg-id | 3BB20F4E.2020606@proj.com Whole thread Raw |
In response to | JDBC update wont, plz help. (Vic Cekvenich <vic@proJ.com>) |
List | pgsql-general |
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 vic@proj.com. >> >>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 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
pgsql-general by date: