Column names getting lower-case in SELECT statements when issued via JDBC

Поиск
Список
Период
Сортировка
От Eduardas F.
Тема Column names getting lower-case in SELECT statements when issued via JDBC
Дата
Msg-id BANLkTimgO_Be+WVW0qTnX8ZrGwbtvSXqhw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Column names getting lower-case in SELECT statements when issued via JDBC
Re: Column names getting lower-case in SELECT statements when issued via JDBC
Список pgsql-general
Hello everyone, today I encountered this nasty problem:
Whenever you issue an SELECT command from JDBC (prepared statement) you end up with column X does not exist. And column X name is shown in lower-case  As I understand, PostgreSQL Server or PostgreSQL JDBC driver converts column names containing upper-case letters to lower-case? Is there an easy way to bypass this behaviour? (Channing column names is not an option).


Here's an example of crashing SELECT: "SELECT password, accessLevel, lastServer, userIP FROM accounts WHERE login=?"
You end up with 'column "accesslevel" does not exist'.

Thanks for help in advance.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tarlika Elisabeth Schmitz
Дата:
Сообщение: Re: Role for CSV import
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Column names getting lower-case in SELECT statements when issued via JDBC