I'm not sure if this is a Firebird, Coldfusion, or JDBC driver issue... but I'll try.
Have a Firebird DB that I just connected in Coldfusion with the latest JDBC firebird driver available.
The tables/columns names in the Firebird DB have mixed case. Coldfusion can see any tables named in ALL Caps (ColdFusion generated SQL: SELECT * FROM SLR). Coldfusion can see some tables with mixed case naming and will (by default) include double quotes around the table name in Coldfusion-generated SQL (SELECT * FROM "User"). However, for most tables, the double quotes are omitted from the Coldfusion generated SQL and Coldfusion instead interprets the names as ALL caps when in fact they are mixed case, causing an error:
-1:GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -204
Table unknown
CHALLENGE [the table name is actually Challenge]
I would venture to say this is a Coldfusion quirk if tables with ALL caps worked and all other mixed case tables did not. But some of the mixed case named tables DO work and Coldfusion interprets them correctly and automatically applied double quotes to enforce case sensitivity.
Why would some tables work with mixed case while others do not?! Could it be something in the creation of the Firebird database? Could it be a problem in translation by the JDBC driver?
