Column aliases are ignored in EDS

Solution Verified - Updated -

Environment

  • Red Hat JBoss Data Services (EDS) 5.2
  • Red Hat JBoss Data Services (EDS) 5.3

Issue

  • In JBEDS 5.2, it seems that column aliases are ignored, or at least that's the impression Squirrel gives. If I run the below query in JBEDS 5.1, I can see the column header "ALTERNATE_ID".
  • If I run the exact same query in JBEDS 5.2, with the same VDB, I get NySystemLogin as the column header.

  • In the Output result of the data, the column names are not the aliases

    select p.NtSystemLogin AS ALTERNATE_ID FROM Entity_Model.RefData.Persons p LIMIT 10;

Resolution

A change was made in JDBC4 to return unaliased column names as the ResultSetMetadata column name. Prior to this, if a column alias was used it was returned as the column name. Setting this property to false will enable backwards compatibility. Defaults to true. Add the following Connection property to the JDBC connection url:

;useJDBC4ColumnNameAndLabelSemantics=false

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments