| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Matthew Hixson <hixson(at)poindextrose(dot)org> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes |
| Date: | 2006-01-28 00:31:23 |
| Message-ID: | Pine.BSO.4.61.0601271926440.10644@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron St-Pierre | 2006-01-28 01:54:00 | Re: Importing Many XML Records |
| Previous Message | Matthew Hixson | 2006-01-28 00:20:38 | Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes |