Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   

HXTT Text (CSV) Pure Java JDBC (1.2, 2.0, 3.0, 4.0, 4.1) Drivers

HXTT Text (CSV) contains the only type 4 JDBC(1.2, 2.0, 3.0, 4.0, 4.1) 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, .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, 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)?

  • high performance
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.
  • backward compliance
It is backward compliant to the Microsoft ODBC text driver, and supports loading ODBC schema file for table definition.
  • more than SQL92
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.
  • data access mode
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).
  • data security
It supports user/password verification, SSL encryption connection, and customer connection. It supports des, trides, blowfish, and aes in sql level and database level.
  • 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.
  • 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, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, SCO Unix, UNIX, and LINUX.
  • 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.
  • 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, ftp url, and sftp 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.
  • java.io.InputStream database
It can read database from common or compressed java.io.InputStream object.
  • multi JVM versions
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, and JDK1.7.X. It supports JDBC 1.2, JDBC 2.0, JDBC 3.0, JDBC 4.0, and JDBC 4.1. 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.
  • 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)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap