Latest feature:

• 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.