Postgres Pro
Downloads
Home   >   mailing lists

Thread: No suitable driver

No suitable driver

From
"Mike Kenny - CPX Mngd Services"
Date:
My code is quite simple
 
try {
    Class.forName("org.postgres.Driver");
} catch(ClassNotFoundException nfe) {
    nfe.printStackTrace();
}
try {
    db = DriverManager.getConnection("jdbc:databasename", "id", "password");
} catch(SQLException se) {
    se.printStackTrace();
}
 
on execution I receive a SQLException stating that there is no suitable driver
 
This is my first time trying to connect to postgreSQL and I am stuck.
 
Any advice appreciated (career change is not an option :-)

Mike Kenny 
Principal Consultant
Comparex Africa (Pty) Ltd
Managed Services
* e-mail: mike.kenny@comparex.co.za
( Tel(W): +27 (0)11 266-5703
È Cell:     +27 (0)83 266-1437
NOTICE: This message and any attachments are confidential and intended solely for the addressee.  If you have received this message in error, please notify Dave Gilbert at Comparex Africa (Pty) Ltd immediately, telephone number +27 (0) 11 266 5204.  Any unauthorised use, alteration or dissemination is prohibited.  Comparex Africa (Pty) Ltd accepts no liability whatsoever for any loss whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.

 

Re: No suitable driver

From
"Nick Fankhauser"
Date:
Mike-

It looks to me like your URL for the connection is malformed. It should be
one of the following:

jdbc:postgresql:databasename
jdbc:postgresql://host/databasename
jdbc:postgresql://host:port/databasename


Take a look at this FAQ for more (There is also a "helloworld" example that
may be useful in the FAQ):

http://www.fankhausers.com/postgresql/jdbc/#nosuitabledriver


-Nick



-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Mike Kenny - CPX Mngd
Services
Sent: Thursday, October 23, 2003 4:55 AM
To: JDBC (E-mail)
Subject: [JDBC] No suitable driver


My code is quite simple

try {
    Class.forName("org.postgres.Driver");
} catch(ClassNotFoundException nfe) {
    nfe.printStackTrace();
}
try {
    db = DriverManager.getConnection("jdbc:databasename", "id", "password");
} catch(SQLException se) {
    se.printStackTrace();
}

on execution I receive a SQLException stating that there is no suitable
driver

This is my first time trying to connect to postgreSQL and I am stuck.

Any advice appreciated (career change is not an option :-)
Mike Kenny
Principal Consultant
Comparex Africa (Pty) Ltd
Managed Services
* e-mail: mike.kenny@comparex.co.za
( Tel(W): +27 (0)11 266-5703
È Cell:     +27 (0)83 266-1437
NOTICE: This message and any attachments are confidential and intended
solely for the addressee.  If you have received this message in error,
please notify Dave Gilbert at Comparex Africa (Pty) Ltd immediately,
telephone number +27 (0) 11 266 5204.  Any unauthorised use, alteration or
dissemination is prohibited.  Comparex Africa (Pty) Ltd accepts no liability
whatsoever for any loss whether it be direct, indirect or consequential,
arising from information made available and actions resulting there from.

Re: No suitable driver

From
Paul Thomas
Date:
On 23/10/2003 10:54 Mike Kenny - CPX Mngd Services wrote:
> My code is quite simple
>
> try {
>     Class.forName("org.postgres.Driver");

It's org.postgresql.Driver

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+