history.html - HXTT DBF JDBC Drivers for dbase, Visual DBASE, SIx Driver, PowerPlus, SoftC, Codebase, Clipper, Foxbase, Foxpro, and VFP v6.0

Released Version Log

Latest feature:

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-09-05 add an index expression verification for DampSoft Software's lock .

2021-09-03 fixed a delayed close bug for server mode since 2021-04-04.

2021-03-25 provides lockType=DampSoftRead connection property to read/write DampSoft Software's incompatible format but doesn't use DampSoft Software's lock.

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-08 will utilize automatically Not Deleted() memory temporary index when SQL has not any indexed condition for a table, if delayedClose>=2.5 seconds (default value 3 seconds). That can reduce Pack Table operation.

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-09-10 supports auto_increment type from DampSoft according to a file sample.

2020-08-28 provides lockType=DampSoft connection property to detect DampSoft Software's incompatible lock.

2020-08-26 supports REINDEX for an unknown CDX format from DampSoft.

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 DBF v7.1 JDBC4.3 Package(1679KB) JDBC4.2 Package(1682KB) JDBC4.1 Package(1670KB) JDBC4.0 Package(1666KB) JDBC3.0 Package(1537KB) JDBC2.0 Package(1485KB) JDBC1.2 Package(1506KB)
2020-06-24 supports read/update an unknown CDX format from DampSoft.

2020-03-10 fixed a transaction bug for TRANSACTION_READ_COMMITTED level since 2019-12-3

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 for compatible lock, reduces CDX/MDX/NTX index reload when detect concurrent modification.

2019-10-29 discards only relative index search result for update sql.

2019-10-26 for MDX index compatible lock, enable buffer concurrency check to reduce reload since there's still MDX user

2019-10-26 provides aggregate functions(PRODUCT, STDEV, STDEVP, VAR, and VARP).

2019-10-19 can utilize smartly some index expressions with function(for instance, upper(aColumn), str(aColumn), and so on) to quicken a aColumn=aVAlue condition.

2019-10-18 can utilize complicated FOR index expression(for instance, not del and not deleted()) when not deleted() is omitted in where clause. The older package supports only omitted not deleted for simplest FOR index expression(for instance, not deleted()).

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-10-03 can reindex CDX file with more than 50 index expressions.

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-09-03 fixed a German accent character issue for upper function on CDX index format.

2019-06-25 provides _values_ as a pseudo name for all values in a data row.

2019-03-20 provides emptyDateAsNull connection property.

2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.

2018-11-25 DBF v7.0 JDBC4.3 Package(1657KB) JDBC4.2 Package(1659KB) JDBC4.1 Package(1648KB) JDBC4.0 Package(1645KB) JDBC3.0 Package(1485KB) JDBC2.0 Package(1435KB) JDBC1.2 Package(1456KB)

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-17 supports a variable of NDX index file with a tag ADDE.

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-01 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-07-10 can utilize FOR expression with more than one AND condition in Index file.

2018-04-25 detects different block size of MDX file.

2018-04-12 needn't to encode special character for http/https url.

2018-02-13 provides collationSequence connection property for Clipper International version.

2018-02-02 fixed a compatible issue for UPPER function on NTX for chareSet=Mazovia.

2018-02-02 can split multivalue column into rows through special subquery table.

2017-10-29 provides compatible Number type of MDX index for dBase IV.

2017-08-02 DBF v6.0 JDBC1.2 Package(1389KB) JDBC2.0 Package(1370KB) JDBC3.0 Package(1420KB) JDBC4.0 Package(1572KB) JDBC4.1 Package(1575KB) JDBC4.2 Package(1586KB)

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-10-09 fixed a query bug on LIMIT clause with OFFSET.

2015-04-30 supports write sftp protocol data file.

2015-03-27 won't utilize obsoleted UNIQUE index for query match.

2015-03-10 fixed a null value match bug for CDX format.

2014-10-31 adjusted the transaction module, and supports all isolation levels for Xbase compatible mode.

2014-09-30 allows to use UPDATE sql on the auto increment column to assign a bigger value.

2014-09-30 fixed a bug on ALTER TABLE sql which discards the older auto increment column information.

2014-09-19 For VFP's nullable character column, '' and null is different in UPDATE sql now.

2014-09-02 supports write ftp protocol data file.

2014-07-18 provides LTOC(bExpression) function.

2014-05-08 v5.2.005 detects whether take per tab character as 8 space characters.

2014-05-08 v5.2.001 supports JDBC 4.2.

2014-05-08 DBF v5.2 JDBC1.2 Package(1356KB) JDBC2.0 Package(1338KB) JDBC3.0 Package(1388KB) JDBC4.0 Package(1512KB) JDBC4.1 Package(1515KB) JDBC4.2 Package(1526KB)

2014-05-08 v5.2.001 supports JDBC 4.2.

2014-04-02 can utilize index str(ALBARAN,7) for ALBARAN=? since some old Xbase index format doesn't support numeric type.

2014-03-11 will adjust automatically index node size according to maximum key length for create MDX index.

2014-03-03 fixed a cache bug for Xbase compatible mode.

2014-02-14 can utilize index str(ALBARAN,7) for str(ALBARAN,?)=str(?,?) .

2013-12-30 dBase Plus 8 with ADO can read all kinds of created tables by HXTT DBF with versionNumber=DB2K connection property.

2013-11-27 fixed a lazy bug for autoincrement value refresh.

2013-10-16 For STR(nExpression [, nLength [, nDecimalPlaces]]) function, if nLength is omitted, nLength defaults to 10 characters.

2013-10-09 supports NTLM Authentication for SAMBA url or SAMBA absolute path.

2013-10-04 fixed a CDX index page string match partly bug for simulated component index support since 2013-06-29.

2013-09-05 provides the correct key store format for RECNO() as indexed expression in CDX format file. But RECNO() function as the indexed expression is inadvisable. If you build CDX index on RECNO() function, HXTT DBF will utilize index file for where clause which contains RECNO() function. If you haven't such a RECNO() indexed expression, HXTT DBF will locate it directly through RECNO() value for where clause.

2013-09-05 fixed a CDX split index page bug when insert varchar value since 2013-06-05.

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-19 provides deletesAreBlank connection property for DELETE operation.

2013-06-29 fixed a match partly bug on FULL OUTER JOIN.

2013-06-29 provided simulated component index support for indexed complicated string expression. For instance, char1 + DTOS(d), the older package can utilize index for where cha1=?, where char1+ DTOS(d), but can't utilize index for dtos(d) component, but char1 component, of where cha1=? and dtos(d) . HXTT Access, HXTT Paradox, and HXTT Cobol support the true component index.

2013-06-26 fixed a condition bug for where clause since 2013-06-23.

2013-06-11 can utilize for expression in index file to match partly.

2013-06-07 supports RAT(cSearchExpression, cExpressionSearched [, nOccurrence]) and RATC(cSearchExpression, cExpressionSearched [, nOccurrence]).

2013-06-06 fixed an index page bug for indexed shorter string values on CDX index file since 2010-06-16.

2013-05-13 v5.1.137 fixed a bug which failed to parse '\r\n' in CGP file since 2012-11-05.

2013-05-12 v5.1.136 won't to guess non-structural index file if there's a CGP file.

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.115 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.096 provides SPLIT(expression,delimiter) function.

2012-11-09 v5.1.092 supports AES(128/192/256) for encrypt,decrypt,encode/decode function.

2012-10-25 v5.1.087 optimizes temporary index for EXISTS subquery with jon tables.

2012-10-23 v5.1.086 quicken IN on subquery with more than 100,000 data rows.

2012-10-20 v5.1.084 supports NUMBER[(n1[,n2])] for CREATE TABLE sql.

2012-10-04 v5.1.080 supports XML format for SELECT ... INTO OUTFILE syntax.

2012-10-01 v5.1.079 optimizes long varchar type of temporary index.

2012-09-27 v5.1.078 supports seamlessly sftp url database in jdbc url and sql.

2012-09-12 v5.1.077 allows to update NTX index page when meet unexpected empty index point information.

2012-07-24 v5.1.067 supports incremental index naming scheme for table0n.* and table00n.* .

2012-07-07 v5.1.062 supports CSV format for SELECT ... INTO OUTFILE syntax.

2012-03-12 v5.1.036 provides FOXBASE4UNIX lock type for Foxbase2.1 on SCO Unix.

2012-02-25 v5.1.032 supports Statement.setQueryTimeout.

2012-02-14 v5.1.028 changed lock mode for SCO Foxpro on IDX index file.

