[Fwd: Re: JDBC update wont, plz help.] - Mailing list pgsql-hackers

From Vic Cekvneich
Subject [Fwd: Re: JDBC update wont, plz help.]
Date
Msg-id 3BB28D9E.2060703@proj.com
Whole thread Raw
Responses Re: [Fwd: Re: JDBC update wont, plz help.]
List pgsql-hackers
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
driverI>>>could find w/ JDK1.3 and a simple CachedRowSet from SUN Devlopers>>connection.>>>>It will not update via
AcceptChages.>>Erroris This methos is not yet implementd.>>>>Can someone help me update a tabe using JDBC plz? Please
ccvic@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
{>>publicstatic void main (String args[])>>{>>try>>{>>>>CachedRowSet crs = new CachedRowSet();>>// row set is better
thanResultSet,>>// 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("selectNAM from NAM where PK
=?");>>crs.setTableName("NAM");>>// use your field names>>crs.setInt(1, 8);>>>>// pass the first argument to the select
commandto>>// retrieve PK id of Name #8, the 8th name entered>>crs.execute();>>crs.next();>>>>//get the field
value>>Stringnam = 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
fieldnames>>crs.setInt(1, 8);>>// pass the first argument to the select command to>>// retrieve PK id of Name #8, the
8thname 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-hackers by date:

Previous
From: "Rod Taylor"
Date:
Subject: Re: Changing data types
Next
From: Dave Page
Date:
Subject: Re: [ODBC] UTF-8 support