This Java software provides JDBC driver packages for various versions of Microsoft Excel XLS and XLSX files, from 95 to 2016. It supports features such as embedded access, compressed database, SAMBA database, and URL database.
Moreover, it comes with all four transactions levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE, and can handle concurrent database connections in a thread-safe manner. Plus, it provides support for ANSI SQL 92 standard, over 230 SQL functions, XOPEN SQLState, RMI, Jini, JNDI, and serialization.
This software also boasts impressive query capabilities, including UNION, INTERSECT, EXCEPT, MINUS, 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 features single-row, multirow, multiple-column, inline views, and correlated subquery functionality.
Additionally, the Pure Java Type 4 MS Excel JDBC driver packages have been written entirely in Java and can be deployed on any platform with Java VM, including Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. What's more, 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 versions of the JVM, as well as JDBC1.2, JDBC2.0, JDBC3.0, JDBC4.0, and JDBC4.1.
Even better, it can handle all of the JVM's supported unicode, locales, and encodings, and even offers support for Cp895(Czech MS - DOS 895), Cp620(Polish MS - DOS 620), and Mazovia, which JVM doesn't natively support. And if you need remote access mode, the software provides a user-friendly GUI database server manager with remote control capability that can be run as either a Windows service, Unix/Linux daemon, or standalone application.
Finally, the software allows seamless handling of files and directories in ZIP, BZ2, and TAR files(.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql. Overall, I would highly recommend Pure Java Type 4 MS Excel JDBC driver packages to anyone looking for a versatile, powerful database software that can handle their needs with ease.
Version 5.0.016: N/A