Dodeca Version 6.2.1

April 10, 2012 - Build 3404

This version uses SpreadsheetGear 2010 (6.0.3.190), NetAdvantage 2011, Volume 1 (11.1.20111.2042), and Aspose.Cells 7.0.3.0.

Relational

  • Fixed issue with SQL column aliases not being properly returned by certain JDBC drivers.

When a SQL statement uses column aliases, the column name is returned by some JDBC drivers, including the DB2 Type 4 JDBC driver, instead of the specified column alias. This behavior causes problems when multiple columns with the same name are retrieved in the query.

Resolution: The Dodeca server was modified to use the Java ResultSetMetaData.getColumnLabel() method to get the alias and, if a value is not returned, uses the ResultSetMetaData.getColumnName() method to get the column name. (#1079)