HXTT Text (CSV)
Version
7.1.275
License
Shareware
Trial Limitations
30 days, at most 50 queries per session, SELECT returns the first 1,000 rows
Operating Systems
Windows, Linux, macOS, Unix, Solaris, AIX, FreeBSD and any OS with a Java VM
System Requirements
Any platform with a Java VM (Personal Java and JDK 1.0 to Java 14), JDBC 1.2 to 4.3 packages
File Size
1.77 MB
Release Date
7/13/2026
Last Updated
11/22/2026
1090 views 0 downloads
Pure Java type 4 JDBC driver for CSV, TSV, fixed-length and binary flat files

HXTT Text (CSV): Query CSV, Fixed-Length and Binary Files with SQL from Java

HXTT Text (CSV) is a pure Java (type 4) JDBC driver with a built-in database engine that turns a folder of CSV, TSV, fixed-length text or binary record files into SQL tables you can query, join and update from any Java program. It's for Java developers and DBAs who receive data as flat files and want real SQL over them on any platform. A Single Server License costs $221, one-time.

Flat files are everywhere: nightly CSV exports from an ERP, tab-separated logs, mainframe-style fixed-width reports, binary record files from an old instrument. The usual Java answer is a CSV parsing library plus a pile of hand-written filtering, grouping and joining code. HXTT Text (CSV) gives you a JDBC connection instead, so the work becomes SELECT ... JOIN ... GROUP BY, and tools such as Hibernate, Crystal Reports or DBeaver can read the same files.

Quick facts

  • Version: 7.1.275, built July 13, 2026
  • Developer: Heng Xing Tian Tai Lab of Xi'an City (HXTT), which also makes JDBC drivers for Access, DBF, Excel and Paradox
  • Platform: any operating system with a Java VM; JDBC 1.2, 2.0, 3.0, 4.0, 4.1, 4.2 and 4.3 packages
  • File types: CSV, TSV, PSV, UTF files with or without a BOM, fixed-length and variable-length text, Pascal-style strings, fixed and variable-length binary records
  • Price: $221 Single Server, $849 100 User Application, $1,402 Enterprise, $2,654 Unlimited Application; perpetual, with one year of free upgrades and email support
  • Trial: free 30-day evaluation package; it runs at most 50 queries per session and returns only the first 1,000 rows of a SELECT
  • Refunds: requested through 2Checkout within 30 days of the order
  • What we checked: the evaluation download text.zip (1.8 MB), whose Text_JDBC30.jar reports version 7.1.275 of July 13, 2026; order page prices of $221, $849, $1,402 and $2,654 for the four licenses, all lifetime, on November 22, 2026. We didn't run queries against our own files.

Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise LicenseBuy Unlimited Application License

Overview

HXTT Text (CSV) is a JDBC driver and a small database engine in one jar. Put the jar on your classpath, load com.hxtt.sql.text.TextDriver and connect with a URL such as jdbc:text:/c:/data. Every file in that folder becomes a table. CSV files work straight away: the driver reads the header line for column names and detects the data types itself, so there's nothing to declare.

Files with other layouts get a table definition once. You write a CREATE TABLE that describes the columns, widths and types, or point the schemaFile connection property at a file of such statements. If you're moving off the Microsoft ODBC text driver, the odbcSchemaFile property loads its schema.ini definitions as they are, which saves rewriting them. One definition can cover a whole family of files with wildcards, such as every *.log file in the folder.

The engine runs embedded inside your application, or as a separate server that other machines reach over TCP, RMI or Jini. The DBAdmin tool in the jar starts, stops and monitors that server and runs SQL against it; it can run as a Windows service, a Unix or Linux daemon or a normal program.

HXTT DBAdmin Server Connections view with two open connections and a record lock being released

DBAdmin, the server manager inside every HXTT driver jar, in an older Windows look. HXTT's sample shows two connections to a data folder and a record lock about to be released; this sample folder holds a DBF table.

Features

SQL over CSV with no setup

HXTT Text (CSV) opens CSV files without any table definition: it reads the header row and works out the column types. Connection properties cover the usual CSV variations: _CSV_Separator for semicolons, tabs, pipes or any character sequence (escapes such as \t work), _CSV_Header for files without a header line, _CSV_Comment to skip report titles above the header, and csvfileExtension when your files don't end in .csv. An ignoreDirtyData option lets it read malformed CSV with stray quote characters instead of stopping.

Fixed-length, variable-length and binary records

HXTT Text (CSV) also reads files that aren't delimited at all: fixed-width text reports, variable-length fields that end with a marker string, Pascal-style length-prefixed strings, and fixed or variable-length binary records. You describe the layout with CREATE TABLE, and HXTT offers to write sample code if you send them a file you can't work out how to define.

More than SQL-92

HXTT Text (CSV) supports nearly full ANSI SQL-92 plus many SQL:2008 additions: every join type, UNION, INTERSECT, EXCEPT and MINUS, all kinds of subqueries, common table expressions, GROUP_CONCAT, WITH ROLLUP and WITH CUBE, PIVOT and UNPIVOT, OFFSET and FETCH, and more than 230 SQL functions, with an API for your own. It also has PostgreSQL-style JSON operators (->, ->>, #>) for JSON stored in a text column. HXTT publishes PolePosition benchmark reports for its Text and CSV tests.

Files wherever they live

HXTT Text (CSV) reads tables from local folders, mapped drives and UNC paths, SMB shares (including Azure file shares), HTTP, HTTPS, FTP, FTPS and SFTP URLs (SFTP with a private key file), from inside ZIP, JAR, GZ, BZ2, 7z and TAR archives, from a Java InputStream, or as memory-only tables. One SQL statement can join a CSV on an FTP server with a table on the local disk.

Transactions, locks and security

HXTT Text (CSV) supports all four JDBC transaction isolation levels, multi-user access with record and table locks (a _LockFlag_ virtual column sets a row lock by hand), thread-safe concurrent connections, connection pooling, DataSource, RowSet and an experimental XA DataSource. Security options are user and password checks, SSL connections, and DES, Triple DES, Blowfish and AES encryption at the SQL or database level.

Character sets

HXTT Text (CSV) handles every encoding the Java VM supports, UTF files with or without a byte-order mark, and three old DOS code pages the JVM lacks: Cp895 (Czech), Cp620 (Polish) and Mazovia.

Benefits

  • Less parsing code. Filtering, sorting, grouping and joining flat files becomes SQL instead of loops over a CSV reader.
  • Works with Java tools you already use. Anything that takes a JDBC driver can read the files: report writers, ORMs, SQL clients.
  • An easy way off the ODBC text driver. Existing schema.ini definitions load as they are, and the same code runs on Linux.
  • The cheapest of HXTT's drivers, with a perpetual license and a year of upgrades included.

Real-World Uses

  • Reconciling exports: a finance team's Java job joins a bank's daily CSV with an ERP export and writes the mismatches to a report.
  • Legacy reports: a developer defines a mainframe's fixed-width text report once with CREATE TABLE and queries it like a table.
  • Feeds from partners: a nightly job reads pipe-delimited files from a supplier's SFTP server, inside a ZIP, without unpacking them.
  • Reporting on log files: a wildcard table definition covers every rotated *.log file, and Crystal Reports or JasperReports groups the entries by day.
  • Prototyping: an application is built and tested against CSV files before the real database exists.

Who It's For, and Who Should Skip It

HXTT Text (CSV) is for Java developers, integrators and DBAs whose data arrives as CSV, TSV, fixed-width or binary record files and who want SQL over them inside a Java application or a Java-based reporting tool, on Windows or any other system.

Skip it if you don't write Java: it's a library, not a spreadsheet or a CSV editor, so a desktop CSV tool fits better for looking at files by hand. If all you need is to load a CSV into an existing database once, that database's own import command is free. And for .NET or ODBC applications, look for a driver built for those platforms.

Usage Guide

  1. Download the evaluation package (text.zip) and unzip it. It holds the JDBC 3.0 jar, documentation and demo programs; the other JDBC packages are available after registering on HXTT's site.
  2. Add the jar to your classpath, for example -cp Text_JDBC30.jar, or copy it into your application server's library folder. For Maven, install it into your local repository with mvn install:install-file.
  3. Load the driver com.hxtt.sql.text.TextDriver and connect with jdbc:text:/your/data/folder for embedded use, or jdbc:text://host:port/folder for a remote server.
  4. Query a CSV file by its file name, for example SELECT * FROM orders for orders.csv. Set _CSV_Separator or _CSV_Header in the connection properties if your files differ from the defaults.
  5. Define other layouts with CREATE TABLE, or load them from a schema file or schema.ini.
  6. Open DBAdmin with java -classpath Text_JDBC30.jar com.hxtt.sql.admin.Admin to manage a server.
  7. Buy the license that matches how you'll deploy it (see the table below) before the evaluation period ends.

Where it falls short

  • The trial is limited. The evaluation jar runs at most 50 queries per session, returns only the first 1,000 rows of a SELECT, and after 30 days throws "No suitable driver" and "Evaluation period over", so test with a sample of your files rather than the full set.
  • Non-CSV files need a definition. Fixed-width and binary files only work once you've described them with CREATE TABLE, which takes some trial and error for an unfamiliar format.
  • Flat files aren't a database server. Updates rewrite text files, so for heavy concurrent writing a real database is the better home for the data; this driver shines at reading and moderate updating.
  • Updates are included for one year. After that, upgrades and support are a yearly renewal.
  • Dated website and tools. The documentation is thorough but terse, the listed Java versions stop at Java 14, and DBAdmin has an old Java look.

Comparisons

HXTT Text (CSV) vs a CSV parsing library

Free Java libraries such as a CSV reader give you rows as string arrays, and everything after that, from types to filters to joins, is your code. HXTT Text (CSV) gives you SQL, typed columns, indexes, transactions and JDBC compatibility, so other tools can use the files too. A free parser is enough for a simple one-file import; the driver earns its price when you query, join or report on many files.

HXTT Text (CSV) vs the Microsoft ODBC text driver

The ODBC text driver only runs on Windows, needs a JDBC-ODBC bridge that Java 8 removed, and offers limited SQL. HXTT Text (CSV) is pure Java, reads the same schema.ini definitions, and adds fixed-length and binary files, remote and compressed files, and a server mode.

Editions and Pricing

LicensePriceWhat it coversBuy
Single Server License$221Unlimited connections on a single serverBuy Single Server
100 User Application License$849Unlimited connections; redistribute 100 times with one commercial productBuy 100 User
Enterprise License$1,402Unlimited connections and servers, within one company in one countryBuy Enterprise
Unlimited Application License$2,654Unlimited connections; unlimited deployment with one commercial productBuy Unlimited Application

Every license includes one year of free online upgrades and technical support by email and forum. HXTT offers bulk discounts on the order page.

FAQs

Can HXTT Text (CSV) read semicolon-separated or tab-separated files?

Yes. HXTT Text (CSV) takes any separator through the _CSV_Separator connection property, including escapes such as \t for tabs, and reads TSV and PSV files as well as CSV.

Does HXTT Text (CSV) need a table definition for every file?

No, not for CSV. HXTT Text (CSV) detects column names and types from a CSV file by itself. Fixed-length, variable-length and binary files need a CREATE TABLE definition, which can be one wildcard definition for many files with the same layout.

Can HXTT Text (CSV) update and insert rows, or only read?

HXTT Text (CSV) supports INSERT, UPDATE and DELETE as well as SELECT, with transactions and record and table locks for multi-user access. It can also create new CSV files with CREATE TABLE.

Can I use my existing schema.ini from the Microsoft text driver?

Yes. HXTT Text (CSV) says it is backward compatible with the Microsoft ODBC text driver and loads its schema file through the odbcSchemaFile connection property.

Does HXTT Text (CSV) work with Hibernate, Tomcat and DBeaver?

Yes. HXTT Text (CSV) is a standard JDBC driver with DataSource and connection pooling support, and HXTT's FAQ gives setup steps for Hibernate, Tomcat, JBoss, WebSphere, GlassFish, ColdFusion, DBeaver, JasperSoft Studio and Maven projects.

Which license do I need to ship HXTT Text (CSV) inside my own software?

To redistribute HXTT Text (CSV) with a commercial product, the 100 User Application License covers 100 copies of one product and the Unlimited Application License covers unlimited copies of one product. The Single Server and Enterprise licenses are for running it on your own servers.

Can HXTT Text (CSV) read files from an FTP server or inside a ZIP?

Yes. HXTT Text (CSV) accepts HTTP, HTTPS, FTP, FTPS, SFTP and SMB locations and archive files (ZIP, GZ, BZ2, 7z, TAR) directly in the JDBC URL and in SQL, so a remote zipped CSV can be queried without downloading and unpacking it first.

How do I get a refund?

Orders for HXTT Text (CSV) placed online are handled by 2Checkout, which accepts refund requests up to 30 days from the order date.

System Requirements

  • Any operating system with a Java VM: Windows, Linux, macOS, Unix, Solaris, AIX, FreeBSD and others
  • Java from Personal Java and JDK 1.0 through Java 14, with the matching JDBC 1.2 to 4.3 package

Conclusion

HXTT Text (CSV) is worth its $221 Single Server price if your Java application or reporting tool has to work with flat files and you're tired of writing parsing and grouping code by hand. The one reason to buy it is real SQL, with joins, aggregates and updates, over CSV, fixed-width and binary files on any platform, in a driver that's still maintained, with a build from July 2026. The main reason not to is that a free CSV library or a database's import command covers simple one-off jobs. Try it on your own files with the 30-day evaluation, then pick the license that matches how you'll deploy it.

Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise LicenseBuy Unlimited Application License

Other Software Products by HXTT:
1) HXTT Json
2) HXTT Word
3) HXTT PDF
4) HXTT XML
5) HXTT Cobol
6) HXTT Excel
7) HXTT Paradox
8) HXTT DBF
9) HXTT Access

We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.