Released Version Log
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.
Copyright © 2008 Hongxin Technology & Trade Ltd. | All Rights Reserved. |