Re: [GENERAL] 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?
>

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.