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.
• 2024-02-19 fixed a seldom compatible bug on udpating ACUCOBOL V3 format file.
• 2023-05-09 supports to read Large indexed (IDXFORMAT 8) file of Micro Focus, but write operation is riskful without compatible test.
• 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-02-11 fixed a bug on reading ACUCOBOL V3 format file with only one data row.
• 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-10-23 supports a seldom xfd file sample generated by ACUCOBOL-GT v4.3.0.
• 2020-10-16 provides _tablemap_(Pseudo Variable) so that different data files can share one table structure file(.xdf,.cpy,.sel,.cob, .cbl, .fd).
• 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 Cobol v5.0 JDBC4.3 Package(1730KB) JDBC4.2 Package(1733KB) JDBC4.1 Package(1721KB) JDBC4.0 Package(1718KB) JDBC3.0 Package(1582KB) JDBC2.0 Package(1522KB) JDBC1.2 Package(1544KB)

• 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 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-06-25 provides _values_ as a pseudo name for all values in a data row.
• 2019-03-18 supports two crypt formats for AcuCobol Vision 5 data file.
• 2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.

2018-11-25 Cobol v4.0 JDBC4.3 Package(1669KB) JDBC4.2 Package(1672KB) JDBC4.1 Package(1661KB) JDBC4.0 Package(1657KB) JDBC3.0 Package(1497KB) JDBC2.0 Package(1437KB) JDBC1.2 Package(1459KB)

• 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-23 supports invalid compressed size for RM Cobol compressed index/data file.
• 2018-04-12 needn't to encode special character for http/https url.
• 2018-03-19 fixed a bug for binary search row id on JOIN table.
• 2018-02-20 provides more support for missed columns in XFD file.
• 2018-02-02 can split multivalue column into rows through special subquery table.
• 2018-01-17 provides sameColumnName_X_n format to support duplicated column name in CPY file.
• 2018-01-16 fixed a bug for array column value.

2017-08-02 Cobol v3.0 JDBC1.2 Package(1393KB) JDBC2.0 Package(1373KB) JDBC3.0 Package(1433KB) JDBC4.0 Package(1585KB) JDBC4.1 Package(1588KB) JDBC4.2 Package(1599KB)

• 2017-06-30 PreparedStatement.executeBatch suupports RETURN_GENERATED_KEYS.
• 2016-09-30 provides Pseudo Table INFORMATION_PARSER.sql for SQL syntax analysis feature.
• 2016-08-08 add a special feature to allow more than one FD files on the same data file. For instance, you have an hotpreis.xfd and an hotpreis. Now you define a schluesseluebergabe.xfd, and a schluesseluebergabe.sel( which contains only one line: select schluesseluebergabe assign to hotpreis.) Then "select * from schluesseluebergabe" will use schluesseluebergabe.xfd to access hotpreis file. The limitation is you can NOT use two xfd files at the same file at the same time.
• 2016-06-21 supports compression format of AcuCobol Vision Version 5.
• 2016-06-16 will try to load all table informations in WORKING-STORAGE.CBL,FILE.CBL, and FILE-CONTROL.CBL, if set dir4fileDescription connection property.
• 2016-05-20 supports XFD version 3.
• 2016-04-26 quicken query speed for big AcuCobol Vision 3 file.
• 2016-04-22 provides ODBCTrimBehavior, caseInsensitive, emptyDecimalAsZero, and emptyStringAsNull connection property.
• 2016-03-23 provides refreshIntervalfor ftp/sftp protocol
• 2016-03-23 supports DatabaseMetaData.getTables for ftp/sftp protocol
• 2016-02-09 supports write AcuCobol Vision 3 file.
• 2016-02-04 supports escape character '\' in pattern for DatabaseMetaData.
• 2016-01-27 supports omited filled column information for XFD version 4.
• 2016-01-21 AcuCobol data verification will ignore the invalid file size information from vutil.
• 2015-04-30 supports write sftp protocol data file.
• 2015-01-31 provides extra copybooksyntax (OCCURS n TIMES DEPENDING ON name = value) for variable-length file. For intance, 01 RIVER OCCURS 1 TIMES DEPENDING ON TYPE=2.
• 2015-01-31 supports column name contains parentheses in copybook.
• 2014-09-02 supports write ftp protocol data file.
• 2014-05-08 v5.2.001 supports JDBC 4.2.

2014-05-08 Cobol v2.1 JDBC1.2 Package(1363KB) JDBC2.0 Package(1344KB) JDBC3.0 Package(1403KB) JDBC4.0 Package(1527KB) JDBC4.1 Package(1531KB) JDBC4.2 Package(1541KB)

• 2014-05-08 v2.1.001 supports JDBC 4.2.
• 2013-11-19 fixed a value fetch bug on two dimension array column.
• 2013-10-09 supports NTLM Authentication for SAMBA url or SAMBA absolute path.
• 2013-09-11 provides dir4fileDescription connection property to assign a different directory for file descriptor. If file descriptor is at the same directory of data file, you needn't that connection property. The older FDDIR connection property is still supported.
• 2013-09-11 supports XFD (EXtended File Descriptor), which includes XML format(version 6) and text format(version 4 and 5).
• 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-06-07 will read correctly Packed Decimal arrays when OCCURS>1 .
• 2013-06-04 will use always charSet connection property.
• 2013-05-31 parses correctly an unknown AcuCobol VIX format 5 sample.
• 2013-05-30 will use charSet connection property if failed to detect automatically charSet of data file.
• 2013-05-30 supports string value for <VALUE> <OF> ( NAME <IS> ( QualifiedDataName | Literal ) )+ syntax .
• 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-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.