JDBC SQL command problems
От | Jeffrey Napolitano |
---|---|
Тема | JDBC SQL command problems |
Дата | |
Msg-id | 359BBA75.7FF712ED@setech.com обсуждение исходный текст |
Список | pgsql-general |
I've compiled and installed the JDBC driver for Postgresql - Now I'm attempting to make the connection work, and pass a CREATE command to postgres. My database name is "bugs", the user connecting is "java", and its running on my local machine on port 5432. I am consistently getting a "The SQL Exception was thrown" ... after changing things around, I still get the same result. I've been reading "JDBC Database Access with Java" by Hamilton, Cattell, and Fisher, and their example doesn't work. Help? ---------------------------------- public class JDBC_Connection { public static void main(String[] args) { String url = "jdbc:postgresql?user=java://localhost:5432/bugs"; Connection con; String createString; createString = "create table STUFF " + "(NAME varchar(30), " + "YOUR_MOM int)"; Statement stmt; try { Class.forName("postgresql.Driver"); } catch(ClassNotFoundException except) { System.out.println("ClassNotFound: didn't work"); } try { con = DriverManager.getConnection(url); stmt = con.createStatement(); stmt.executeUpdate(createString); stmt.close(); con.close(); catch(SQLException sqlexcept) { System.out.println("The SQL Exception was thrown"); } } //End of main in JDBC_Connection class } //End of JDBC_Connection class bracket
В списке pgsql-general по дате отправления: