Latest feature:

• 2023-04-01 supports SWITCH function.
• 2022-11-10 allows only '%'( not '_') for LIKE pattern on Pivot table's dynamic column names.
• 2022-04-16 supports FTP with explicit SSL/TLS encryption (FTPES).
• 2022-04-16 supports FTP with implicit SSL/TLS (FTPS).
• 2022-02-14 supports CTE syntax (common table expression).
• 2022-02-10 provides one-row table for an element which has not any grandson.
• 2022-01-26 provides SAMBA support for Azure file share.
• 2021-12-15 provides function SPLIT_PART(string, delimiter,field_number) .
• 2021-03-24 provides dynamical column, ILIKE pattern, expression calculation for PIVOT table and UNPIVOT table.
• 2021-02-08 supports seamlessly files and directories in Seven Zip file formats(.7z) in jdbc url and sql.
• 2021-01-06 provides new table object(XML_TABLE, JSON_TABLE, VALUES_TABLE) for ETL.
• 2020-11-11 supports COPY DATABASE sql and CLONE DATABASE sql.
• 2020-10-23 quicken parse speed.
• 2020-08-19 COLLATE(string1[,collation]) supports 'Excel', a special collation for ORDER BY clause, which can detect numeric value from string value, and sort like MS Excel.

2020-08-12 XML v4.0 JDBC4.3 Package(1577KB) JDBC4.2 Package(1580KB) JDBC4.1 Package(1569KB) JDBC4.0 Package(1565KB) JDBC3.0 Package(1441KB) JDBC2.0 Package(1390KB) JDBC1.2 Package(1411KB)

• 2020-02-03 provides refreshIntervalfor http/https protocol
• 2019-11-24 supports SMB2 (2.02 protocol level) for SAMBA URL.
• 2019-11-20 supports using the IP address on the HTTPS URL.
• 2019-11-07 supports user/password BASIC authorization for url database connection based on HTTP/HTTPS protocol.
• 2019-10-29 discards only relative index search result for update sql.
• 2019-10-26 provides aggregate functions(PRODUCT, STDEV, STDEVP, VAR, and VARP).
• 2019-10-17 provides EXPLAIN SQL anySQL for SQL syntax analysis feature like INFORMATION_PARSER.sql table.
• 2019-10-17 provides EXPLAIN anySQL to show how the tables involved in the statement will be scanned by index scanned or sequential scan.
• 2019-10-11 beside embedded user/password in ftp/sftp/http/https url, it supports
  

           1. Connection getConnection(String url, String user, String password); 
           2. Properties prperties=new Properties();
              prperties.put("user","ftpdemo1");
              prperties.put("password","ftp12345");            
              Connection con = DriverManager.getConnection( url,prperties );

  to avoid possible jdbc url log.
• 2019-09-23 three functions (DATE, TIME, and TIMESTAMP) will utilize connection properties(dateFormat, timeFormat, and timestampFormat) like CAST(expression AS data_type) and CONVERT(value1, SQLtype1).
• 2019-09-12 supports multiple-table UPDATE statement.
• 2019-06-25 provides _values_ as a pseudo name for all values in a data row.
• 2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.

2018-11-25 XML v3.0 JDBC4.3 Package(1511KB) JDBC4.2 Package(1513KB) JDBC4.1 Package(1503KB) JDBC4.0 Package(1499KB) JDBC3.0 Package(1351KB) JDBC2.0 Package(1301KB) JDBC1.2 Package(1321KB)

• 2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.
• 2018-11-3 provides FLUSH DATABASE sql.
• 2018-10-22 supports aggregate function ARRAY_AGG([DISTINCT] expression), STRING_AGG([DISTINCT] expression[, delimiter]).
• 2018-10-07 provides dbo as a pseudo name for the current schema for JasperSoft tool. The old "." name can still be used too.
• 2018-09-21 supports JSON, JSONB, XML, and ARRAY.
• 2018-08-30 provides _CURRENT_ as a pseudo name for the current catalog for JasperSoft tool. The old "." name can still be used too.
• 2018-04-12 needn't to encode special character for http/https url.
• 2018-02-02 can split multivalue column into rows through special subquery table.

2017-08-02 XML v2.0 JDBC1.2 Package(1256KB) JDBC2.0 Package(1238KB) JDBC3.0 Package(1288KB) JDBC4.0 Package(1428KB) JDBC4.1 Package(1431KB) JDBC4.2 Package(1442KB)

• 2017-06-30 PreparedStatement.executeBatch suupports RETURN_GENERATED_KEYS.
• 2016-09-30 provides Pseudo Table INFORMATION_PARSER.sql for SQL syntax analysis feature.
• 2016-03-23 provides refreshIntervalfor ftp/sftp protocol
• 2016-03-23 supports DatabaseMetaData.getTables for ftp/sftp protocol
• 2016-02-04 supports escape character '\' in pattern for DatabaseMetaData.
• 2015-04-30 supports write sftp protocol data file.
• 2014-09-02 supports write ftp protocol data file.
• 2014-07-30 fixed a seldom bug for UTF8 decode.
• 2014-05-08 v1.2.001 supports JDBC 4.2.

2014-05-08 XML v1.2 JDBC1.2 Package(1229KB) JDBC2.0 Package(1215KB) JDBC3.0 Package(1262KB) JDBC4.0 Package(1374KB) JDBC4.1 Package(1378KB) JDBC4.2 Package(1388KB)

• 2014-05-08 v5.2.001 supports JDBC 4.2.
• 2013-12-13 fixed an update bug for XML files.
• 2013-10-09 supports NTLM Authentication for SAMBA url or SAMBA absolute path.
• 2013-08-27 fixed an ArrayIndexOutOfBoundsException bug on system function since 2013-08-09.
• 2013-08-09 support update batch column list syntax. For instance, UPDATE "UIP_Target" SET ("key_string","key_int","data_string","data_int","data_decimal" ) = (SELECT COALESCE(DP3475."key_string", "UIP_Target"."key_string"),COALESCE(DP3475."key_int", "UIP_Target"."key_int"),COALESCE(DP3475."data_string", "UIP_Target"."data_string"),COALESCE(DP3475."data_int", "UIP_Target"."data_int"),COALESCE(DP3475."data_decimal", "UIP_Target"."data_decimal") FROM DP3475 WHERE "UIP_Target"."key_string"=DP3475."KEY208" AND "UIP_Target"."key_int"=DP3475."KEY572") WHERE EXISTS (SELECT 'X' FROM DP3475 WHERE "UIP_Target"."key_string"=DP3475."KEY208" AND "UIP_Target"."key_int"=DP3475."KEY572")
• 2013-08-02 fixed a cache bug for In subqueryTable expression which subqueryTable contains parameter since 2013-02-25.
• 2013-07-09 support XPATH in table path. For instance, select * from axmlFile."root/collection/file[@index=165]/file[@index=210]"; .
• 2013-06-29 fixed a match partly bug on FULL OUTER JOIN.
• 2013-06-26 fixed a condition bug for where clause since 2013-06-23.
• 2013-05-03 fixed a NullPointerException bug for date convertion function since 2013-04-11.
• 2013-05-02 fixed a bug for Union ALL with where-clause.
• 2013-04-06 LIKE/ILIKE supports complicated expression as string pattern.
• 2013-03-11 v1.1.107 allows omittance [CONSTRAINT constraint_name] for UNIQUE in constraint clause.
• 2013-03-07 provides how to install HXTT DB Server as system service on MS Windows 7, Windows 2008, and Vista for remote connection and remote control
• 2012-12-11 v1.1.088 provides SPLIT(expression,delimiter) function.
• 2012-11-09 v1.1.084 supports AES(128/192/256) for encrypt,decrypt,encode/decode function.
• 2012-11-01 v1.1.082 optimizes speed to access random million-level rows. Default 32000 rows are cached in memory, and you can ajust the cached row number through maxCacheSize connection property. For smalll document, HXTT XML engine will parse first XML syntax, then allow SQL random access all rows at last. For big XML document, XML parse and SQL access are concurrent now, so that it should be the fastest XML engine with a smaller memory requirement.
• 2012-11-01 v1.1.082 rewrite XML parse engine for small memory to load million-level rows.
• 2012-10-23 v1.1.078 quicken IN on subquery with more than 100,000 data rows.
• 2012-10-20 v1.1.076 supports NUMBER[(n1[,n2])] for CREATE TABLE sql.
• 2012-10-04 v1.1.072 supports XML format for SELECT ... INTO OUTFILE syntax.
• 2012-10-01 v1.1.071 optimizes long varchar type of temporary index.
• 2012-09-27 v1.1.070 supports seamlessly sftp url database in jdbc url and sql.
• 2012-07-10 v1.1.055 supports CSV format for SELECT ... INTO OUTFILE syntax.
• 2012-02-25 v1.1.030 supports Statement.setQueryTimeout.
• 2012-02-10 v1.1.025 supports query on SCHEMATA, TABLES, COLUMNS of INFORMATION_SCHEMA schema.
• 2011-11-12 v1.1.008 provides five regular expression functions(REGEXP_COUNT, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, and REGEXP_SUBSTR)
• 2011-11-04 v1.1.005 optimizes speed for DISTINCTROW on multi tables.

2011-10-11 XML v1.1 JDBC1.2 Package(1050KB) JDBC2.0 Package(1035KB) JDBC3.0 Package(1072KB) JDBC4.0 Package(1171KB) JDBC4.1 Package(1175KB)

• v1.1.001 supports JDBC 4.1.
• v1.0.003 provides ODBCTrimBehavior, caseInsensitive, emptyStringAsNull connection property.
• v1.0.002 can fetch/modify any n-level element of XML file through sql.

2011-06-02 XML v1.0 JDBC1.2 Package(945KB) JDBC2.0 Package(981KB) JDBC3.0 Package(1014KB) JDBC4.0 Package(1109KB)

• supports XML 1.0, and XML 1.1
• 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, ALTER TABLE, CREATE VIEW, DROP VIEW, SELECT, INSERT, UPDATE, and DELETE sql.
• Development Documentation is available.
• supports JDBC4.0, JDBC3.0, JDBC2.0 and JDBC1.2.