Re: [JDBC] Error: ClassNotFoundException
On Fri, 26 Oct 2001 21:34:37 -0600, you wrote: I have successfully installed PostgreSQL on my Mac G4 running Mac OS X 10.1. I have no experience with this platform, but... Class.forName(org.postgresql.Driver); returns the error java.lang.ClassNotFoundException: org.postgresql.Driver. ... typically means that the driver's jar file is not found or cannot be read by the Java runtime. Regards, René Pijlman [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [JDBC] alternative driver jxDBCon
On Wed, 24 Oct 2001 12:58:55 +0200, you wrote: has anyone made some experience using the jdbc driver jxDBCon for PostgreSQL? it is an alternative to the driver released by PostgreSQL. (http://jxdbcon.sourceforge.net) Its been mentioned a couple of times on this list, but I haven't seen any report of anyone actually trying to use it. That's a pitty, because it does look interesting. Regards, René Pijlman [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[JDBC] DatabaseMetaData.getTables()
Hi, There seems to be a problem with DatabaseMetaData.getTables() when I do the following: ResultSet R=conn.getMetaData().getTables(null, null, %, null); It throws a NullPointerException: java.lang.NullPointerException at org.postgresql.jdbc2.DatabaseMetaData.getTables(DatabaseMetaData.java:1732) at Test.main(Test.java:66) Looking at the source, ResultSet.getBytes() is called and it returns null, causing this exception to be thrown. However I can use ResultSet.getString() without a problem. I'm using 7.1.3 at the moment. Does ResultSet.getBytes() need to be fixed or should getTables() be modified? I'd be grateful for any insights. Or you can just tell me to use the latest cvs version of PostgreSQL :) What is the consensus on supporting older versions, will you phase out old code when 7.2 comes out? -- Jason Davies [EMAIL PROTECTED] PGP signature
Re: [JDBC] JDBC executeUpdate() does not return the number of rows effected
Barry, I was using Postgresql V7.1.3 and driver version 7.1-1.2. However, last night I downloaded 7.1-1.2 again and noticed that it was a few K larger, even though it had the exact same version number. When I tested with the new 7.1-1.2 (93,011 bytes vs approx 88K), executeUpdate() *did* return the correct row count. Go figure!? So it appears to be fixed in the newest code base. Thanks, Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Barry Lind Sent: Friday, October 26, 2001 11:27 PM To: Robert Dyas Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] JDBC executeUpdate() does not return the number of rows effected 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 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 backend does not provide this info) or a limitation of the JDBC driver? If it is not a limitation of the backend, does anyone have an idea if this bug would be as easy to fix as it appears on the surface? Rob ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html