|
Pure Java Type 4 MS Excel JDBC(1.2, 2.0, 3.0, 4.0) driver packages for Microsoft Excel version from 95, 97, 98, 2000, 2001, XP, 2002, 2003, to 2004, supports transaction, embedded mode, client/server mode, remote access mode, memory-only database, compressed database, SAMBA database, and url database(http, https, ftp). It supports all transactions level of READ UNCOMMITTED,READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. It supports concurrent database connections, and is thread safe. It supports embedded mode and remote access mode. It supports ANSI SQL 92 standard, more than 230 sql functions, 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. 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. 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 JDBC1.2, JDBC2.0, JDBC3.0, and JDBC4.0. 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. For remote access mode, it provides a GUI database server manager with remote control capability, which can run as Windows service, Unix/Linux daemon, or standalone application. It supports seamlessly files and directories in ZIP, BZ2, and TAR files((.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
|
