Released Version Log
Latest feature:
- 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.
Copyright © 2003-2018 Heng Xing Tian Tai Lab | All Rights Reserved. |