Re: SQL Error JDBC

On Tue, 23 Feb 1999, Administration wrote:

> I have postgresql running in linux on a network, and I have a sample
> program in windows. When I run the following
>
> java -classpath .;c:\jdk1.2\lib\postgresql.jar test
>
> I get this error
>
> sqlexception: no suitable driver
>
> Any ideas??

You still need to load the driver, using something like:

try {
Class.forName("postgresql.Driver");
} catch(Exception ex) {
ex.printStackTrace();
System.exit(1);
}

> Henry
>
> Here's my code(i'm pasting it because it's short:)
> ---------------------------------------------------------------------------------------
>
> import java.sql.*;
>
>
> public class test {
> public static void main(String args[]) {
> String url = "jdbc:postgres95://isorintrade.ca:5432/ra";
> Connection con;
> String createString;
> createString = "create table COFFEES " +
> "(COF_NAME VARCHAR(32), " +
> "SUP_ID INTEGER, " +
> "PRICE FLOAT, " +
> "SALES INTEGER, " +
> "TOTAL INTEGER)";
> Statement stmt;
>
> try {
> Class.forName("postgresql.Driver");
> } catch(java.lang.ClassNotFoundException e) {
> System.err.print("ClassNotFoundException: ");
> System.err.println(e.getMessage());
> }
>
> try {
> con = DriverManager.getConnection(url, "postgres",
> "feb_1b42");
> stmt = con.createStatement();
> stmt.executeUpdate(createString);
> stmt.close();
> con.close();
>
> } catch(SQLException ex) {
> System.err.println("SQLException: " + ex.getMessage());
> }
> }
> }
>
>

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf