Skip site navigation (1) Skip section navigation (2)

Postgresql and JDBC

From: Wayne Johnson <wdtj(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Postgresql and JDBC
Date: 2001-01-29 15:53:47
Message-ID: 20010129155347.25890.qmail@web2306.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc
I've got some questions on using POSTGRESQL with JDBC.  Some folks on the
Novice mailing list suggested I use the interfaces mailing list, but the
web site suggests that I should use another.  Which mailing list is
appropriate.

I would like to do a read & update of a single record.  I've seen several
examples of using JDBC to update an entire table, but I'm only looking to
modify a single record.

Is this a case where I should use getCursorName?  How do I then do an
UPDATE to only modify that single record?  Is this multi user safe?  I've
tried the JDBC 2.0 updateXXX functions, but they are apparently not
implemented for Postgresql yet.

Are there any good (in depth) examples of JDBC out there?  The only ones
I've seen are limited to a simple SELECT or UPDATE.

Thanks.

BTW, my complements to the POSTGRESQL developers on a nice product.




=====
Wayne Johnson,             | There are two kinds of people: Those 
3943 Penn Ave. N.          | who say to God, "Thy will be done," 
Minneapolis, MN 55412-1908 | and those to whom God says, "All right, 
(612) 522-7003             | then,  have it your way." --C.S. Lewis

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/

Responses

pgsql-interfaces by date

Next:From: Barry LindDate: 2001-01-29 18:22:14
Subject: Re: [INTERFACES] jdbc: v7.1 bug (letter accent)
Previous:From: Jean-Francois BurdetDate: 2001-01-29 11:11:14
Subject: jdbc: v7.1 bug (letter accent)

pgsql-jdbc by date

Next:From: Tatsuo IshiiDate: 2001-01-29 17:17:38
Subject: Re: Open 7.1 items
Previous:From: Richard Bullington-McGuireDate: 2001-01-29 15:27:34
Subject: Re: to much process

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group