Subject Table names and Column Names
Author jddemme
I'm having a problem resolving two issues:

First, on my friend's set-up, running the following works:
SELECT * FROM test;

On my system, I have to use:
SELECT * FROM "test";

Which is a real eyesore in Java since you have to use the escape
character(\)

The only difference, as far as we can tell, is that I originally had
IB installed instead of FB. I've uninstalled and deleted the
directory, and reinstalled FB, but that didn't do it. My thinking now
is that this may be an issue with use using difference dialects, as I
don't know whether he's using 1 or 3.

My next problem is that when I try to use a column name in resultset,
it puts it all in CAPS. ie, I run
out.println(rs.getString("User"));
and it looks for the column name USER. When I rename the column name
to USER, it works correctly. This was also not an issue on my friend's
machine. Currently, I'm using FirebirdSQL 1.0 RC1a, and Firebird 1.5
alpha 2 on Windows XP. These were also issues with Firebird 1.0 Final.


Thanks in advance for any help,
John Demme
me@...