Latest feature:

• 2024-11-21 provides privateKeyFile connection property to assign the private key file for Sftp protocol to build public-key authentication without password.
• 2024-03-18 supports OFFSET clause and FETCH clause.
• 2023-04-01 supports SWITCH function.
• 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-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-03-15 fixed an index bug since 2021-02-19.
• 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-06 supports COPY TABLE sql and CLONE TABLE sql.
• 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 Paradox v7.1 JDBC4.3 Package(1619KB) JDBC4.2 Package(1622KB) JDBC4.1 Package(1610KB) JDBC4.0 Package(1606KB) JDBC3.0 Package(1480KB) JDBC2.0 Package(1428KB) JDBC1.2 Package(1449KB)

• 2020-02-03 provides refreshIntervalfor http/https protocol
• 2020-01-02 supports ALTER TABLE sql.
• 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-10-03 fixed an index expression match bug since 2019-08-01.
• 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 Paradox v7.0 JDBC4.3 Package(1554KB) JDBC4.2 Package(1556KB) JDBC4.1 Package(1545KB) JDBC4.0 Package(1542KB) JDBC3.0 Package(1391KB) JDBC2.0 Package(1340KB) JDBC1.2 Package(1360KB)

• 2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.
• 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-20 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 Paradox v6.0 JDBC1.2 Package(1295KB) JDBC2.0 Package(1276KB) JDBC3.0 Package(1327KB) JDBC4.0 Package(1470KB) JDBC4.1 Package(1473KB) JDBC4.2 Package(1484KB)

• 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-08 supports a variable format of encrypt file.
• 2014-09-02 supports write ftp protocol data file.
• 2014-05-08 v5.2.001 supports JDBC 4.2.

2014-05-08 Paradox v5.2 JDBC1.2 Package(1269KB) JDBC2.0 Package(1251KB) JDBC3.0 Package(1301KB) JDBC4.0 Package(1416KB) JDBC4.1 Package(1420KB) JDBC4.2 Package(1430KB)

• 2014-05-08 v5.2.001 supports JDBC 4.2.
• 2014-04-01 supports two ecrypted samples without auxiliary passwords.
• 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-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-17 provides LAST_INSERT_ID() function.
• 2013-04-06 LIKE/ILIKE supports complicated expression as string pattern.
• 2013-03-11 v5.1.109 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 v5.1.090 provides SPLIT(expression,delimiter) function.
• 2012-11-09 v5.1.086 supports AES(128/192/256) for encrypt,decrypt,encode/decode function.
• 2012-10-23 v5.1.080 quicken IN on subquery with more than 100,000 data rows.
• 2012-10-20 v5.1.078 supports NUMBER[(n1[,n2])] for CREATE TABLE sql.
• 2012-10-04 v5.1.074 supports XML format for SELECT ... INTO OUTFILE syntax.
• 2012-10-01 v5.1.073 optimizes long varchar type of temporary index.
• 2012-09-27 v5.1.072 supports seamlessly sftp url database in jdbc url and sql.
• 2012-09-04 v5.1.070 fixed a bug on automatic temporary index since v5.1.045.
• 2012-07-07 v5.1.057 supports CSV format for SELECT ... INTO OUTFILE syntax.
• 2012-06-06 v5.1.050 fixed a join query bug since v5.1.045
• 2012-05-16 v5.1.045 uses automatic temporary index to quicken join sql.
• 2012-02-25 v5.1.032 supports Statement.setQueryTimeout.
• 2012-02-10 v5.1.027 supports query on SCHEMATA, TABLES, COLUMNS of INFORMATION_SCHEMA schema.
• 2011-11-09 v5.1.008 provides five regular expression functions(REGEXP_COUNT, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, and REGEXP_SUBSTR)
• 2011-10-30 v5.1.005 optimizes speed for DISTINCTROW on multi tables.

2011-10-11 Paradox v5.1 JDBC1.2 Package(1091KB) JDBC2.0 Package(1076KB) JDBC3.0 Package(1112KB) JDBC4.0 Package(1215KB) JDBC4.1 Package(1219KB)

• v5.1.001 supports JDBC 4.1.
• v5.0.057 fixed a bug of index on very large table.
• v5.0.020 supports PIVOT expression besides column.
• v5.0.019 supports [START WITH initial-condition] CONNECT BY [NOCYCLE] recurse-condition. level is a pseudo column that can be used in hierarchical queries.
• v5.0.016 fixed a bug on utilizing index to quicken ORDER BY.
• v5.0.016 fixed a bug on utilizing part expression of component index to quicken BETWEEN query.
• v5.0.002 supports CREATE VIEW and DROP VIEW.

2011-04-05 Paradox v5.0 JDBC1.2 Package(849KB) JDBC2.0 Package(886KB) JDBC3.0 Package(921KB) JDBC4.0 Package(1011KB)

• SELECT ... FOR UPDATE will lock all the selected rows for transaction until transaction commit or rollback even if you close that ResultSet since v4.2.200.
• SELECT ... FOR UPDATE will lock all the selected rows so that other users cannot lock or update the rows until you close that ResultSet since v4.2.198.
• v4.2.174 supports function decode( expression , search , result [, search , result]... [, default] )
• v4.2.142 provides missingMemoFile connection properity to ignore or repair when memo file is missing.
• v4.2.137 provides tmpdir=_memory_ connection property.
• v4.2.080 supports '[]' to specify a range of characters for LIKE/ILIKE.
• v4.2.050 supports secondary DESC indexes.
• v4.2.038 fixed a bug on LEFT JOIN, which will return empty result for specific condition.
• v4.2.005 supports DISTINCT parameter for the aggregate functions of COUNT, SUM, and AVG.
• v4.2.001 supports JDBC 4.0.

2008-09-22 Paradox v4.2 JDBC1.2 Package(886KB) JDBC2.0 Package(876KB) JDBC3.0 Package(915KB) JDBC4.0 Package(1003KB)

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

2008-07-23 Paradox v4.1 JDBC1.2 Package(881KB) JDBC2.0 Package(873KB) JDBC3.0 Package(912KB)

• v4.0.036 supports GROUP_CONCAT function.
• v4.0.034 supports lower(upper) function in LIKE expression.
• v4.0.001 supports INTO variable[,...] for SELECT sql.
• v4.0.001 supports SET variable = expression [,...].
• v4.0.001 supports DECLARE Local Variables.

2007-10-29 Paradox v4.0 JDBC1.2 Package(892KB) JDBC2.0 Package(883KB) JDBC3.0 Package(916KB)

• v3.1.084 replaced "? Expression" with "SELECT select_list".
• v3.1.083 provides CURRVAL(cTableName, cColumnName) to fetch the last generated IDENTITY(auto_increment) value for a particuar table.
• v3.1.080 provides SHA1 function besides MD5 and Crypt3.
• v3.1.068 changed the visibility of columns in JOIN table with parentheses from invisible to visible.
• v3.1.068 supports JOIN and subquery in PIVOT and UNPIVOT.
• v3.1.057 supports seamlessly https url database in jdbc url and sql.
• v3.1.051 fixed a bug for utilizing index on LIKE '%'.
• v3.1.010 supports AUTO_INCREMENT in CREATE TABLE sql
• v3.1.001 supports SAMBA table, which needn't to map or mount driver.

2007-01-11 Paradox v3.1 JDBC1.2 Package(867KB) JDBC2.0 Package(858KB) JDBC3.0 Package(896KB)

• v3.0.047 optimizes memory occupation for UNION ALL.
• v3.0.044 added CP850, CP852, CP866, CROATIAN, HEBREW, and SWEDISH sort for COLLATE function.
• v3.0.024 supports timezone offset for timestamp type.
• v3.0.014 optimizes speed for UNION.
• v3.0.012 provides maxIdleTime connection property. maxIdleTime indicates the max idle time in minute for remote connection. That option is mainly used to avoid closing automatically idle remote connection for connection pool. Embedded idle connectoin won't be closed automatically except for garbage collection. You can use 1~1440 minutes. Default: 15.
• v3.0.004 can utilize an obsoleted invalid X type index file produced by Borland Database Desktop without pack table in advance.
• v3.0.003 fixed a bug when reindex X type index file, for instance,"reindex Prodemp.X03 on prodemp;".