2012-02-10 v5.1.027 supports query on SCHEMATA, TABLES, COLUMNS of INFORMATION_SCHEMA schema.

2011-12-09 v5.1.020 supports a variable of FlexFile3.

2011-11-07 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 DBF v5.1 JDBC1.2 Package(1172KB) JDBC2.0 Package(1156KB) JDBC3.0 Package(1192KB) JDBC4.0 Package(1302KB) JDBC4.1 Package(1306KB)

v5.1.001 supports JDBC 4.1.

v5.0.045 supports Array object for FlexFile3 format mem file.

v5.0.044 use maxFileSize connection property to allow beyond a maximum file size of 2GB.

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.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.009 supports numeric type plus date type as index expression.

v5.0.002 supports CREATE VIEW and DROP VIEW.

2011-04-05 DBF v5.0 JDBC1.2 Package(921KB) JDBC2.0 Package(957KB) JDBC3.0 Package(993KB) JDBC4.0 Package(1089KB)

v4.2.207 provides emptyStringAsNull connection property.

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.175 supports function decode( expression , search , result [, search , result]... [, default] )

v4.2.155 provides lockType=Alaska connection property to detect Alaska Software's CDX incompatible format.

v4.2.155 provides ODBCTrimBehavior, caseInsensitive, and emptyDecimalAsZero connection property.

v4.2.153 fixed a bug on CDX index varchar expression since v4.2.117.

v4.2.137 provides tmpdir=_memory_ connection property.

v4.2.080 supports '[]' to specify a range of characters for LIKE/ILIKE.

v4.2.066 can retrieve long column name information from database container at parent directory.

v4.2.052 fixed an insert bug on CDX index since v4.2.039.

v4.2.040 supports EVALUATE(cExpression).

v4.2.039 solved a CDX multiuser compatibility issue with VFP, which VFP will produce specific duplicated index information sometimes on mulituser mode.

v4.2.038 fixed a bug on LEFT JOIN, which will return empty result for specific condition.

v4.2.038 supports TYPE(cExpression) and VARTYPE(expression).

v4.2.031 fixed a bug for DISTINCT operation, which missed the possible data row when there's deleted row with the same value.

v4.2.013 fixed a bug on CDX compound format index file, which will sometimes set wrong index node information for specific complicated string index expression on insert operation.

v4.2.005 supports DISTINCT parameter for the aggregate functions of COUNT, SUM, and AVG.

v4.2.004 distinguishes empty string value from null value for VFP.

v4.2.002 supports function BINTOC(nExpression [, nSize]).

v4.2.001 supports JDBC4.0.

2008-09-22 DBF v4.2 JDBC1.2 Package(957KB) JDBC2.0 Package(946KB) JDBC3.0 Package(985KB) JDBC4.0 Package(1080KB)

v4.1.011 fixed a bug on ResultSet.last() since v4.0.046.

v4.1.007 fixed a bug on PACK TABLE sql when table needn't pack but memo file need to pack.

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

v4.1.004 fixed a bug on FPT memo since v4.0.038.

2008-07-23 DBF v4.1 JDBC1.2 Package(951KB) JDBC2.0 Package(943KB) JDBC3.0 Package(982KB)

v4.0.049 distinguishes empty value from null value for CDX index format.

v4.0.041 supports long table name for DBC database.

v4.0.038 supports Clipper SIX driver with SMT memo file.

v4.0.036 supports GROUP_CONCAT function.

v4.0.034 supports lower(upper) function in LIKE expression.

v4.0.034 supports to create 255~1024 length varchar column for Clipper.

v4.0.028 fixed a bug on autoincrement type for dbase 7 format.

v4.0.014 supports autoincrement type, int type, and timestamp type for dbase 7 and its mdx format.

v4.0.001 supports memory (.mem) file.

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 DBF v4.0 JDBC1.2 Package(961KB) JDBC2.0 Package(952KB) JDBC3.0 Package(992KB)

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.081 discarded "delete ... where true" to trigger TRUNCATE Table operation.

v3.1.081 discarded "delete ... where deleted()" to trigger Pack Table operation.

v3.1.080 provides SHA1 function besides MD5 and Crypt3.

v3.1.072 keeps the current language information for ALTER TABLE sql.

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.045 supports AUTO_INCREMENT type for DB2K(dBASE Version 7 Table File).

