Thread: JDBC Connection

JDBC Connection

From

Eric Wright

Date:

11 July 2004, 21:38:39

Hello,

I am having some trouble connecting to my postgres database.

I have started off with a simple test class to make and test a connection. When I run the simple tester I am getting the following output:

    The connection failed.
    java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getConnection(DriverManager.java:532)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at app.dao.ConnectionTest.main(ConnectionTest.java:28)

From the following test class:

package app.dao;
import java.sql.*;

public class ConnectionTest {
public static void main(String[] args) {
  String url    = "jdbc:postgres://192.168.1.101/asset";
  String user   = "asset$admin";
  String pwd    = "password";
  try {
   Class.forName("org.postgresql.Driver");
   Connection con = DriverManager.getConnection(url, user, pwd);
   if(!con.isClosed()){
    System.out.println("The connection succeeded");
    con.close();
   }
  }catch(Exception e){
   e.printStackTrace();
   System.out.println("The connection failed.");
  }
}
}

I have read the information at http://www.fankhausers.com/postgresql/jdbc/#nosuitabledriver

I am using Eclipse 3.0 and trying it run it in the debugger.

I am using postgresql 7.4, JDK 1.4, and pg74.214.jdbc3.jar

Any help that you can provide would be great.

Thanks Eric W

Re: JDBC Connection

From

Kris Jurka

Date:

12 July 2004, 01:54:19


On Sun, 11 Jul 2004, Eric Wright wrote:

> Hello,
>
> I am having some trouble connecting to my postgres database.  I have
> started off with a simple test class to make and test a connection. When
> I run the simple tester I am getting the following output:
>
>     The connection failed.
>     java.sql.SQLException: No suitable driver
>   String url    = "jdbc:postgres://192.168.1.101/asset";

The URL must start with jdbc:postgresql not postgres.

Kris Jurka

Re: JDBC Connection

From

Eric Wright

Date:

12 July 2004, 06:19:03

Thanks Kris,  my bad...

I will put on the pointy hat and sit in the corner until the end of class.

Eric


----- Original Message -----
From: "Kris Jurka" <books@ejurka.com>
To: "Eric Wright" <eric.wright@shaw.ca>
Cc: <pgsql-jdbc@postgresql.org>
Sent: Sunday, July 11, 2004 6:54 PM
Subject: Re: [JDBC] JDBC Connection


>
>
> On Sun, 11 Jul 2004, Eric Wright wrote:
>
> > Hello,
> >
> > I am having some trouble connecting to my postgres database.  I have
> > started off with a simple test class to make and test a connection. When
> > I run the simple tester I am getting the following output:
> >
> >     The connection failed.
> >     java.sql.SQLException: No suitable driver
> >   String url    = "jdbc:postgres://192.168.1.101/asset";
>
> The URL must start with jdbc:postgresql not postgres.
>
> Kris Jurka
>