Latest feature:

• 2013-05-02 fixed a bug for Union ALL with where-clause.
• 2013-04-28 v2.0.133 fixed an insert rowid bug when using transcation mode.
• 2013-04-11 ALFRED can read normally the modified AcuCobol VIX index file.
• 2013-04-06 LIKE/ILIKE supports complicated expression as string pattern.
• 2013-03-11 v2.0.117 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
• 2013-02-02 v2.0.106 fixed a bug for update AcuCobol VIX index file since v2.0.104.
• 2013-01-27 v2.0.105 can utilize index file for children columns on any level.
• 2013-01-13 v2.0.104 allows update AcuCobol VIX index file.
• 2012-12-13 v2.0.098 accepts '\0' as S token for AcuCobol COMP-3 data type.
• 2012-12-11 v2.0.097 provides SPLIT(expression,delimiter) function.
• 2012-11-14 v2.0.095 enables the support for Micro Focus indexed file format 3.
• 2012-11-09 v2.0.093 supports AES(128/192/256) for encrypt,decrypt,encode/decode function.
• 2012-10-23 v2.0.087 quicken IN on subquery with more than 100,000 data rows.
• 2012-10-20 v2.0.084 supports NUMBER[(n1[,n2])] for CREATE TABLE sql.
• 2012-10-04 v2.0.080 supports XML format for SELECT ... INTO OUTFILE syntax.
• 2012-10-01 v2.0.079 optimizes long varchar type of temporary index.
• 2012-09-27 v2.0.079 supports seamlessly sftp url database in jdbc url and sql.
• 2012-07-07 v2.0.064 supports CSV format for SELECT ... INTO OUTFILE syntax.
• 2012-06-14 v2.0.060 provides FDDIR connection property to assign a different file description directory with data directory. tableName.fileDescriptionExtension can be used to match tableNameDDD.fileExtension data file. For instance, ABANA.FD can be used to match ABANA777.dat file.
• 2012-06-07 v2.0.057 fixed a join query bug since v2.0.051.
• 2012-05-16 v2.0.051 uses automatic temporary index to quicken join sql.
• 2012-05-13 v2.0.049 supports query on VIX index file of AcuCobol Vision Version 4.
• 2012-05-13 v2.0.049 supports compression format of AcuCobol Vision Version 4.
• 2012-05-10 v2.0.047 supports X2 variable of IDXFORMAT"4" for Micro Focus.
• 2012-05-09 v2.0.046 supports query on VIX index file of AcuCobol Vision Version 5.
• 2012-05-04 v2.0.045 supports "_" to replace "-' in column name directly in SQL. For instance, Both of "Cod-Att-Tessera" and Cod_Att_Tessera can be used for "Cod-Att-Tessera" column.
• 2012-05-04 v2.0.045 supports " *> " following comment.
• 2012-02-25 v2.0.031 supports Statement.setQueryTimeout.
• 2012-02-18 v2.0.028 supports query on RM-Cobol RMKF index file.
• 2012-02-10 v2.0.026 supports query on SCHEMATA, TABLES, COLUMNS of INFORMATION_SCHEMA schema.
• 2012-01-06 v2.0.022 supports query on AcuCobol Vision Version 3.
• 2011-12-22 v2.0.021 supports IDXFORMAT"4" for Micro Focus.
• 2011-11-29 v2.0.015 skips system rows which mix with data rows for Micro Focus.
• 2011-11-28 v2.0.014 fixed a multi-row cache bug for Micro Focus Compression Routine CBLDC001 since v2.0.007.
• 2011-11-10 v2.0.007 supports Micro Focus Compression Routine CBLDC001.
• 2011-11-07 v2.0.006 provides five regular expression functions(REGEXP_COUNT, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, and REGEXP_SUBSTR)
• 2011-11-04 v2.0.005 optimizes speed for DISTINCTROW on multi tables.

2011-10-11 Cobol v2.0 JDBC1.2 Package(1133KB) JDBC2.0 Package(1118KB) JDBC3.0 Package(1164KB) JDBC4.0 Package(1269KB) JDBC4.1 Package(1273KB)

• v2.0.001 supports JDBC 4.1.
• v1.1.028 support one variable X3 version format of Micro Focus varible indexed file
• v1.1.028 will use aname.fileDescriptionExtension(cpy', 'fd', 'sel', 'cbl', and 'cob') to match anameNN.dat( which NN is a digit letter) if it failed to find file description
• v1.1.026 provides fileDescriptionExtension to indicate whether Cobol driver supports other extension beside 'cpy', 'fd', 'sel', 'cbl', and 'cob' as default file description extension. The supported formats inlcude Cobol source code file, Copybook file, FD file, and SEL file.
• v1.1.020 supports PIVOT expression besides column.
• v1.1.019 supports [START WITH initial-condition] CONNECT BY [NOCYCLE] recurse-condition. level is a pseudo column that can be used in hierarchical queries.
• v1.1.002 supports CREATE VIEW and DROP VIEW.

2011-04-05 Cobol v1.1 JDBC1.2 Package(891KB) JDBC2.0 Package(927KB) JDBC3.0 Package(972KB) JDBC4.0 Package(1065KB)

• It supports AcuCobol relative file since v1.0.023.
• It supports MicroFocus VB sequential file, and MicroFocus VB relative file since v1.0.018.
• It parse COPY and REPLACE since v1.0.011.
• SELECT ... FOR UPDATE will lock all the selected rows for transaction until transaction commit or rollback even if you close that ResultSet since v1.0.010.
• 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 v1.0.008.

2010-08-15 Cobol v1.0 JDBC1.2 Package(859KB) JDBC2.0 Package(895KB) JDBC3.0 Package(937KB) JDBC4.0 Package(1026KB)

• supports create/query/update Cobol data file.
• supports retrieve record layout according Cobol Copybook file and Cobol source program.
• supports ASCII encoding (PC Cobol), and EBCDIC encoding (IBM mainframe).
• 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, RENAME TABLE, SELECT, INSERT, UPDATE, and DELETE sql.
• Development Documentation is available.
• supports JDBC4.0, JDBC3.0, JDBC2.0 and JDBC1.2.