Latest feature:

• v2.1.011 fixed a bug on ResultSet.last() since v2.0.046.
• v2.1.004 supports WITH ROLLUP, WITH CUBE, and GROUPING(expression).
• v2.1.004 supports bitwise logical operator(&, |, ~, ^, <<, >>), BITAND(x, y), and BIT_COUNT(x).

2008-07-23 Excel v2.1 JDBC1.2 Package(944KB) JDBC2.0 Package(932KB) JDBC3.0 Package(969KB)

• v2.0.036 supports GROUP_CONCAT function.
• v2.0.035 supports to assign more than one extension for otherExtension connection property.
• v2.0.034 supports lower(upper) function in LIKE expression.
• v2.0.001 supports INTO variable[,...] for SELECT sql.
• v2.0.001 supports SET variable = expression [,...].
• v2.0.001 supports DECLARE Local Variables.

2007-10-29 Excel v2.0 JDBC1.2 Package(953KB) JDBC2.0 Package(940KB) JDBC3.0 Package(979KB)

• v1.1.084 replaced "? Expression" with "SELECT select_list".
• v1.1.080 provides SHA1 function besides MD5 and Crypt3.
• v1.1.078 can detect data type according to format information for cell, row, column, sheet, and workbook, when there's no data.
• v1.1.071 can detect data type from "column format" in excel when it meets empty column.
• v1.1.070 can detect data type from "cell display format" in excel when it meets empty cell.
• v1.1.069 fixed a bug in detecting date value with customer defined format.
• v1.1.068 changed the visibility of columns in JOIN table with parentheses from invisible to visible.
• v1.1.068 supports JOIN and subquery in PIVOT and UNPIVOT.
• v1.1.066 fixed an update bug when meets mixed blank cell and numeric cell.
• v1.1.057 supports seamlessly https url database in jdbc url and sql.
• v1.1.010 provides maxScanRows connection property for auto data type detection, but it still supports using different data types for a column.
• v1.1.001 supports SAMBA table, which needn't to map or mount driver.

2007-01-11 Excel v1.1 JDBC1.2 Package(931KB) JDBC2.0 Package(918KB) JDBC3.0 Package(955KB)

• v1.0.047 optimizes memory occupation for UNION ALL.
• v1.0.044 added CP850, CP852, CP866, CROATIAN, HEBREW, and SWEDISH sort for COLLATE function.
• v1.0.042 fixed an output bug for compressing multiple number values on a row.
• v1.0.025 provides function getNumber, getInt, getLong, and getDouble.

2006-08-15 Excel v1.0 JDBC1.2 Package(918KB) JDBC2.0 Package(905KB) JDBC3.0 Package(942KB)

• supports seamlessly url(http, ftp) database in jdbc url and sql.
• supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
• supports seamlessly files and directories in ZIP, GZIP, TAR and BZ2 file formats(.ZIP, .JAR, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
• supports all of four transaction levels.
• supports CREATE DATABASE, CREATE CATALOG, CREATE TABLE, DROP TABLE, RENAME TABLE, SELECT, INSERT, UPDATE, and DELETE sql.
• Development Documentation is available.
• supports JDBC3.0, JDBC2.0 and JDBC1.2.
• supports create/query/update Microsoft Excel file version from 95, 97, 98, 2000, 2001, 2002, 2003, to 2004.