HXTT Cobol: Query COBOL Data Files with SQL from Java
HXTT Cobol is a pure Java (type 4) JDBC driver that reads COBOL data files, from mainframe fixed-block and variable-block files to Micro Focus and ACUCOBOL Vision files, as SQL tables, using your existing copybooks for the record layout. It's for Java developers, migration teams and DBAs who need to get at data that a COBOL system wrote. A Single Server License costs $385, one-time.
COBOL data doesn't look like anything a modern tool expects: EBCDIC text, packed-decimal COMP-3 numbers, REDEFINES that give one set of bytes two meanings, OCCURS tables repeated inside a record. Usually someone writes a one-off converter for every file. HXTT Cobol reads the layout from the copybook the COBOL programs already use and gives you a JDBC connection, so the data can be queried, joined and copied with SQL.
Quick facts
- Version: 5.0.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 CSV files
- 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
- Files: FB and VB sequential and relative files, IBM mainframe and PC line sequential files, Open Cobol, Fujitsu NetCOBOL and Micro Focus VB files, ACUCOBOL Vision files
- Layouts from: copybooks, COBOL source programs, FD, XFD and SEL files
- Price: $385 Single Server, $1,868 100 User Application, $2,720 Enterprise; 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 100 rows of a SELECT
- Refunds: requested through 2Checkout within 30 days of the order
- What we checked: the evaluation download cobol.zip (1.9 MB), whose Cobol_JDBC30.jar reports version 5.0.275 of July 13, 2026; order page prices of $385, $1,868 and $2,720 for the three licenses, all lifetime, on November 22, 2026. We didn't run it against COBOL files of our own.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License
Overview
HXTT Cobol combines a JDBC driver with a small database engine in one jar. Load com.hxtt.sql.cobol.CobolDriver, connect with a URL such as jdbc:cobol:/c:/data, and the data files in that folder become tables (files ending in .DAT by default; the fileExtension property changes that).
The driver detects the file organisation by itself across fixed-block, variable-block, sequential, relative and line sequential files, and loads the record layout from a copybook, a COBOL program in free or fixed format (including Fujitsu-Siemens and Tandem NonStop styles), or FD, XFD and SEL files. It knows the dialects of COBOL 68, 74 and 85, IBM COBOL and COBOL II, Micro Focus, RM, ACUCOBOL, Fujitsu, AS/400, CA Realia, Tandem NonStop and Open Cobol. One layout file can serve many data files through the _tablemap_ mapping.
Like HXTT's other drivers, it runs embedded in your application or as a separate server, and the DBAdmin tool in the jar starts, stops and monitors that server as a Windows service, a Unix or Linux daemon or a normal program.
DBAdmin, the server manager inside every HXTT driver jar, in an older Windows look, ending a connection from the Server Connections view. HXTT's sample connection points at a DBF folder.
Features
Every COBOL data type
HXTT Cobol decodes BINARY, COMP, COMP-1 to COMP-6, COMP-X, DISPLAY, DISPLAY-1, NATIONAL and PACKED-DECIMAL fields, in ASCII or EBCDIC, and SQL can select any elementary, redefined, repeated (OCCURS) or array column, with no separate data dictionary to build. The charSet property sets the text encoding.
Micro Focus and ACUCOBOL indexed files
HXTT Cobol reads ACUCOBOL Vision data files and, since May 2023, large Micro Focus indexed files (IDXFORMAT 8). It can update files too, though HXTT warns that writing to IDXFORMAT 8 files hasn't been compatibility-tested, so treat those as read-only.
More than SQL-92
HXTT Cobol supports nearly full ANSI SQL-92 plus many SQL:2008 additions: every join type, UNION, INTERSECT and EXCEPT, 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. For ETL it adds XML_TABLE, JSON_TABLE and VALUES_TABLE table objects, and HXTT says GROUP BY, ORDER BY and DISTINCT work on tables with millions of rows.
Files wherever they live
HXTT Cobol reads files from local folders, mapped drives and UNC paths, SMB shares (including Azure file shares), HTTP, HTTPS, FTP, FTPS and SFTP URLs, from inside ZIP, JAR, GZ, BZ2, 7z and TAR archives, from a Java InputStream, or as memory-only tables. That suits mainframe extracts that arrive by FTP in an archive.
Transactions, concurrency and security
HXTT Cobol supports all four JDBC transaction isolation levels, multi-user access, thread-safe concurrent connections, connection pooling, DataSource, distributed transactions and RowSet, plus user and password checks, SSL connections, and DES, Triple DES, Blowfish and AES encryption.
Benefits
- No hand-written converters. The copybooks you already have describe the data; the driver does the decoding.
- Migration with SQL. Copy COBOL files into PostgreSQL, SQL Server or Oracle with ordinary JDBC tools, and check the result with queries.
- Runs off the mainframe. Pure Java, so the same jar works on Windows, Linux or a Mac.
- A perpetual license with a year of upgrades and support included.
Real-World Uses
- Mainframe migration: a team copies EBCDIC VB files with COMP-3 amounts into a relational database, table by table, using the original copybooks.
- Reporting on a live COBOL system: a Java report or a BI tool reads a Micro Focus or ACUCOBOL application's data files without touching the COBOL code.
- Data validation: after a conversion, SQL joins between the old COBOL file and the new table find the rows that don't match.
- Daily extracts: a scheduled job pulls a zipped extract from an FTP server and queries it in place.
Who It's For, and Who Should Skip It
HXTT Cobol is for Java developers, integrators and migration teams who have COBOL data files and copybooks and want SQL access to that data from Java, without writing a parser for each record layout.
Skip it if you don't work in Java: it's a library, not a file viewer, so a COBOL data viewer or a mainframe file transfer tool with conversion fits better for looking at a file by hand. If your COBOL data lives in DB2 or another database rather than in files, use that database's own driver. And for writing to Micro Focus IDXFORMAT 8 files, HXTT itself doesn't vouch for it yet.
Usage Guide
- Download the evaluation package (cobol.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.
- Put your data files and their copybooks in one folder, and add
Cobol_JDBC30.jar to your classpath.
- Load the driver
com.hxtt.sql.cobol.CobolDriver and connect with jdbc:cobol:/your/folder, or jdbc:cobol://host:port/folder for a remote server. Set charSet for EBCDIC data.
- Query a file as a table and check a few records against what the COBOL program shows.
- Open DBAdmin with
java -classpath Cobol_JDBC30.jar com.hxtt.sql.admin.Admin if you run it as a server.
- Buy the license that fits how you'll deploy it before the evaluation period ends.
Where it falls short
- The trial is tight. The evaluation jar runs at most 50 queries per session, returns only the first 100 rows of a SELECT, and stops after 30 days, enough to check that your layouts decode but not to run a migration.
- Unusual layouts can take work. Vendor-specific file formats are where conversions go wrong; HXTT's history lists fixes for rare ACUCOBOL and XFD variants, so test your own files early.
- Writing to large Micro Focus indexed files is untested by HXTT's own account.
- Updates are included for one year. After that, upgrades and support are a yearly renewal. Redistributing it in your product needs the $1,868 license.
- Dated website and tools. The documentation is thorough but terse, and DBAdmin has an old Java look.
Comparisons
HXTT Cobol vs writing your own converter
A custom program can decode one known layout, but every new copybook, REDEFINES or OCCURS clause means more code, and the result is usually a flat export. HXTT Cobol reads the layouts as they are and gives you SQL and JDBC, so the same driver covers every file and feeds any Java tool. A one-off converter only makes sense for a single small file.
Editions and Pricing
| License | Price | What it covers | Buy |
| Single Server License | $385 | Unlimited connections on a single server | Buy Single Server |
| 100 User Application License | $1,868 | Unlimited connections; redistribute 100 times with one commercial product | Buy 100 User |
| Enterprise License | $2,720 | Unlimited connections and servers, within one company in one country | Buy Enterprise |
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 Cobol read EBCDIC files from an IBM mainframe?
Yes. HXTT Cobol reads EBCDIC as well as ASCII data, including IBM mainframe line sequential and fixed-block and variable-block files, with the encoding set by the charSet connection property.
Does HXTT Cobol need a copybook for every file?
HXTT Cobol needs a record layout, which it loads from a copybook, a COBOL source program, or FD, XFD or SEL files. One layout file can be shared by several data files with the same structure.
Does HXTT Cobol handle COMP-3 packed decimal and REDEFINES?
Yes. HXTT Cobol decodes COMP-3 (PACKED-DECIMAL) and every other COBOL numeric type, and SQL can read redefined, repeated and array columns directly.
Can HXTT Cobol update COBOL files or only read them?
HXTT Cobol can write as well as read, with transactions and multi-user access. HXTT warns that writing to large Micro Focus indexed files (IDXFORMAT 8) hasn't been compatibility-tested.
Does HXTT Cobol work with Hibernate, Tomcat and DBeaver?
Yes. HXTT Cobol is a standard JDBC driver with DataSource and connection pooling, and HXTT's FAQ gives setup steps for Hibernate, Tomcat, JBoss, WebSphere, GlassFish, ColdFusion, DBeaver and JasperSoft Studio.
Which license do I need to ship HXTT Cobol inside my own software?
To redistribute HXTT Cobol with a commercial product, the 100 User Application License covers 100 copies of one product. The Single Server and Enterprise licenses are for running it on your own servers.
How do I get a refund?
Orders for HXTT Cobol 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 Cobol is worth its $385 Single Server price if you have COBOL data files and copybooks and need that data in Java, a report tool or a new database. The reason to buy it is that it turns EBCDIC, packed decimals, REDEFINES and OCCURS into plain SQL columns from the layouts you already have, across many COBOL dialects, in a driver with a July 2026 build. The reason to hesitate is that rare file variants can still need HXTT's help, and the 100-row trial only proves the layouts decode. Start with the 30-day evaluation on a few of your real files.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License