UCanAccess is a lightweight and easy-to-use JDBC driver designed to assist Java developers in handling Access databases.
UCanAccess provides support for MDB and ACCDB files. It supports multiple data types and allows you to select, insert, delete or update statements, execute SQL queries and commands and export the result in CSV format.
What's New in This Release:
Fix bug release:
· fixed escaping for access (no standard sql) access keywords refering to data types: COUNTER, CURRENCY, DATETIME, MEMO, OLE, SINGLE, TEXT, YESNO, GUID when they are used as name of column or table or query
· improved escaping of column, table, query names for allowing the use of '(' and ')' character
· fixed a 1.0.2 bug in inserting or updating string with new line or carriage return characters: under particular conditions, n and r characters were replaced by a blank character
· in create table ddl statement, text columns default length to 255 where not specified (before the explicit setting of length of text columns was mandatory)
· patched handling of temporary access artifacts (i.e. temporary tables, queries, foreign key and indexes with the name starting with a tilde)
· jackcess upgrade to version 1.2.14