|
HXTT Access Pure Java JDBC (1.2, 2.0, 3.0, 4.0, 4.1, 4.2, 4.3) Drivers for MS Access
HXTT Access contains the only type 4 JDBC(1.2, 2.0, 3.0, 4.0, 4.1, 4.2, 4.3) driver packages for Microsoft Access version from 95, 97, 2000, XP, 2002, 2003, 2007, 2010, 2013, to 2016, 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, MS Access database 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 Access?
|
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 tests show the faster speed compared to some other databases. You can also download a benchmark report in pdf format for offline browse. |
|
It supports MS Access' compatible lock through lockType=ACCESS connection property. |
|
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 join query in more than one MDB(ACCDB) 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. |
|
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. |
|
It supports all transactions level of READ UNCOMMITTED,READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. |
|
It supports concurrent database connections, and is thread safe. |
|
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, SCO Unix, OS2, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, OpenVMS, Guardian, UNIX, and LINUX. |
- 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, and Java 11. 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. |
|