v3.1.035 uses lazy load for CDX format index on Xbase compatible mode.

v3.1.018 supports all Language driver names for DB2K(dBASE Version 7 Table File).

v3.1.014 fixed a cache bug for Read Committed transaction on latest inserted rows.

v3.1.012 provides FOXPRO4UNIX lock type for Foxpro2.6 on SCO Unix.

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 DBF v3.1 JDBC1.2 Package(938KB) JDBC2.0 Package(928KB) JDBC3.0 Package(967KB)

v3.0.051 optimizes memory occupation for UNION ALL.

v3.0.048 added CP850, CP852, CP866, CROATIAN, HEBREW, and SWEDISH sort for COLLATE function.

v3.0.040 will detect OS version, and choose the suitable JNI lock or NIO lock for Xbase compatible lock on Linux/Unix.

v3.0.022 will detect and fix invalid free page information in DBT file.

v3.0.016 optimizes speed for UNION.

v3.0.014 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.007 fixed a bug on DBFServer's Statement.getWarnings().

v3.0.006 provides STRZERO(nExpression, nLength[, nDecimals]) function.

v3.0.001 fetches correctly abnormal memo value from Clipper5.2's DBT files.

2006-08-07 DBF v3.0 JDBC1.2 Package(1021KB) JDBC2.0 Package(1008KB) JDBC3.0 Package(1045KB)

v2.3.036 supports to add index to an existent compound index file with Create Index sql.

v2.3.035 supports Create Table from any java.io.InputStream object.

v2.3.032 has complemented compatible INSERT code for Clipper 87 on Windows 2000/XP network drivers.

v2.3.025 will index deleted records if set deletesAreVisible connection property to true.

v2.3.019 supports PIVOT and UNPIVOT.

v2.3.014 provides CDATE(expression,pattern) for date conversion.

v2.3.001 returns timestamp type for date type + time type.

2006-05-17 DBF v2.3 JDBC1.2 Package(894KB) JDBC2.0 Package(885KB) JDBC3.0 Package(924KB)

v2.2.032 fixed a bug in temporary index for Between value1 And value2 query.

v2.2.031 fixed a bug in transaction commit for remote connection.

v2.2.024 supports seamlessly url(http, ftp) database in jdbc url and sql.

v2.2.024 supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.

v2.2.024 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.008 uses automatic temporary index to quicken subquery sql.

v2.2.001 provides lock table and unlock table sql.

2006-03-07 DBF v2.2 JDBC1.2 Package(852KB) JDBC2.0 Package(867KB) JDBC3.0 Package(897KB)

v2.1.125 uses automatic temporary index to quicken join sql.

v2.1.122 optimizes IN, NOT IN, ALL, and ANY on subquery.

v2.1.115 provides SSL connection and customer connection for client/server mode.

v2.1.112 supports seamlessly files and directories in ZIP and GZIP file formats(.ZIP, .JAR, .GZ) in jdbc url and sql.

v2.1.100 changed CREATE SCHEMA sql to CREATE CATALOG

v2.1.100 changed [schemas.]tableName@[catalog] format to [catalog.]tableName

v2.1.99 supports column numbers in ORDER BY clause

v2.1.98 supports Multiple-row VALUES tables.

v2.1.97 supports java.nio.channels.FileLock for JDBC3.0 on JDK1.4.X and JDK1.5.X so that JNIFile.zip become unnecessary.

v2.1.95 supports PowerPlus' lock.

v2.1.95 provided the 64-bit version of JNIFile.dll.

v2.1.90 supports incremental index naming schema.

v2.1.88 optimizes NTX index.

v2.1.86 supports MySQL Migration Toolkit v1.0.21

v2.1.85 optimizes CDX index and compressed IDX indx.

v2.1.82 supports aggregate function first(x), last(expression).

v2.1.80 supports function ATN(x), CBOOL(expression), CBYTE(expression), CDBL(expression), CINT(expression), CLNG(expression), CSNG(expression), CSTR(expression), and CDATE(expression).

v2.1.76 supports 76 kinds of MDX collation of Database Desktop.

v2.1.45 supports MDX language driver of Database Desktop.

2005-09-12 DBF v2.1 JDBC1.2 Package(764KB) JDBC2.0 Package(778KB) JDBC3.0 Package(802KB)

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.

