JDBC update wont, plz help.
От | Vic Cekvenich |
---|---|
Тема | JDBC update wont, plz help. |
Дата | |
Msg-id | 3BB1FD68.6000700@proJ.com обсуждение исходный текст |
Список | pgsql-general |
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 > > ---------------
В списке pgsql-general по дате отправления: