UCanAccess 2.0.9.3

UCanAccess 2.0.9.3 | 3.0 Mb

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.

Features
• Supported Access formats: 2000, 2003, 2007, 2010.
• SELECT, INSERT, UPDATE, DELETE statements. Transactions and savepoints.
• Access data types: YESNO, BYTE, INTEGER, LONG, SINGLE, DOUBLE, NUMERIC, CURRENCY, COUNTER, TEXT, OLE, MEMO, GUID, DATETIME.
• Concurrent access from multiple users (i.e., multiple application server threads).
• Connection pooling.
• ANSI 92 SQL, core SQL-2008.
• MS Access SQL.
• Main Access functions implementation.
• You can execute select queries defined and saved in Access.
• Criteria in LIKE clause.
• Access date format (e.g., #11/22/2003 10:42:58 PM#).
• Both double quote " and single quote ' as SQL string delimeters.
• Command Line Console. You can run SQL commands and display their results. CSV export command.

Change Log 2.0.9.3 Release (2015-01-17)
• Upgrade to jackcess 2.0.8
• Fixed console output(it sometime showed correctly loaded queries in the list of the queries it wasn't able to load)
• Fixed issues that may happen with few unregistred keywords(e.g. 'cardinality') if used as column name with a default value. Those keywords didn't have any effect on SQL, except for the particular case above.
• Fixed Connection setSavepoint(String spn) method(setSavepoint only worked fine with no-arguments);
• Fixed "Create table as select ..." DDL statement when using with a group by clause with two or more columns.
• Allowed DDL with PreparedStatement(for ORM libraries' use).
• Implemented ErrorHandler for invalid characters sequences: an Exception will be thrown to identify in which table, column and row the error occured.
• Fixed ResultSet.getString when called on a numeric decimal column.
• Fixed bug on logging/shutdown. At the vm end some unneccessary operation was performed in the case of memory=false and singleConnection=true Logs about on-disk database were shown when program terminates (long after the latest connection was closed).
• Added mirrorFolder connection parameter that forces memory=false and allows users to set the directory in which the mirror db will be created. Simply set this parameter to java.io.tmpdir in order to specify the system temp folder for that.
• Fixed residual issue (access 2007) creating new tables on NOT NULL property.
• Added orderJet function to allow compliance with Jet sorting logic that skip hyphen minus '-', en dash '–', em dash '—'
• and in the middle of a string:
• i.e. even if "-" comes before "/"
• and "a-" before "a/"
• and "a- b" before "a/ b"
• unexpectedly, likely to handle compound words "a/b" comes before "a-b"
• WORKAROUND suggested: if you want the same behaviour of Access: select * from table

OS: Windows All

HomePage

Download :
Uploaded

Mirror :
Rapidgator

Mirror :
Turbobit

Download From Homepage