java.sql.SQLException: No suitable driver

From: boleguy(at)adinet(dot)com(dot)uy
To: pgsql-jdbc(at)postgresql(dot)org
Subject: java.sql.SQLException: No suitable driver
Date: 2005-05-10 17:24:13
Message-ID: 4246295D0005CB56@nfs01.in.adinet.com.uy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nelson Arapé 2005-05-10 17:32:38 Re: java.sql.SQLException: No suitable driver
Previous Message Euler Taveira de Oliveira 2005-05-10 01:55:23 Translation update: pt_BR