Maybe just a typo:
URL: jdbc:postgresql//192.168.0.253:8000/template1
but you need a colon after 'postgresql' e.g. 'jdbc:postgresql://...' as JDBC will parse the URL looking for the
'postgresql'and not find it... your TCP port number should be fine to leave at 8000 (begs the question why tho ;) as
longas its reflected in the URL, but if you want to change it, put this (or uncomment it) in the postgresql.conf file:
port = 5432
Cheers,
Joe
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of thiemo
Sent: Wednesday, 13 March 2002 18:10
To: pgJDBC; pgGeneral
Subject: [JDBC] DBvisualizer on MacOS X
Hello,
I try to connect to a PostgreSQL 7.2 db with DB-Visualizer 2.1 on MacOS X (well , the DB is on SuSE), but get the
followingmessage:
"No suitable driver.
There is no driver that can handle a connection for the
specified URL. The most common reason is that the driver
is not in the CLASSPATH or among the list of dynamically
loaded drivers. Also check that the URL is correct spelled."
My settings are:
"Database Alias: Template1
JDBC Driver: org.postgresql.Driver
URL: jdbc:postgresql//192.168.0.253:8000/template1
Userid
postgres
pasword *****"
I have loaded, as can be seen, the jdbc driver. But couldn't find the file dbvis.lax to integrate it into its class
path.BTW, I have compiled postgres myself with option port 8000. Does anyone happen to know how I can fix this?
Thx
Thiemo
--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur