Skip site navigation (1) Skip section navigation (2)

Re: java.sql.SQLException: No suitable driver

From: Nelson Arapé <narape(at)ica(dot)luz(dot)ve>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: java.sql.SQLException: No suitable driver
Date: 2005-05-10 17:32:38
Message-ID: 200505101332.38489.narape@ica.luz.ve (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(at)adinet(dot)com(dot)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(at)postgresql(dot)org)

In response to

pgsql-jdbc by date

Next:From: Franco Bruno BorghesiDate: 2005-05-10 17:38:08
Subject: Re: java.sql.SQLException: No suitable driver
Previous:From: boleguyDate: 2005-05-10 17:24:13
Subject: java.sql.SQLException: No suitable driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group