JDBC ResultSet get columns with table alias

by

JDBC will simply name the columns by what is specified in the query – it doesn’t know about table names etc.

You have two options:

Option 1: Name the columns differently in the query, ie

SELECT
    a.columnName as columnNameA,
    b.columnName as columnNameB,
    ...
from table1 a, table2 b where (WHATEVER)

then in your java code refer to the column aliases:

resultSet.getString("columnNameA");
resultSet.getString("columnNameB");

Option 2: Refer to the column position in your call to the JDBC API:

resultSet.getString(1);
resultSet.getString(2);

Note that the JDBC API uses one-based indexes – ie they count from 1 (not from 0 like java indexes), so use 1 for the first column, 2 for the second column, etc

I would recommend option 1, because it’s safer to refer to named columns: Someone may change the order of the columns in the query and it would silently break your code (you would be accessing the wrong column but would not know), but if they change the columns names, you’ll at least get a “no such column” exception at runtime.

More Related Contents:

  1. Using setDate in PreparedStatement
  2. How do I get the size of a java.sql.ResultSet?
  3. java.sql.SQLException: Exhausted Resultset
  4. How to enable logging for SQL statements when using JDBC
  5. Getting output from dbms_output.get_lines using JDBC
  6. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  7. Hours and seconds are lost when storing a date in the database [closed]
  8. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  9. Efficient way to do batch INSERTS with JDBC
  10. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  11. How does a PreparedStatement avoid or prevent SQL injection?
  12. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  13. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  14. How to call oracle stored procedure which include user-defined type in java?
  15. Difference between Oracle jdbc driver classes?
  16. Cleanest way to build an SQL string in Java
  17. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  18. Java – Can’t use ResultSet after connection close
  19. Timezones in SQL DATE vs java.sql.Date
  20. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  21. Call an Oracle function from Java
  22. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  23. Inserting null to an Integer column using JDBC
  24. ResultSet: Exception: set type is TYPE_FORWARD_ONLY — why?
  25. How to get the number of columns from a JDBC ResultSet?
  26. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  27. Connection cannot be cast to oracle.jdbc.OracleConnection
  28. MS SQL Exception: Incorrect syntax near ‘@P0’
  29. Convert a Result Set from SQL Array to Array of Strings
  30. Database independence through JDBC in java

Leave a Comment