Re: java.sql.SQLException: No suitable driver

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)