2006-08-07 Paradox v3.0 JDBC1.2 Package(950KB) JDBC2.0 Package(937KB) JDBC3.0 Package(975KB)

• v2.3.036 supports Create Table from any java.io.InputStream object.
• v2.3.020 supports PIVOT and UNPIVOT.
• v2.3.015 provides CDATE(expression,pattern) for date conversion.
• v2.3.011 fixed a bug in index query for IN operation.
• v2.3.008 fixed a bug in index result cache.

2006-05-17 Paradox v2.3 JDBC1.2 Package(823KB) JDBC2.0 Package(815KB) JDBC3.0 Package(854KB)

• v2.2.024 supports seamlessly url(http, ftp) database in jdbc url and sql.
• v2.2.025 supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
• v2.2.025 supports seamlessly files and directories in TAR and BZ2 file formats(.TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
• v2.2.015 provides TABLELOCKED(cTableName) function.
• v2.2.001 provides lock table and unlock table sql.

2006-03-07 Paradox v2.2 JDBC1.2 Package(782KB) JDBC2.0 Package(798KB) JDBC3.0 Package(828KB)

• v2.1.120 optimizes IN, NOT IN, ALL, and ANY on subquery.
• v2.1.113 provides SSL connection and customer connection for client/server mode.
• v2.1.109 supports seamlessly files and directories in ZIP and GZIP file formats(.ZIP, .JAR, .GZ) in jdbc url and sql.
• v2.1.99 changed CREATE SCHEMA sql to CREATE CATALOG
• v2.1.99 changed [schemas.]tableName@[catalog] format to [catalog.]tableName
• v2.1.97 supports column numbers in ORDER BY clause
• v2.1.96 supports Multiple-row VALUES tables.
• v2.1.83 supports MySQL Migration Toolkit v1.0.21
• v2.1.80 supports aggregate function first(x), last(expression).
• v2.1.78 supports function ATN(x), CBOOL(expression), CBYTE(expression), CDBL(expression), CINT(expression), CLNG(expression), CSNG(expression), CSTR(expression), and CDATE(expression).
• v2.1.44 supports Corel Paradox's encrypted database

2005-09-12 Paradox v2.1 JDBC1.2 Package(726KB) JDBC2.0 Package(741KB) JDBC3.0 Package(765KB)

• supports MySQL Migration Toolkit v1.0.20
• supports MS Windows service and Linux Daemon for remote connection and remote control
• supports DISTINCTROW.
• supports XA-Resources
• provides ILIKE syntax support,ignore upper and case like
• provides $ token for checking whether left string is contained in right string.
• provides transaction sql.
• provides user/password verification for client/server mode.

2005-01-01 Paradox V2.0 JDBC1.2 Package(634KB) JDBC2.0 Package(626KB) JDBC3.0 Package(642KB)

• provides the quicker TCPServer to replace the slow RMIServer.
• utilizes index for ORDER BY.
• supports CREATE SEQUENCE, DROP SEQUENCE, and ALTER SEQUENCE.
• provides Database GUI Manager.

2004-10-28 Paradox 1.0 JDBC1.2 Package(358KB) JDBC2.0 Package(378KB) JDBC3.0 Package(386KB)

• Development Documentation is available.
• supports JDBC3.0, JDBC2.0 and JDBC1.2.
• provides collate function for multilingual sort.
• supports [reserved word].
• provides MD5 function.
• provides Table Encryption and ColumnLevel Encryption.
• provides _LockFlag_ virtual column as row lock flag for Borland's dataset.
• provides encrypt/decrypt function for Row-Column (Cell) Level Encryption.