HXTT Json: Query and Update JSON Files with SQL from Java
HXTT Json is a pure Java (type 4) JDBC driver that treats JSON documents as a database: an XPath-style path turns nested objects and arrays into flat tables, and you query, join and update them with ordinary SQL. It's for Java developers and data engineers who handle JSON files and feeds and would rather write SQL than parsing and mapping code. A Single Server License costs $245, one-time.
REST exports, log files, configuration and API responses arrive as JSON, and turning a nested document into rows usually means a parser such as Jackson, a set of classes and loops to flatten arrays. With HXTT Json, a path in the table name does the flattening, so SELECT * FROM orders."/orders/items" gives you one row per item, and a reporting tool can read it over JDBC.
Quick facts
- Version: 1.0.247, built July 13, 2026 (first released December 2020)
- Developer: Heng Xing Tian Tai Lab of Xi'an City (HXTT), which also makes JDBC drivers for Access, DBF, Excel, Word and XML 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: JSON documents, including JSON5-style comments
- 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 json.zip (1.7 MB), whose Json_JDBC30.jar reports version 1.0.247 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 JSON files of our own.
Download Free TrialBuy Single Server LicenseBuy 100 User Application LicenseBuy Enterprise License
Overview
HXTT Json is a JDBC driver and a small database engine in one jar. Load com.hxtt.sql.json.JsonDriver and connect with a URL such as jdbc:json:/c:/data; each JSON file in the folder is then a database you can name in SQL. A path in quotes after the file name selects the objects that become a table, the same way HXTT's XML driver uses XPath, so a deeply nested document can be read as several simple tables, one per level, and HXTT's site describes this as converting a complicated JSON object into a flat table automatically.
Inside a query you also get PostgreSQL-style JSON handling: json and jsonb types, the ->, ->>, #> and #>> operators to reach into a value, and functions such as JSON_TABLE, json_extract, jsonb_set and to_json. JSON_TABLE turns a JSON string from anywhere, such as a column in another table, into rows, which helps with ETL. The engine runs embedded in your application or as a separate server managed with the DBAdmin tool in the jar.
DBAdmin, the server manager inside every HXTT driver jar, in an older Windows look. The Server Connections view lists each client connection and the tables it has open; HXTT's sample connection here is a DBF folder, not a JSON file.
Features
Paths that flatten nested JSON
HXTT Json accepts a path expression, with predicates, wherever SQL expects a table, so arrays of objects become rows and their fields become columns. You can then filter, sort, group and join the result with SQL, including joins across several documents.
JSON types, operators and functions
HXTT Json has json and jsonb types with the ->, ->>, #> and #>> operators for array elements, object fields and nested paths, plus CAST and CONVERT to json, to_json, to_jsonb, json_extract and jsonb_set. JSON_TABLE, XML_TABLE and VALUES_TABLE objects turn JSON or XML text into tables, and COPY DATABASE and CLONE DATABASE statements copy a whole document set.
More than SQL-92
HXTT Json 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.
Documents wherever they live
HXTT Json reads JSON from local folders, 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. SFTP connections can use a private key file instead of a password.
Transactions, locks and security
HXTT Json supports all four JDBC transaction isolation levels, 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
- No mapping classes. One SQL statement with a path replaces a parser, model classes and the loops that flatten arrays.
- JSON in your reporting and ETL tools. Crystal Reports, DBeaver or any JDBC-based tool can read a JSON file or feed as tables.
- Old Java still covered. Packages from JDBC 1.2 to 4.3 mean it runs on legacy JVMs as well as current ones.
- The lowest price among HXTT's drivers, tied with HXTT XML, with a perpetual license and a year of upgrades included.
Real-World Uses
- API exports: a nightly job reads a JSON export from an HTTPS URL, flattens its order lines and loads them into a relational database.
- Log analysis: an analyst groups and counts events in JSON log files packed in a ZIP archive, straight from a SQL client.
- Configuration audits: a script queries a folder of JSON configuration files to find every service with a given setting.
- Mixed-format reports: a report joins a JSON product feed with a lookup table built in memory, without a conversion step.
Who It's For, and Who Should Skip It
HXTT Json is for Java developers, integrators and DBAs who need SQL access to JSON files from Java code or JDBC-based tools, especially when the files are nested, vary in shape, or come from remote locations.
Skip it if you don't work in Java, or if you only map one known JSON format into your own objects, where Jackson or Gson do the job for free. If your JSON already sits in PostgreSQL, MySQL or another database with JSON functions, use those. And for a one-off look at a JSON file, a free command-line tool such as jq is quicker.
Usage Guide
- Download the evaluation package (json.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.
- Add the jar to your classpath, for example
-cp Json_JDBC30.jar, or put it in your application server's library folder.
- Load the driver
com.hxtt.sql.json.JsonDriver and connect with jdbc:json:/your/folder, or jdbc:json://host:port/folder for a remote server.
- Query a document by its file name, then add a path in quotes to pick the nested objects you want as rows.
- Open DBAdmin with
java -classpath Json_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.
- Documentation borrowed from other drivers. Parts of the bundled guide still say Cobol or MS Word where they mean JSON, and the path examples are written for XML, so expect some trial and error with your own documents.
- Files, not a server database. Updates rewrite the JSON 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 listed Java versions stop at Java 14, and DBAdmin has an old Java look.
Comparisons
HXTT Json vs a JSON library such as Jackson
Jackson and Gson are free and fast, and they map JSON into your own Java classes, but every filter, join and total is your code, and nothing outside your program can use them. HXTT Json adds SQL on top of the parsing: paths flatten nested data into tables, and joins, grouping and updates are one statement, through a JDBC connection that reporting and ETL tools can use too. For one known format inside your own app, a library is enough; for querying and reporting on many JSON files, the driver saves the most work.
Editions and Pricing
| License | Price | What it covers | Buy |
| Single Server License | $245 | Unlimited connections on a single server | Buy Single Server |
| 100 User Application License | $889 | Unlimited connections; redistribute 100 times with one commercial product | Buy 100 User |
| Enterprise License | $1,078 | 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 request.
FAQs
Does HXTT Json need a schema for my JSON files?
No. HXTT Json reads JSON documents without a schema; the path in the query decides which objects form the table, and column types are detected by scanning the rows (the maxScanRows property sets how many).
Can HXTT Json read JSON with comments?
Yes. HXTT Json accepts JSON5-style comments (/* */ and //) in the documents it reads.
Can HXTT Json read a JSON feed from a web API?
Yes. HXTT Json accepts HTTP and HTTPS URLs as well as FTP, SFTP and SMB, in the JDBC URL or directly in SQL.
Can HXTT Json update the JSON file?
Yes. HXTT Json supports INSERT, UPDATE and DELETE, plus CREATE TABLE and ALTER TABLE, with transactions at all four isolation levels.
Does HXTT Json run on old Java versions?
Yes. HXTT Json ships packages for JDBC 1.2 through 4.3, covering Personal Java and JDK 1.0 up to Java 14, so the same driver works on legacy application servers and current JVMs.
Which license do I need to ship HXTT Json inside my own software?
To redistribute HXTT Json 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 Json 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 Json is worth its $245 Single Server price if Java code or a JDBC reporting tool has to query, flatten, combine or update JSON files on a regular basis. The reason to buy it is full SQL over nested JSON with no mapping code, from local files, archives or live URLs, in a driver with a July 2026 build. The reason to skip it is that for one known format inside your own app, free libraries like Jackson 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