Can anyone explain why persistence providers like Toplink and Hibernate would bring up the same exception with this DB even though the database name (Test) is correct.
Is there a way to setup the persistence provider so that it can insert double quotes around both the connection string and all query strings? If the database name is ALL in uppercase then there is no problem, however it appears as though additional problems can occur if non uppercase names are used for tables, databases, columns etc with any persistence provider . Attached is a text file containing the program's output.
In the meantime low level JDBC will have to be used to work around this problem as a temporary precaution.