Re: query not working with JDBC driver

You are connected to a Postgres data base, but are you sure you connect
to the right one ?
The error you see means the "cities" table does not exist. It also could
be that you have a "CITIES" table - beware that postgres is case
sensitive under certain circumstances. Are you sure you typed the query
exactly the same way in pgadmin ?
My bet would be though that you connect to a different database or
schema with pgadmin than with Java :-)

HTH,
Csaba.


On Tue, 2004-12-14 at 15:52, Jeffrey A Cheak wrote:
>
>
> Hi everyone,
>
> I'm stuck on a little problem with what may be the JDBC driver or that I
> don't fully understand the SQL syntax.  I am connecting to the PostGreSQL
> database with the JDBC Driver for PostGreSQL.  When I run the following
> command, I get this:
>
> (java code) :
>  String query = "SELECT version( )";
> ResultSet rs = st.executeQuery(query);
>
> (output from standard output) :
>  Column Returned PostgreSQL 8.0.0beta5 on i686-pc-mingw32, compiled by GCC
> gcc.exe (GCC) 3.3.1 (mingw special 20030804-1)
>
>
> I assume that the output is a good sign...meaning I am connected to the
> database and can "communicate" with it.  Although, when I try to do a
> simple SQL query on a table, I get an error.  The table "cities" does
> exist, because I can see it when I use pgAdminIII, in addition, when I use
> pgAdminIII, I am able to click on the SQL query icon(bring up a new window)
> and perform the simple SQL query from there.
>
> (java code):
> String query = "SELECT * FROM cities";
> ResultSet rs = st.executeQuery(query);
>
>
> (output from standard output):
> Error somewhere in the query: java.sql.SQLException: ERROR: relation
> "cities" does not exist
>
> If anyone could help shed some light on this I would be very thankful.
> Again, I apologize if this is not the best place to post this question.(I'm
> not sure what category it best falls under)
>
> Thank you all again and kind regards,
> Jeffrey
>
>
> ----------------------------------------------------------------------------------------
>
> This is a PRIVATE message. If you are not the intended recipient, please
> delete without copying and kindly advise us by e-mail of the mistake in
> delivery. NOTE: Regardless of content, this e-mail shall not operate to
> bind CSC to any order or other contract unless pursuant to explicit written
> agreement or government initiative expressly permitting the use of e-mail
> for such purpose.
> ----------------------------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html