[JDBC] postgresql ID

2001-08-17 Thread Luís Henriques
Hi! I'm working in a java application that will used a database, but I'm trying to support a couple of different DBMS (postgres, oracle, ...). My question is: Is there a way to be sure that the database that the application is using in a specific moment is really a postgres database? Thanks!

Re: [JDBC] postgresql ID

2001-08-17 Thread Rene Pijlman
On Fri, 17 Aug 2001 11:13:12 +0100, you wrote: >Is there a way to be sure that the database that the application >is using in a specific moment is really a postgres database? DatabaseMetaData.getDatabaseProductName() returns "PostgreSQL". I can't guarantee that other products won't do the same

[JDBC] Unable to connect to database

2001-08-17 Thread Peter Rogers
Please have mercy on this poor beginner! I am totally new to both postgresql and jdbc, so I'm probably committing some very basic error, but I am unable to make a connection to my database via jdbc. I am using postgresql 7.1.2 which seems to be running OK (under Suse Linux 7.1); at least I can

RE: [JDBC] Unable to connect to database

2001-08-17 Thread Whitney Hunter
Peter, I believe that the url format is "jdbc.postgresql:///". This could be the problem. Whitney -Original Message- From: Peter Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:27 PM To: [EMAIL PROTECTED] Subject: [JDBC] Unable to connect to database Please have merc

RE: [JDBC] Unable to connect to database

2001-08-17 Thread Dave Cramer
Peter, Do you have any other problems running java on this machine. The only reason you should ever get a segmentation fault with java is if the jvm is buggy. What jvm are you using. I know there are issues running sun's jvm on newer distributions. Dave -Original Message- From: [EMAIL

Re: [JDBC] Unable to connect to database

2001-08-17 Thread Liam Stewart
On Fri, Aug 17, 2001 at 11:00:40AM -0700, Whitney Hunter wrote: > I believe that the url format is "jdbc.postgresql:///". This > could be the problem. Nope, that isn't the problem. The url format is correct. (assuming of course that the database that Peter is connecting to is running on his comp

Re: [JDBC] Unable to connect to database

2001-08-17 Thread Rene Pijlman
On Fri, 17 Aug 2001 15:11:57 -0400, you wrote: >Try a newer JDBC driver (from CVS). Standard support answer #1 :-) The driver is AFAIK 100% pure Java. I don't think there is a fix for a JVM segmentation fault in the driver, do you? >the problem could be your JVM That's better advice :-) Seri

Re: [PATCHES] Re: [JDBC] JDBC pg_description update needed for CVS tip

2001-08-17 Thread Bruce Momjian
Applied. Thanks. > Attached is the patch requested by Tom Lane (see below). It > includes two changes in the JDBC driver: > > 1) When connected to a backend >= 7.2: use obj_description() and > col_description() instead of direct access to pg_description. > > 2) In DatabaseMetaData.getTables()