|
|
HXTT Text (CSV) Pure Java JDBC (1.2, 2.0, 3.0, 4.0, 4.1, 4.2, 4.3) Drivers
HXTT Text (CSV) contains the only type 4 JDBC(1.2, 2.0, 3.0, 4.0, 4.1, 4.2, 4.3) driver packages for raw data, tabular data, flat text, CSV(comma separated values) file, TSV file, PSV file, UTF file with/without BOM(byte-order marker), Pascal style string, fixed-length, and variable-length binary file, which supports transaction, embedded access, remote access, client/server mode, memory-only database, compressed database(.ZIP, .JAR, .GZ, .TAR, .BZ2, .7z, .TGZ, .TAR.GZ, .TAR.BZ2), SAMBA database(smb), url database(http, https, ftp, sftp), and java.io.InputStream database. Through the embedded Pure Java database engine, text and binary file can be deployed and acessed on any platform with JVM. With JDBC1.2, JDBC2.0, JDBC3.0, JDBC4.0, JDBC4.1, JDBC4.2, JDBC4.3, and SQL92 support, programmers needn't special coding , and DBA can use any Java database tool to access easily local data or remote data.
Download directly JDBC 3.0 trial version Register to download more Buy now
Why should you go for HXTT Text (CSV)?
|
With a small footprint, transactional oriented database engine, it supports embedded and client/server modes for mobile system, also supports all join types, GROUP BY, ORDER BY, and DISTINCT on million-level tables with giga size. PolePosition database benchmark Text Tests and CSV Tests show the faster speed compared to some other databases. You can also download Text benchmark report and CSV benchmark report in pdf format for offline browse. |
|
It is backward compliant to the Microsoft ODBC text driver, and supports loading ODBC schema file for table definition. |
|
It supports nearly full ANSI-92 SQL (BNF format) plus many SQL:2008 enhancements, more than 230 sql functions, open user-defined sql function API, XOPEN SQLState, RMI, Jini, JNDI, and serialization. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, GROUP_CONCAT, GROUPING, WITH ROLLUP, WITH CUBE, multiple-row VALUES table, PIVOT table, UNPIVOT table, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. It supports seamlessly data mining on memory-only table, physical table, SAMBA table, url table, compressed table in a sql. |
|
It supports embedded mode, client/server mode, and remote access(map network drive, SAMBA protocol, HTTP protocol, HTTPS protocol, FTP protocol, SFTP protocol, and UNC path). |
|
It supports user/password verification, SSL encryption connection, and customer connection. It supports des, trides, blowfish, and aes in sql level and database level. |
|
Text driver uses CREATE TABLE to define SQL data types to the columns in the
text files. If you're using CSV file, you can access your data without any predefined CREATE TABLE sql. It can detect automatically data types. It supports 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. You can find how to use CREATE
TABLE in General Questions 10~16. If you don't
know how to define a suitable table structure to access your special data, just
email us a sample file, and we will write sample code for you. |
|
The drivers are completely written in Java and can be deployed on any platform with Java VM, which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, SCO Unix, UNIX, and LINUX. |
|
It supports all transactions level of READ UNCOMMITTED,READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. |
|
It supports concurrent database connections, and is thread safe. |
- ZIP, GZIP, BZ2, 7z, and TAR file
|
It supports seamlessly files and directories in ZIP, GZIP, BZ2, 7z, and TAR files(.ZIP, .JAR, .GZ, .TAR, .BZ2, .7z, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql. |
|
It supports seamlessly http url, https url, ftp url, and sftp url in jdbc url and sql. |
|
It supports seamlessly smb url in jdbc url and sql. |
|
It supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications. |
- java.io.InputStream database
|
It can read database from common or compressed java.io.InputStream object. |
|
It supports Personal Java, JDK1.0.X, JDK1.1.X, JDK1.2.X, JDK1.3.X, JDK1.4.X, JDK1.5.X, JDK1.6.X, JDK1.7.X, JDK1.8.X, Java 9, Java 10, Java 11, Java 12, Java 13, and Java 14. It supports JDBC 1.2, JDBC 2.0, JDBC 3.0, JDBC 4.0, JDBC 4.1, JDBC4.2, and JDBC 4.3. Connection Pooling, DataSource, Distributed Transaction, and RowSet, are supported too. It supports Borland's BDE, Borland's Database Desktop, JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, iSQL-Viewer, AquaDataStudio, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, Crystal Reports, Jisql, RazorSQL, and DbEdit Database Utilites for Eclipse Platform. |
|
It supports all of JVM's supported unicode, locales and encodings. Cp895(Czech MS - DOS 895), Cp620(Polish MS - DOS 620) and Mazovia are extra supported although JVM doesn't support those. |
- GUI database server manager
|
For client/server mode, it provides a GUI database server manager with remote control capability, which can run as Windows service, Unix/Linux daemon, or standalone application. |
|
Main
Products
webmaster@hxtt.com