Subject Re: How do I use quoted fields?
Author rrokytskyy
> Thanks Roman. But see my earlier email, it means changing a lot of
> code. More than a 1000 classes worked on by 100 developers. I was
> researching on replacing the Access database with Firebird. But
> encountered problems during conversion, as SQL2GDB converted my
> password field to passwordcol. Hence the problems of quoted fields
> etc.

What about automated replacement? Also, you might want to store all
statements in resource bundles. JBuilder can help you in this task.

Also as a workaround you might implement java.sql.Connection
interface in a proxy class that will check if there's passwordcol in
the statement and replace it with \"password\" and delegate the call
to JDBC driver. If you are using JDK 1.3 or later you might want to
have a look on java.lang.reflect.Proxy class, this might simplify you
life in this task. There's a good tutorial on Sun about using this
class (it was one of JDC Tech Tips).

Anyway, qouted identifiers are more or less standard in SQL, so you
might need to do this task later if you switch to other database

Best regards,
Roman Rokytskyy