CDX supports Slovak, Greek, Polish, Turkish, and Hungarian collation sequences.

supports VFP 9.0's BINARY INDEX.

supports VFP 9.0's Varchar, Varinary, and Blob columns.

provides automatic temporary index feature option.

works simultaneously with BDE's DBASE and FOXFRO driver.

supports Clipper's buffer concurrency check for NTX.

provides user/password verification for client/server mode.

2005-01-01 DBF v2.0 JDBC1.2 Package(666KB) JDBC2.0 Package(659KB) JDBC3.0 Package(674KB)

provides the quicker TCPServer to replace the slow RMIServer.

utilizes index for ORDER BY and DISTINCT.

supports CREATE SEQUENCE, DROP SEQUENCE, and ALTER SEQUENCE.

provides missingMemoFile properity to ignore or repair when memo file is missing.

provides Database GUI Manager.

NTX format is full compatible with DBU's balance tree.

provides collate function for multilingual sort.

supports Mazovia charSet.

supports [reserved word].

provides MD5 function.

supports SIx Driver tradition with its .SMT memos.

supports SIxMemo memo.

provides Table Encryption and Column Level Encryption.

provides BINARY, VARBINARY type

provides _LockFlag_ virtual column as row lock flag for Borland's dataset.

provides encrypt/decrypt function for Row-Column (Cell) Level Encryption.

supports lock/unlock record programatically.

supports Xbase applications' compatible lock on OS2.

supports Xbase applications' compatible lock on Linux.

2004-04-20 DBF v1.2 JDBC1.2 Package(343KB) JDBC2.0 Package(412KB) JDBC3.0 Package(426KB)

supports fully ALTER TABLE.

provides __rowid__ virtual column as primary key for Borland's dataset.

supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query operations.

supports INNER, FULL, LEFT, RIGHT, NATURAL, and CROSS JOIN.

supports subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery.

complements more than 30 sql functions.

optimizes some OR querys through index file.

tested DBF JDBC1.2 with Personal Java 3.1.

supports utilizing index file for LIKE, BETWEEN, and IN operations.

supports using other default suffix except for table and index file.

supports selecting based upon the column name defined in the .DBC container.

2003-10-22 DBF v1.1 JDBC1.2 Package(381KB) JDBC2.0 Package(361KB) JDBC3.0 Package(388KB)

supports Visual dBASE 7's table (DB2K format).

supports complicated HAVING clause, for instance, select int1 AS a,count(*) b,sum(int1) as c,count(*)+sum(INT1),a+c from test group by a having sum(test.iNT1)>3310 and b>1 or a<-3000

provides one string operator, || , for string concatenation. Both of + and - for string concatenation are still supported.

supports function DATABASE(), SYSDATE().

supports CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP keyword.

supports javax.sql.RowSet.

supports function IFNULL(expression, value).

supports java.sql.BLOB and java.sql.CLOB.

supports function COALESCE(value [, ...]).

2003-06-24 DBF v1.0 JDBC1.2 Package(376KB) JDBC2.0 Package(342KB) JDBC3.0 Package(365KB)

Development Documentation is available.

supports JDBC3.0 .

CDX supports CZECH collation sequence.

Quicken CREATE INDEX and REINDEX operation

supports [IF NOT EXISTS] for CREATE CATALOG, CREATE TABLE, CREATE INDEX. For instance, "CREATE CATALOG IF NOT EXISTS abc".

supports [IF EXISTS] for DROP TABLE, DROP INDEX. For instance, "DROP TABLE IF EXISTS test".

fixed a few known bugs.

2003-05-28 DBF Beta6.6 JDBC1.2 Package(371KB) JDBC2.0 Package(335KB)

supports DreamWeaver ColdFusion

supports "ALTER TABLE tbl_name alter_specification [, alter_specification, ...]". Only supports "alter table tbl_name RENAME [COLUMN] column TO newcolumn".

supports delayed transaction for PreparedStatement.

provides 2-level cache.

fixed a few known bugs.

2003-04-26 DBF Beta6.5 JDBC1.2 Package(350KB) JDBC2.0 Package(315KB)

supports function TRIM([[BOTH | LEADING | TRAILING] [remstr] FROM] str).

supports using column alias in any expression of SELECT statement.

supports aggregate function STD(expr) and STDDEV(expr).

