Count(*) returns 'Column 'Count' not found' SQLException
I am trying to get the count from a table using the following:
String query = "SELECT COUNT(*) FROM myTable;"
I know that the connection is open and working because I am getting back an SQLException:
'Column 'Count' not found' .
The same command works fine at the command line. I would be grateful for any suggestions as to why JDBC sends my app searching for a field named count in my table whereas the command line returns the expected number.
Thanks.

