From: | "Tom Harden" <tharden(at)bellsouth(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | JDBC problems |
Date: | 2002-07-29 17:23:30 |
Message-ID: | zGe19.73633$Og3.16916915@e3500-atl1.usenetserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
Being a PostgreSQL newbie, I hope my ignorance can be overlooked, this time
anyway.
I have PostreSQL 7.2 loaded and running on SuSE 8.0 linux distribution. The
database seems to be behaving as expected using psql as a frontend. I'm
trying to develop some JDBC apps on a Win2000 machine using NetBeans 3.1 as
the java IDE. This is how I have configured PostgreSQL.
1. I have set "tcpip_socket=true", "port=5432" in the
/var/opt/pgsql/data/postgresql.conf.
2. I have added the following line to the pg_hba.conf file:
host all 192.168.1.0 255.255.255.0 trust
postgresql has been restarted since these changes were made.
3. A user has been created for myself, w/o a password. I can run psql and
attach to the target database on the server host.
4. I have retreived the pgjdbc2.jar file and installed in the NetBeans
Filesystem and appears to be seen as part of the CLASS_PATH. App compiles
without errors and executes Class.forName() with no error.
5. My simple application successfully performs the
Class.forName("org.postgresql.Driver") method.
6. When it gets to the following line
Connection connection =
DriverManager.getConnection("jdbc:postgresql://maizy:5432/mytestdb?user=thar
den");
an SQLException is thrown the ultimately yields "No suitable driver" as
its message.
I have tried several variations of the connection string and always recieve
the same exception.
Any help would be appreciated.
Thanks in advance
Tom Harden
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Nelson | 2002-07-29 17:34:31 | Importing data |
Previous Message | Amin Abdulghani | 2002-07-29 17:22:25 | Re: postgres 7.2.1 parse bug |