HXTT Access 3.2

HXTT Access 3.2 is a powerful tool which contains the only type 4 JDBC(1.2, 2.0, 3.0) driver packages for Microsoft Access version from 95, 97, 2000, XP, 2002, to 2003. Through the embedded Pure Java database engine, MS Access database 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.

Major Features:

1. High performance: It contains a fast database engine written in Java, which supports embedded and server modes. Tests show the quicker speed compared to some other database engines. You can also download a benchmark report in pdf format for offline browse.
2. More than SQL92: It supports ANSI SQL 92 standard, 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 join query in more than one mdb database. It supports VIEW(QUERY of MS ACCESS), Linked Table to other Access databases, and most simple stored procedures (select, insert, update, and delete). It supports seamlessly data mining on memory-only table, physical table, SAMBA table, url table, compressed table in a sql.
3. 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).
4. Data security: It supports user/password verification, SSL encryption connection, and customer connection. It supports des, trides, and blowfish in sql level and database level.
5. Transaction support: It supports all transactions level of read uncomitted, read committed, repeatable read, and serializable.
   
6. Concurrent connections: It supports concurrent database connections, and is thread safe.
7. 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.
8. 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.
9. URL database: It supports seamlessly http url, https url, and ftp url in jdbc url and sql.
10. SAMBA database: It supports seamlessly smb url in jdbc url and sql.
11. Memory-only database: It supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
12. 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 and JDK1.6.X. It supports JDBC 1.2, JDBC 2.0, JDBC 3.0, and JDBC 4.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, Crystal Reports, Jisql, and DbEdit Database Utilites for Eclipse Platform.
13. 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.
14. 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.