Обсуждение: 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 following message:

"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

<fontfamily><param>Helvetica</param>

--

Thiemo Kellner

Tösstalstrasse 146

CH-8400 Winterthur

</fontfamily>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 following message:
"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

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