Hi,

I am currently migrating my database from MS Access to postgreSQL or MySQL.
I am accessingthe databse using a program written in Java. I have all
necessary drivers installed/initialised etc. My server program starts and
connects to the database fine. The problem occurs when I start my client
program, which runs a SQL command to read the database and populate a JTree.
When I migrated to MySQL no changes to my code/SQL commands were necessary
but when the client starts using postgreSQL it errors out at the line
accessing the DB with the following error.

java.sql.SQLException: ERROR: column "groupid" does not exist .

The column does exist but the actual name of the column is 'groupID' (with
last two chars. in upper case) and it is of type int4. Are there any
case-sensitive issues I should take into account here?

This line ( and all SQL commands) cause no problems when using MS Access and
MySQL. The database was created by exporting the database from MS Access.

Many Thanks,

Brian