supports function initcap(text), lpad(text,int,text), rpad(text,int,text), LEAST(X,Y,...), and GREATEST(X,Y,...). Now more than 100 sql or Xbase functions have been supported.

supports function DATE(), DATETIME(), TIME(), CTOD(cExpression) and CTOT(cCharacterExpression).

supports POSITION(substr,str) function.

supports EMPTY(eExpression) function.

quicken RECNO() query.

supports "CREATE CATALOG catalogName".

supports DbEdit Database Utilites for Eclipse Platform.

supports join query on more than two big databases without memory limitation.

optimize distinct, group by and order by for join query.

fixed a few known bugs.

2003-03-02 DBF Beta6.4 JDBC1.2 Package(340KB) JDBC2.0 Package(305KB)

"update tableName set _DeletedFlag=false[, column-identifier = {expression | NULL}]... [WHERE search-condition]" will unmarks records marked for deletion in the selected table.

Provided Clipper's function CHARMIRR(cExpression[,lDontMirrorSpaces]) to reverse a string.

Supported Clipper's DESCEND function.

Supported Clipper's encrypted header.

Clipper's CGP file has been supported.

Provided external sort for DISTINCT, GROUP BY, and ORDER BY clause.

fixed a few known bugs.

2002-11-21 DBF Beta6.3 JDBC1.2 Package(323KB) JDBC2.0 Package(287KB)
Provided function VAL(cExpression) to return a numeric value from a character expression composed of numbers.

Provided function RECCOUNT([nWorkArea | cTableAlias]) to returns the number of records, which includes all deleted records.

Provided "lockTimeout" property to declare how long in milliseconds DBF driver will wait for other Xbase applications to release record lock.
Besides VFP lock, the compatible lock of CLIPPER has been tested fully.

Provided function rowLocked([nWorkArea | cTableAlias]) to indicate whether the current row has been locked by other process or application.

Supported partly VFP's DBC, DCT, and DCX files. Now you can use "select yourColumn from yourDbc.yourTable".

