On Fri, 27 Jan 2006, Matthew Hixson wrote:
The problem is that the JDO layer is looking for the table name in a system
table like so:
When using DatabaseMetaData calls to determine what tables and columns are
available you must be aware of what case the search terms need to be
passed in with. You must know if your tables were created with or
without quotes, but then you can use the DatabaseMetaData methods
stores[XXX]Case[Quoted]Idetifiers() to determine what case to pass
parameters to methods like getTables(). It's unclear what control (if
any) you have over this, but that's how it's supposed to work.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
