Re: BUG: DatabaseMetaData.getColumns isn't case insensitive
От | Dave Cramer |
---|---|
Тема | Re: BUG: DatabaseMetaData.getColumns isn't case insensitive |
Дата | |
Msg-id | 491f66a50902021332w66598e8fhe6a2ed5b3a3ad8d1@mail.gmail.com обсуждение исходный текст |
Ответ на | BUG: DatabaseMetaData.getColumns isn't case insensitive (maly.velky@email.cz) |
Список | pgsql-jdbc |
Shouldn't you quote the column in question if you want to get a MixedCase quoted column ?
Dave
Dave
On Mon, Feb 2, 2009 at 8:39 AM, <maly.velky@email.cz> wrote:
Hello,
I'was trying to get meta data of a column and discovered that the column name is case sensitive though it should be case insensitive. I don't know if this can be somehow determined by a configuration or environment change because I believe that till recently it worked in a case-insensitive manner.
I've the table studna_monitor.mon_user_session with the column "username". The following code wrongly returns null (notice "username".toUpperCase()):
---
String col = null;
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost/mydb?user=me&password=secret";
Connection conn = DriverManager.getConnection(url);
DatabaseMetaData databaseMetaData = conn.getMetaData();
ResultSet columnsMD = databaseMetaData.getColumns(null, "studna_monitor", "mon_user_session", "username".toUpperCase());
while(columnsMD.next()) {
col = columnsMD.getString("COLUMN_NAME");
}
return col;
---
While the following returns the column name "username":
---
...
ResultSet columnsMD = databaseMetaData.getColumns(null, "studna_monitor", "mon_user_session", "username".toLowerCase());
...
---
BTW, the metadata reports:
supportsMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: true
(which is pretty much expected)
Driver: postgresql-8.3-604.jdbc3.jar, postgresql-jdbc3-8.2.jar (as distributed with Ubuntu, doesn't provide build number)
Server: Postgres 8.2.6 for Solaris
Thank you.
Jakub Holy
maly.velky@email.cz
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
В списке pgsql-jdbc по дате отправления: