Latest feature:

• v4.1.011 fixed a bug on ResultSet.last() since v4.0.046.
• v4.1.010 provides LASTNVL(cTableName, cColumnName) which is useful when data are stored by using suppression of repeated data.
• 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.001 provides _CSV_ColumnCount4EmptyFile connection property to specify the default column count for an empty text file without header information and data rows.

2008-07-23 Text v4.1 JDBC1.2 Package(868KB) JDBC2.0 Package(860KB) JDBC3.0 Package(906KB)

• v4.0.038 provides _CSV_EOL connection property to specify 1~2 character sequence to terminate one line.
• v4.0.036 supports GROUP_CONCAT function.
• v4.0.034 supports lower(upper) function in LIKE expression.
• v4.0.026 provides decimalFormat, decimalSeparator, and groupingSeparator connection property to specify the default parse sequence of decimal number format.
• v4.0.016 provides dateFormat, timeFormat and timestampFormat connection property to specify the default parse sequence of date, time, and timestamp formats.
• 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 Text v4.0 JDBC1.2 Package(877KB) JDBC2.0 Package(868KB) JDBC3.0 Package(915KB)

• For data export purpose, v3.1.085 will detect numeric(precision, scale) type and varchar(maxDataLength) type when maxScanRows=0 and readOnlyMode=true. ResultSetMetaData.getColumnDisplaySize() can still be used to know the max data length for all data types.
• v3.1.084 replaced "? Expression" with "SELECT select_list".
• v3.1.081 fixed a bug on data type detection since v3.1.063.
• v3.1.080 provides SHA1 function besides MD5 and Crypt3.
• v3.1.079 can parse all kinds of date, time, and timestamp format, without prefined date format, or default date format.
• v3.1.070 uses the first CSV line information to verify predefined CREATE TABLE sql when _CSV_Header=true.
• 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.004 will append \r\n terminator for insert row at once to support lame Perl chop code.
• v3.1.004 supports to detect automatically BOOLEAN type. Old package supports date type detection for VARCHAR, DATE, TIME, TIMESTAMP, INT, BIGINT, and DOUBLE.
• v3.1.001 supports SAMBA table, which needn't to map or mount driver.

2007-01-11 Text v3.1 JDBC1.2 Package(856KB) JDBC2.0 Package(847KB) JDBC3.0 Package(893KB)

• v3.0.048 optimizes memory occupation for UNION ALL.
• v3.0.044 added CP850, CP852, CP866, CROATIAN, HEBREW, and SWEDISH sort for COLLATE function.
• v3.0.030 provides ignoreDirtyXML connection property for invalid XML characters in string value.
• v3.0.027 provides ignoreDirtyData connection property for number value or date value.
• v3.0.027 provides function getNumber, getInt, getLong, and getDouble for dirty data.
• v3.0.025 fixed a bug in pack csv table.
• v3.0.020 provides DTOS(date1 | timestamp1,pattern) for date conversion.
• v3.0.019 supports to detect automatically and utilize byte-order marker (BOM) in UTF file for CSV, TSV, and PSV.
• 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.013 supports to load schemaFile and odbcSchemaFile from any (absolute or relative) path, even you can load it from http url or compressed file.
• v3.0.007 provides STRZERO(nExpression, nLength[, nDecimals]) function.
• v3.0.006 provides POSIXTOT and TTOPOSIX for POSIX timestamp conversion.

2006-08-07 Text v3.0 JDBC1.2 Package(939KB) JDBC2.0 Package(926KB) JDBC3.0 Package(970KB)

v3.0.001 fixed a bug in parsing int column since v2.3.038.

v2.3.038 optimizes speed for parsing CSV/TSV/PSV files with a large number of columns, for instance, 3000 columns.

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

v2.3.022 supports Pascal Style Strings. It's easy to extract data from Turbo Pascal applications now.

v2.3.019 supports PIVOT and UNPIVOT.

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

v2.3.003 fixed a bug in update transaction on csv table.

2006-05-17 Text v2.3 JDBC1.2 Package(810KB) JDBC2.0 Package(802KB) JDBC3.0 Package(847KB)

