Postgres Pro
Downloads
Home   >   mailing lists

My query table aliases don't exist in my application - Mailing list pgsql-jdbc

From Hugo Garza
Subject My query table aliases don't exist in my application
Date
Msg-id AANLkTimBHzeWSsKxC7ZhziKiehCmCgyiUdD3Q76yNrSy@mail.gmail.com
Whole thread Raw
Responses Re: My query table aliases don't exist in my application  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-jdbc
Tree view
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 by date:

Previous
From: "ml-tb"
Date:
Subject: Double quoted column name from DatabaseMetaData.getIndexInfo
Next
From: "Kevin Grittner"
Date:
Subject: Re: My query table aliases don't exist in my application