Re: [JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Justin Clift
Hi all, I'm not sure, but these are the methods which allow an external application (i.e. an ERD tool) to query a database and know the relationships between the tables aren't they? If so, this is a very important feature which, once implemented properly, will allow Java tools and programs (for

[JDBC] Error: ClassNotFoundException

2001-10-26 Thread Craig Lawton
Hello All, I'm a fairly experienced developer, however, a complete newbie when it comes to using PostgreSQL and JDBC. I have successfully installed PostgreSQL on my Mac G4 running Mac OS X 10.1. I'm able to start the DB daemon (with -i extension), I've created and populated a database (can

Re: [JDBC] JDBC executeUpdate() does not return the number of rows effected

2001-10-26 Thread Barry Lind
Robert, What version of the driver and database are you using? I have code that gets the update count back from executeUpdate(). So I suspect this may be fixed in a more recent version. thanks, --Barry Robert Dyas wrote: > Hi all, > > I have been using the JDBC driver for a couple of mont

[JDBC] JDBC executeUpdate() does not return the number of rows effected

2001-10-26 Thread Robert Dyas
Hi all, I have been using the JDBC driver for a couple of months now. The only limitation I have run into for my own uses is that calling executeUpdate() does not return the number of rows effected by update or delete statement -- it always returns 0. Is this a limitation of Postgresql (i.e. the

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Barry Lind
Ned, This is a community of volunteers. So if someone wants to work on JDBC3 that is fine. We don't have the option of telling people how they should spend their time. But I agree that jdbc2 still has a bunch of stuff that could be done. Although much if what remains undone isn't required b

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26-Oct-2001 Barry Lind wrote: > This is a community of volunteers. So if someone wants to work on JDBC3 > that is fine. We don't have the option of telling people how they > should spend their time. My bad. I didn't mean to alienate. Sorry i

Re: [JDBC] JDBC driver implementation

2001-10-26 Thread Barry Lind
The jdbc driver does not support updateable result sets. If you want to update the data you need to do it the old fashioned way (i.e. use update SQL statements). thanks, --Barry Robinson wrote: > Hello, > > I have a situation where I just want the changes to be made temporarily > in the R

[JDBC] JDBC driver implementation

2001-10-26 Thread Robinson
Hello, I have a situation where I just want the changes to be made temporarily in the ResultSet.   I don't want to commit the changes to the database.   When I use the ResultSet.updateString(...), ResultSet.updateBoolean(...), or ResultSet.updateObject(...) methods;  I get the message "This method

Re: [JDBC] PostgreSQL, JDBC, and Druid

2001-10-26 Thread Dave Cramer
It is a problem with some of the metadata calls, I am looking into it -Original Message- From: Dado Feigenblatt [mailto:[EMAIL PROTECTED]] Sent: October 26, 2001 1:30 PM To: [EMAIL PROTECTED]; pgsql-jdbc; [EMAIL PROTECTED] Subject: PostgreSQL, JDBC, and Druid Hi Rene. Hi Dave. (No, you

Re: [JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Jason Davies
On Fri, Oct 26, 2001 at 09:52:11AM -0700, Barry Lind wrote: > Jason, > > Can you explain what this patch is attempting to fix? Given that we are > in beta with 7.2, I want to fully understand the problem here before > applying this patch. (Especially given that the diff is pretty large and >

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ok, I understand. So, why are people talking about support for JDBC3 where JDBC2 support isn't even there? On 26-Oct-2001 Barry Lind wrote: > Ned, > > It may or may not work. That file hasn't been changed in a long time, > so I doubt anyone is u

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Barry Lind
Ned, It may or may not work. That file hasn't been changed in a long time, so I doubt anyone is using it and therefore it may no longer work. I don't want to give people the false impression that the javax.sql set of extensions to JDBC2 is supported by the jdbc driver by providing a jdbc7.2-

Re: [JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Barry Lind
Jason, Can you explain what this patch is attempting to fix? Given that we are in beta with 7.2, I want to fully understand the problem here before applying this patch. (Especially given that the diff is pretty large and not a one or two line change). Also what testing have you done on this?

[JDBC] PostgreSQL, JDBC, and Druid

2001-10-26 Thread Dado Feigenblatt
Hi Rene. Hi Dave. (No, you don't know me :) I use Druid to design my PG database. I never got the jdbc driver to work. Have you? I'm using this URL jdbc:postgresql://:/ then I get this message Trying to connect... Raised SQL Exception: Message: postgresql.stat.maxfieldsize

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Humm... are you saying that the class PostgresqlDataSource doesn't work? I guess I'm not sure what doesn't work with the driver. (Course, I've been using PoolMan as the datasource to wrap the postgresql default connection rather than using the datas

[JDBC] versions/changelogs

2001-10-26 Thread Glenn Holmer
I'm about to upgrade to the new release of SuSE, which will take me from 7.0 to 7.1 of Postgres. Which is the best JDBC driver to use, and where is the best place to look for a list of what changed between 7.0 and 7.1? -- Glenn Holmer

[JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Jason Davies
Hi, Here is a diff for DatabaseMetaData.getImportedKeys() and DatabaseMetaData.getExportedKeys(). Please check that it works :) Thanks, Jason Davies [EMAIL PROTECTED] Index: jdbc1/DatabaseMetaData.java === RCS file: /projects/cv