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