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

Started by Vic Cekvneichover 24 years ago2 messages

vic@proj.com

over 24 years ago

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();

Show quoted text

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)

Rene Pijlman

rene@lab.applinet.nl

over 24 years ago

In reply to: Vic Cekvneich (#1)

Re: [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>