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



Wed, 26 Sep 2001 19:23:26 -0700
Vic Cekvneich <vic@proj.com>
[Fwd: Re: JDBC update wont, plz help.]
On Wed, 26 Sep 2001 19:23:26 -0700, you wrote:
>Itried everywhere.... can't get JDBC to update.

The right place for this question is the
pgsql-jdbc@postgresql.org mailing list.

I think you have a better chance of getting help when you post a
brief description of the problem, instead of the full history of
postings elsewhere. After briefly reading through your posting I
haven't a clue what the problem is. You'd better separate your
problem with the functionality of the driver from build
problems.

Regards,
Renï¿½ Pijlman <rene@lab.applinet.nl>

Thu, 27 Sep 2001 18:17:06 +0200
Rene Pijlman <rene@lab.applinet.nl>
Re: [Fwd: Re: JDBC update wont, plz help.]