Supported ObJectRelationalBridge(OJB).
old DBF URL format:
        Embedded:
                jdbc:dbf:[//]/[DatabasePath]
                        For example: "jdbc:dbf:/." "jdbc:dbf:/c:/dbffiles"
                For unix or linux:(You can't omit that "//" characters)
                        jdbc:dbf:///[DatabasePath]
                                For example: "jdbc:DBF:////usr/data" "jdbc:DBF:///./data"
        Access by DBF Server: Skip it if you don't use RMI or JINI.
                jdbc:DBF:[//][host][:port]/[DatabasePath]
            Default host:localhost port:8029 DatabasePath:
            For example: "jdbc:DBF://domain.com:3099/dbffiles" if one DBFServer is run on the 3099 port of domain.com

new DBF URL format:
        Embedded:
                jdbc:dbf:[//]/[DatabasePath] (You can omit that "//" characters)
                        For example:
                                "jdbc:dbf:/."
                                "jdbc:dbf:/c:/dbffiles"
                                "jdbc:DBF:/./data"
                                "jdbc:DBF://usr/data" for unix or linux.
                                "jdbc:DBF:////usr/data" for unix or linux.
        Remote Access (client/server mode):
                jdbc:DBF://host:port/[DatabasePath]
                        For example:
                                "jdbc:DBF://domain.com:3099/dbffiles" if one DBFServer is run on the 3099 port of domain.com
fixed a few known bugs.
2002-11-02 DBF Beta6.2 JDBC1.2 Package(279KB) JDBC2.0 Package(269KB)

supports "INSERT INTO table [(column [, ...])] SELECT query".

"delete from tableName where deleted()" will pack database.

supports ASC(cExpression), CHR(nANSICode), and IF(lExpression, eExpression1, eExpression2).

supports "REINDEX {ALL | indexFileName[,indexfiLEName2,...]} ON table-name".

Regards CANDIDATE as primary key in DatabaseMemtaData.getPrimaryKey().
Uses "OtherExtensions" property (Default:false) to indicate whether DBF driver supports other extensions except for '.DBF'.

Supports "INLIST(eExpression1, eExpression2 [, eExpression3 ...])" function.

fixed a few known bugs.

2002-10-15 DBF Beta6.1 JDBC1.2 Package(279KB) JDBC2.0 Package(267KB)

CDX supports RUSSIAN collation sequence.

deletesAreVisible property to indicates whether or not the resultSet include deleted records.

Compatible with DBVisualizer 3.0.

Changed the catalog term from "\" to ".".

complemented function TTOC(tExpression [, 1 | 2]), TTOD(tExpression), DTOT(dDateExpression), PADL(eExpression, nResultSize [, cPadCharacter]), PADR(eExpression, nResultSize [, cPadCharacter]) , PADC(eExpression, nResultSize [, cPadCharacter]), and STUFF(cExpression, nStartReplacement, nCharactersReplaced, cReplacement).

"delete from tableName where true" will zap database.

supports FlexFile3 memo.

fixed a few known bugs.

2002-08-26 DBF Beta6 JDBC1.2 Package(273KB) JDBC2.0 Package(260KB)

supports JDBC1.2 and JDK1.1.8.

supports Xbase applications' compatible lock.

fixed a few known bugs.

2002-05-06 DBF Beta5.4.1(288KB)

Join query has supported aggregation function, Group By and Order By.

fixed a few known bugs.

2002-04-02 DBF Beta5.4(292KB)

fixed a few known bugs.

2001-11-27 DBF Beta5.3(294KB)

supports GROUP, BETWEEN and IN.

work normally with JBuilder 5 Database Pilot and Dreamweaver UltraDev 4.

fixed a few known bugs.

2001-07-30 DBF Beta5.2(332KB)

supports DISTINCT and IS.

fixed a few known bugs.

2001-06-09 DBF Beta5.1(329KB)

complemented function IIF(lExpression, eExpression1, eExpression2).

fixed a few known bugs.

2001-03-13 DBF Beta5(337KB)

supports Multi-user Access.

complemented function DELETED([cTableAlias | nWorkArea]) and SUBSTR(cExpression, nStartPosition [, nCharactersReturned]).

fixed a few known bugs.

2000-12-24 DBF Beta4.21(317KB)

supports Clipper Index files (*.ntx).

complemented function ALLTRIM(string), DTOC(date) and CHRTRAN(cSearchedExpression, cSearchExpression, cReplacementExpression).

fixed a few known bugs.

2000-08-04 DBF Beta4.20(306KB)

supports Multiple Index files (*.mdx).

complemented XOPEN SQLState.

complemented PRIMARY KEY for CDX.

complemented function DTOS(date).

complemented "INSERT INTO tableName VALUES(value1[,value2,...])" syntax.

fixed a few known bugs.

1999-10-08 DBF Beta4.01(259KB)

enables update operation for uncompressed index files (*.idx).

fixed a few known bugs.

1999-09-12 DBF Beta4(255KB)
supports column alias.

supports derived column.

supports Statement.setFetchSize(int rows).

supports catalog and schema.

complemented most of functions of DatabaseMetaData.

complemented function LOWER(string) and UPPER(string).

enables Create Index statement and DROP Index statement for uncompressed index files (*.idx).

enables partly update operation for uncompressed index files (*.idx).

fixed a few known bugs.

1999-04-12 DBF Beta3(216KB)
enables Create Table statement and DROP TABLE statement.
enables ORDER BY clause.

supports LIKE Escape Characters.

complemented function RECNO([nWorkArea | cTableAlias]).

1999-03-08 DBF Beta2.2(226KB)
supports Jini1.0FCS and JNDI1.1.2 .

supports VFP's nullable column.

supports five aggregate functions: AVG, COUNT, SUM, MAX and MIN.

supports function STR(nExpression [, nLength [, nDecimalPlaces]]).

fixed a few known bugs.

1999-02-14 DBF Beta2.1(224KB)
supports scrolling and updatable resultset.

supports Clipper's DBT file according to one user's requirement.

1999-02-01 DBF Beta2(163KB)
supports Time and Date Literals.

supports all scalar Functions in jdbc-spec.frame11.html except DATABASE(), IFNULL(expression, value), USER() and CONVERT(value, SQLtype).

PreparedStatement to accept and store java objects in General field.

three kinds of IDX and CDX index files for query.

1999-01-11 DBF Beta1(140KB)

supports RMI, serialization and unicode character set.

supports xbase, foxpro and VFP free table.

supports all kinds of data except general type.

supported statements include query, delete, update and insert.

supports complicated expression and two functions(max and min).