HXTT XML
Version
4.0.276
License
Shareware
Trial Limitations
30 days, at most 50 queries per session, SELECT returns the first 100 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.70 MB
Release Date
7/13/2026
Last Updated
11/22/2026
2 views 0 downloads
Pure Java JDBC driver that queries and updates XML files with SQL and XPath

HXTT XML: Query and Update XML Files with SQL and XPath from Java

HXTT XML is a pure Java (type 4) JDBC driver that treats XML documents as a database: an XPath expression picks the elements that form a table, and you query, join and update them with ordinary SQL. It's for Java developers and DBAs who work with XML data files and would rather write SQL than DOM or SAX code. A Single Server License costs $245, one-time.

XML still carries a lot of data between systems: product feeds, configuration catalogues, exports from older enterprise software, government and banking formats. Reading it in Java usually means a parser, a tree walk and a lot of code to filter and total the results. With HXTT XML, SELECT title, price FROM books."/bookstore/book" WHERE price > 30 does the job, and any JDBC tool can do the same.

Quick facts

  • Version: 4.0.276, 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
  • Formats: XML 1.0 and XML 1.1 documents
  • Price: $245 Single Server, $889 100 User Application, $1,078 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 xml.zip (1.7 MB), whose XML_JDBC30.jar reports version 4.0.276 of July 13, 2026; order page prices of $245, $889 and $1,078 for the three licenses, all lifetime, on November 22, 2026. We didn't run it against XML files of our own.

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

Overview

HXTT XML is a JDBC driver and a small database engine in one jar. Load com.hxtt.sql.xml.XMLDriver and connect with a URL such as jdbc:xml:/c:/data; each XML file in the folder is then a database you can name in SQL. A plain SELECT * FROM books reads the document, and an XPath in quotes after the name turns any set of elements into a table: books."/bookstore/book[price<30]". Child elements become columns, attributes are columns named with an @ ("@category"), and nested paths like "file/@index" work as column names too.

Because the XPath does the navigation, you don't have to flatten or convert the document first, and the same driver reads differently shaped files without a schema. The engine runs embedded inside your application, or as a separate server managed with the DBAdmin tool in the jar, which can run as a Windows service, a Unix or Linux daemon or a normal program.

HXTT DBAdmin Server Control view showing an open table, its file size and the record lock status

DBAdmin, the server manager inside every HXTT driver jar, in an older Windows look. The Server Control view lists the open table, its size and record locks; HXTT's sample table here is a DBF file, not an XML document.

Features

XPath plus SQL

HXTT XML lets you put an XPath expression, with predicates such as [price<30], wherever SQL expects a table, and then filter, sort, group and join the result with SQL. Since February 2022 an element with no grandchildren becomes a one-row table, which makes single settings blocks easy to read.

SQL/XML functions

HXTT XML includes SQL/XML functions: XMLPARSE and XMLSERIALIZE to convert between text and XML values, XMLELEMENT, XMLATTRIBUTES and XMLCOMMENT to build XML in a query, and an xml variable type. Since 2021 the XML_TABLE, JSON_TABLE and VALUES_TABLE objects help with ETL work, and COPY DATABASE and CLONE DATABASE statements copy a whole document set.

More than SQL-92

HXTT XML 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 with dynamic columns, OFFSET and FETCH, and more than 230 SQL functions, with an API for your own. HXTT publishes PolePosition benchmark results for it.

Documents wherever they live

HXTT XML reads XML 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. A refreshInterval property re-reads a feed over HTTP or HTTPS on a schedule.

Transactions, locks and security

HXTT XML supports all four JDBC transaction isolation levels, multi-user access with record and table locks, thread-safe concurrent connections, connection pooling, DataSource, distributed transactions and RowSet. Security options are user and password checks, SSL connections, and DES, Triple DES, Blowfish and AES encryption at the SQL or database level.

Benefits

  • Far less parsing code. One SQL statement with an XPath replaces a tree walk plus filtering and totalling code.
  • XML in your reporting tools. Crystal Reports, JasperReports or DBeaver can read an XML feed through the JDBC driver.
  • Joins across formats. An XML feed can be joined with other XML files in the same query, and with memory-only tables you build.
  • The lowest price among HXTT's drivers, with a perpetual license and a year of upgrades included.

Real-World Uses

  • Product feeds: a shop imports a supplier's XML catalogue from an HTTPS URL every hour and picks out only the items whose price or stock changed.
  • Legacy exports: a migration team reads an old system's XML export with XPath tables and copies it into a relational database.
  • Configuration audits: a script queries hundreds of XML configuration files in a ZIP to find every server with a given setting.
  • Reports on XML data: a JasperReports report groups an XML transaction file by customer without a conversion step.

Who It's For, and Who Should Skip It

HXTT XML is for Java developers, integrators and DBAs who need SQL access to XML files from Java code or JDBC-based tools, especially when the files vary in shape or arrive from remote locations.

Skip it if you don't work in Java, or if you only need to read one small, fixed XML file in your own code, where the XML parser built into Java is free. For transforming XML into other XML, XSLT is the more natural tool. And if your XML is already stored inside a database such as PostgreSQL or Oracle, use that database's own XML features.

Usage Guide

  1. Download the evaluation package (xml.zip) and unzip it. It holds the JDBC 3.0 jar, documentation (including XPath and SQL/XML chapters) 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 XML_JDBC30.jar, or put it in your application server's library folder.
  3. Load the driver com.hxtt.sql.xml.XMLDriver and connect with jdbc:xml:/your/folder, or jdbc:xml://host:port/folder for a remote server.
  4. Query a document by its file name, then narrow it with an XPath table such as file."/root/item".
  5. Open DBAdmin with java -classpath XML_JDBC30.jar com.hxtt.sql.admin.Admin if you run it as a server.
  6. 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.
  • You need some XPath. Anything beyond a flat document means writing XPath expressions for the tables you want, which takes a little learning.
  • Files, not a server database. Updates rewrite the XML file, so heavy concurrent writing belongs in a real database.
  • Updates are included for one year. After that, upgrades and support are a yearly renewal. Redistributing it in your product needs the $889 license.
  • 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 XML vs Java's built-in XML parsers

DOM, SAX and StAX come with Java and cost nothing, but they hand you nodes or events, and every filter, sort and total is your code. Java's XPath API selects nodes, but stops there. HXTT XML adds SQL on top of the XPath selection, with joins, grouping, updates and a JDBC connection other tools can use. For reading one fixed file, the built-in parsers are enough; for querying and reporting on many files, the driver saves the most work.

Editions and Pricing

LicensePriceWhat it coversBuy
Single Server License$245Unlimited connections on a single serverBuy Single Server
100 User Application License$889Unlimited connections; redistribute 100 times with one commercial productBuy 100 User
Enterprise License$1,078Unlimited connections and servers, within one company in one countryBuy 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

Does HXTT XML need a schema or DTD for my files?

No. HXTT XML reads well-formed XML 1.0 and 1.1 documents without a schema; an XPath expression in the query decides which elements form the table, and column types are detected by scanning the rows.

How are XML attributes shown in HXTT XML?

HXTT XML shows an attribute as a column named with an at sign, such as "@category", and a child's attribute with a path such as "file/@index".

Can HXTT XML read an XML feed from a website?

Yes. HXTT XML accepts HTTP and HTTPS URLs (with basic authentication), as well as FTP, SFTP and SMB, and the refreshInterval property sets how often an HTTP or HTTPS document is read again.

Can HXTT XML update the XML file?

Yes. HXTT XML supports INSERT, UPDATE and DELETE through SQL, with transactions and record and table locks. Documents read over a URL can't be written back.

Does HXTT XML work with Hibernate, Tomcat and DBeaver?

Yes. HXTT XML 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 XML inside my own software?

To redistribute HXTT XML 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 XML 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 XML is worth its $245 Single Server price if Java code or a JDBC reporting tool has to query, combine or update XML files regularly. The reason to buy it is XPath plus full SQL over XML with no conversion step, from local files, archives or live URLs, in a driver with a July 2026 build. The reason to skip it is that for one fixed file the parsers built into Java cost nothing. Try your own documents in the 30-day evaluation, keeping its 100-row limit in mind.

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

Other Software Products by HXTT:
1) HXTT Json
2) HXTT Word
3) HXTT PDF
4) HXTT Cobol
5) HXTT Excel
6) HXTT Paradox
7) HXTT Text (CSV)
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.