• v2.2.025 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.016 supports using common file in url to set csvfileExtension property. For instance, jdbc:text:/f:/textfiles/a.txt?_CSV_Header=true, then you can use select * from "a.txt", select * from a.txt, or select * from a.
• v2.2.016 provides TABLELOCKED(cTableName) function.
• v2.2.015 provides _CSV_Comment to specify whether ther're some comment lines before csv header and data rows. If you use n (integer values), the first n lines will be ignored as comment. If you use some paragraphs, these paragraphs will be used for csv file creation, the total line number of comment will be used for existent file.
• v2.2.008 uses automatic temporary index to quicken subquery sql.
• v2.2.002 provides lock table and unlock table sql.

2006-03-07 Text v2.2 JDBC1.2 Package(769KB) JDBC2.0 Package(784KB) JDBC3.0 Package(820KB)

• v2.2.001 provide maxScanRows for auto data type detection.
• v2.1.125 uses automatic temporary index to quicken join sql.
• v2.1.125 provides automatic temporary index feature option.
• v2.1.122 optimizes IN, NOT IN, ALL, and ANY on subquery.
• v2.1.122 provides universal table declaration for a series of tables with the same table structure. '?' represents any single character, and '*' represents a string of zero or more characters. For instance, create table "*.log" (...); create table [*a?b.*"] (...). Universal table declaration is only visible for the current connection, and isn't prior to any specific table declaration.
• v2.1.115 provides SSL connection and customer connection for client/server mode.
• v2.1.111 supports seamlessly files and directories in ZIP and GZIP file formats(.ZIP, .JAR, .GZ) in jdbc url and sql.
• v2.1.102 changed CREATE SCHEMA sql to CREATE CATALOG
• v2.1.102 changed [schemas.]tableName@[catalog] format to [catalog.]tableName
• v2.1.101 provides readonly mode for speed optimization
• v2.1.100 supports column numbers in ORDER BY clause
• v2.1.98 supports Multiple-row VALUES tables.
• v2.1.92 supports readonly database, for instance, CD and DVD.
• v2.1.89 supports jdbc:csv://[host:port]/[DatabasePath] url also, except for jdbc:text://[host:port]/[DatabasePath].
• v2.1.86 optimizes speed.
• v2.1.84 supports MySQL Migration Toolkit v1.0.21
• v2.1.82 supports aggregate function first(x), last(expression).
• v2.1.82 provides solo mode for speed optimization.
• v2.1.81 supports escape processing for _CSV_Separator and _CSV_Quoter.
• 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.40 provides com.hxtt.sql.text.OpenAPI.loadSchemaIniFile function for ODBC schema file.

2005-09-12 Text v2.1 JDBC1.2 Package(731KB) JDBC2.0 Package(745KB) JDBC3.0 Package(770KB)

• 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 function and connecton property to load odbc schema file for table structure definition
• 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 Text V2.0 JDBC1.2 Package(632KB) JDBC2.0 Package(624KB) JDBC3.0 Package(640KB)

• provides the quicker TCPServer to replace the slow RMIServer.
• supports variable-length file.
• utilizes index for ORDER BY and DISTINCT.
• provides "schemaFile" properity to load many prepared table definition SQL.
• supports CREATE SEQUENCE, DROP SEQUENCE, and ALTER SEQUENCE.
• provides Database GUI Manager.
• 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.

2004-07-21 Text v1.0 JDBC1.2 Package(306KB) JDBC2.0 Package(380KB) JDBC3.0 Package(399KB)

• Development Documentation is available.
• supports CREATE INDEX.
• fixed a few known bugs.

2003-12-21 Text Beta 1.2 JDBC1.2 Package(271KB) JDBC2.0 Package(352KB) JDBC3.0 Package(375KB)

• 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.
• fixed a few known bugs.

2003-06-24 Text Beta 1.1 JDBC1.2 Package(260KB) JDBC2.0 Package(332KB) JDBC3.0 Package(356KB)

• supports JDBC3.0 and JDBC1.2 .
• fixed a few known bugs.

2003-05-20 Text Beta 1.0 JDBC2.0 Package(342KB)

• supports SQL92 syntax, which includes INSERT, UNDATE, AND DELETE.
• support multi-access.
• supports CSV(Comma Separated Value) file and binary file.