Found this:

http://groups.yahoo.com/group/Firebird-Java/message/2377

as far as i understood developers thought what to do with getXXX()
methods, but i have problems before getting the field but with
passing a query to the server like this:

String q = "select \"met\".id, iddt, changetime, code from \"met\" " +
"inner join \"code\" on \"met\".id=\"code\".id where code = '" +
cdmet + "'";
Statement s = c.createStatement();
ResultSet r = s.executeQuery(q);

it says on executeQuery

Column unknown
met.ID

before this i've escaped double quotes around all column names like
this

String q = "select \"met\".\"id\", \"iddt\"......... etc

the result was the same!

(when used without any doublequotes, it said "Table unknown MET".)

the database has _all_ identifiers, table and fieldname, in
lowercase. i think i'll regret it :(

still hope there is some modifier property, or i should rewrite all
the database!...


--- In Firebird-Java@yahoogroups.com, "feddkraft" <feddkraft@y...>
wrote:

> Hi,
>
> tried to search archive but failed.
>
> one little question: may i not quote every name of an every table

and

> view? maybe there is some property that prevents uppercaseing all

my

> queries. all tables are named in lower case in my base.
>
> thankyou
> Fedd