SQL Error JDBC
От | Administration |
---|---|
Тема | SQL Error JDBC |
Дата | |
Msg-id | 36D373C9.CFFF0BCA@isorintrade.ca обсуждение исходный текст |
Ответы |
Re: SQL Error JDBC
|
Список | pgsql-interfaces |
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?? 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()); } } }
В списке pgsql-interfaces по дате отправления: