My query table aliases don't exist in my application

Поиск
Список
Период
Сортировка
От Hugo Garza
Тема My query table aliases don't exist in my application
Дата
Msg-id AANLkTimBHzeWSsKxC7ZhziKiehCmCgyiUdD3Q76yNrSy@mail.gmail.com
обсуждение исходный текст
Ответы Re: My query table aliases don't exist in my application
Список pgsql-jdbc
Hello everyone,

I'm going a complex join on 5 tables and some of them have a column that repeats in two tables called "name". So I created an alias for each table, one of them called co, and in my application I do a result.getString("co.name"). But the application fails with: "The column name co.name was not found in this ResultSet."

When I test this same code against a MySQL database it returns the right column. I tried doing just a result.getString("name") but as I expected it just returned the first column called "name" instead of the one I want.

Is this a bug in the JDBC driver, or am I doing it wrong?

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

Предыдущее
От: "ml-tb"
Дата:
Сообщение: Double quoted column name from DatabaseMetaData.getIndexInfo
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: My query table aliases don't exist in my application