Thread: java.sql.SQLException: No suitable driver

java.sql.SQLException: No suitable driver

From
boleguy@adinet.com.uy
Date:
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



Re: java.sql.SQLException: No suitable driver

From
Nelson Arapé
Date:
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)

Re: java.sql.SQLException: No suitable driver

From
Franco Bruno Borghesi
Date:
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 ;-)


2005/5/10, boleguy@adinet.com.uy <boleguy@adinet.com.uy>:
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)