Re: java.sql.SQLException: No suitable driver
От | Nelson Arapé |
---|---|
Тема | Re: java.sql.SQLException: No suitable driver |
Дата | |
Msg-id | 200505101332.38489.narape@ica.luz.ve обсуждение исходный текст |
Ответ на | java.sql.SQLException: No suitable driver (boleguy@adinet.com.uy) |
Список | 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@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)
В списке pgsql-jdbc по дате отправления: