HXTT Text (CSV) contains the only type 4 JDBC(1.2, 2.0, 3.0) 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), 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, .TGZ, .TAR.GZ, .TAR.BZ2), SAMBA database(smb), and url database(http, https, ftp). 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 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 JDBC30 trial version Register to download more Buy now

Why should you go for HXTT Text (CSV)?

high performance	It contains a fast database engine written in Java, which supports embedded and server modes. Text Tests and CSV Tests show the quicker speed compared to some other database engines. You can also download Text benchmark report and CSV benchmark report in pdf format for offline browse. It supports all join types, GROUP BY, ORDER BY, and DISTINCT on million-level tables with giga size.
flexible table structure	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.
backward compliance	It is backward compliant to the Microsoft ODBC text driver, and supports loading ODBC schema file for table definition.
transaction support	It supports all transactions level of READ UNCOMMITTED,READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.
concurrent connections	It supports concurrent database connections, and is thread safe.
data access mode	It supports embedded mode, client/server mode, and remote access(map network drive, SAMBA protocol, HTTP protocol, HTTPS protocol, FTP protocol, and UNC path).
data security	It supports user/password verification, SSL connection, and customer connection. It supports des, trides, and blowfish in sql level and database level.
more than SQL92	It supports ANSI SQL 92 standard, more than 210 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, 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 suuports seamlessly data mining on memory-only table, physical table, SAMBA table, url table, compressed table in a sql.
type 4	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, UNIX, and LINUX.
ZIP, GZIP, BZ2, and TAR file	It supports seamlessly files and directories in ZIP, GZIP, BZ2, and TAR files(.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
URL database	It supports seamlessly http url, https url, and ftp url in jdbc url and sql.
SAMBA database	It supports seamlessly smb url in jdbc url and sql.
memory-only database	It supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
multi JVM versions	It supports Personal Java, JDK1.0.X, JDK1.1.X, JDK1.2.X, JDK1.3.X, JDK1.4.X and JDK1.5.X. It supports JDBC1.2, JDBC2.0, and JDBC3.0. 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, Jisql, and DbEdit Database Utilites for Eclipse Platform.
internationalization	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.

Address:	9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode:	411100
Phone:	(86)20-89224066, (86)10-51375375
Fax:	(86)20-89224066, (86)10-51375375, (86)732-8225727
Email:	webmaster@hxtt.com