Subject Re: [Firebird-Java] Table names and Column Names
Author David Jencks
Could you try the cvs version of the java driver? I think Roman fixed
these problems a day or two ago.

thanks
david jencks

On 2002.10.20 14:44:41 -0400 jddemme wrote:
> 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@...
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>