Thread: java.sql.SQLException: No suitable driver

HI:
I'M TRYING TO CONNECT AN ECLIPSE 3.01 IDE RUNNING ON WINDOWS XP WITH A DB
POSTGRESQL VERSION 7.4.7. I USED THE FOLLOWINGS DRIVERS: PG.74.213/4/5/6.JDBC3.JAR
AND NO ONE WORKS.

THE MESSAGE WAS THE FOLLOWING:
Cargando clase
IWAV0055I Java Bean frenchconn.connpost started with the main method
java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at frenchconn.connpost.agregarCliente(connpost.java:33)
    at frenchconn.connpost.main(connpost.java:69)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.ve.internal.java.vce.launcher.remotevm.JavaBeansLauncher.main(JavaBeansLauncher.java:86)

AND THE CODE (MY CODE):

import java.sql.*;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

//import samples.jdbc.JDBCTest;


/**
 * @author Benjamin
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class connpost {

    static {
        System.out.println("Cargando clase");
      }

     public void agregarCliente(long idCliente,
               String nombre) {
             try {
               String url = "jdbc:postgres://172.16.100.110:5432/benjamin";
               Connection conn = null;
               conn = DriverManager.getConnection(url,"benjamin", "benja1");
              DriverManager.getDriver("org.postgresql.Driver");

               String sql =
                 "INSERT INTO Cliente " +
                 "(IdCliente, Nombre) " +
                 "VALUES (?,?)";

               PreparedStatement ps =
                 conn.prepareStatement(sql);

               ps.setLong(1, idCliente);
               ps.setString(2, nombre);

               ps.executeUpdate();

               ps.close();

               conn.close();

               System.out.println("Cliente insertado OK");
             }
             catch (Exception ex) {
               ex.printStackTrace();
             }
           }

    public static void main(String[] args) {

        try {
              // Cargo el driver JDBC de postgres
              Class.forName("org.postgresql.Driver");

              connpost conn = new connpost();
              //jdbcTest.agregarCliente(1, "Pepe");
              //jdbcTest.agregarCliente(2, "Juan");
              conn.agregarCliente(123,"pepe");

//              jdbcTest.transaccion();
            }
            catch (Exception ex) {
              ex.printStackTrace();
            }
    }
}


THANKS FOR EVERYTHING TO ANYONE

BENJAMIN

Probably it is a classpath isue, Are you sure that the driver's jar is in the
classpath of the project?

Bya
Nelson Arapé

El Mar 10 May 2005 13:24, boleguy@adinet.com.uy escribió:
> HI:
> I'M TRYING TO CONNECT AN ECLIPSE 3.01 IDE RUNNING ON WINDOWS XP WITH A DB
> POSTGRESQL VERSION 7.4.7. I USED THE FOLLOWINGS DRIVERS:
> PG.74.213/4/5/6.JDBC3.JAR AND NO ONE WORKS.
>
> THE MESSAGE WAS THE FOLLOWING:
> Cargando clase
> IWAV0055I Java Bean frenchconn.connpost started with the main method
> java.sql.SQLException: No suitable driver
>     at java.sql.DriverManager.getConnection(Unknown Source)
>     at java.sql.DriverManager.getConnection(Unknown Source)
>     at frenchconn.connpost.agregarCliente(connpost.java:33)
>     at frenchconn.connpost.main(connpost.java:69)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>     at java.lang.reflect.Method.invoke(Unknown Source)
>     at
> org.eclipse.ve.internal.java.vce.launcher.remotevm.JavaBeansLauncher.main(J
>avaBeansLauncher.java:86)
>
> AND THE CODE (MY CODE):
>
> import java.sql.*;
> import java.sql.DriverManager;
> import java.sql.PreparedStatement;
>
> //import samples.jdbc.JDBCTest;
>
>
> /**
>  * @author Benjamin
>  *
>  * TODO To change the template for this generated type comment go to
>  * Window - Preferences - Java - Code Style - Code Templates
>  */
> public class connpost {
>
>     static {
>         System.out.println("Cargando clase");
>       }
>
>      public void agregarCliente(long idCliente,
>                String nombre) {
>              try {
>                String url = "jdbc:postgres://172.16.100.110:5432/benjamin";
>                Connection conn = null;
>                conn = DriverManager.getConnection(url,"benjamin", "benja1");
>               DriverManager.getDriver("org.postgresql.Driver");
>
>                String sql =
>                  "INSERT INTO Cliente " +
>                  "(IdCliente, Nombre) " +
>                  "VALUES (?,?)";
>
>                PreparedStatement ps =
>                  conn.prepareStatement(sql);
>
>                ps.setLong(1, idCliente);
>                ps.setString(2, nombre);
>
>                ps.executeUpdate();
>
>                ps.close();
>
>                conn.close();
>
>                System.out.println("Cliente insertado OK");
>              }
>              catch (Exception ex) {
>                ex.printStackTrace();
>              }
>            }
>
>     public static void main(String[] args) {
>
>         try {
>               // Cargo el driver JDBC de postgres
>               Class.forName("org.postgresql.Driver");
>
>               connpost conn = new connpost();
>               //jdbcTest.agregarCliente(1, "Pepe");
>               //jdbcTest.agregarCliente(2, "Juan");
>               conn.agregarCliente(123,"pepe");
>
> //              jdbcTest.transaccion();
>             }
>             catch (Exception ex) {
>               ex.printStackTrace();
>             }
>     }
> }
>
>
> THANKS FOR EVERYTHING TO ANYONE
>
> BENJAMIN
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

ok, but you don't need to shout! :P

Two things:

1)have you added your jar to the project's java build path? (if you did, go to the second) right click on the project name, select Properties, go to Java Build Path, go to the Libraries tab, click Add External Jars and find your pgxxxxxxxxxx.jar

2) be sure to load the driver first doing a Class.forName("org.postgresql.Driver"); in your code. Also check your url, it should be "jdbc: postgresql://172.16.100.110:5432/benjamin"

If it works, have a mate for me ;-)