Released Version Log
Latest feature:
- 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 ingored 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 remote access.
- v2.1.111 supports seamlessly files and directories in ZIP and GZIP file formats(ZIP,JAR,TAR) 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 remote access.
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.
Copyright © 2006 Hongxin Technology & Trade Ltd. | All Rights Reserved. |