Pure Java Type 4 Text JDBC and CSV JDBC (1.2, 2.0, 3.0) driver packages for raw data, flat text, CSV file, TSV file, PSV file, fixed-length, and variable-length binary file, supports transaction, embedded access, client/server mode, remote access, memory-only database, compressed database, SAMBA database, and url database(http, https, ftp). It is backward compliant to the Microsoft ODBC text driver, and supports loading ODBC schema file for table definition. 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, remote access mode, memory-only database, compressed database, and url database. It supports ANSI SQL 92 standard, more than 210 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, 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 and JDK1.5.X. It supports JDBC1.2, JDBC2.0, and JDBC3.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. |
