Thread: JDBC SQL command problems

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

> 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?
>

Have you tried to run your query just under the psql program?  That is the
first thing you should check, because if it fails there it will certainly
fail in your program.  Also, you will be getting rid of all the complexity
of java so you can concentrate on getting the query to work.  Once it is
working in psql, or if it does the first time you try, then its time to take
a real close look at your code.

That's just standard tech support for product x though, I hope it
helps...james

P.S. Just off the bat it looks like your query is missing a ';' at the
end...it kill you in C, and it will kill you in SQL.