JDBC problems

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

Browse pgsql-general by date

  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