[Fwd: Re: JDBC update wont, plz help.]

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 <vic(at)proj(dot)com>
Organization: Hub.Org Networking Services (http://www.hub.org)
Newsgroups: comp.databases.postgresql.general
References: <3BB1FD68(dot)6000700(at)proJ(dot)com>

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(at)proj(dot)com(dot)
>>
>>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 majordomo(at)postgresql(dot)org)
>