UCanAccess one .. 2

Developer: License / Price : Dimensions / OS: Binary Format : Last Up to date : Group Much more programs LGPL / $ two. four MB / Mac OS X - July 4th, 2013, 12 : fifty nine UTC [ check out record ] Home / Developer Equipment

UCanAccess is a handy, Java based mostly JDBC driver that permits builders and JDBC consumer purposes to read or produce Microsoft Accessibility databases.

UCanAccess is formulated working with the Java programming language and can be operate on Mac OS X, Windows and Linux.

Listed here are some crucial functions of "UCanAccess":

· Supports the 2000, 2003, 2007, 2010 Access formats
· Execute queries outlined as very well as saved in Entry
· Supplies access for numerous people.
· Choose, INSERT, UPDATE, DELETE statements. Transactions and savepoints.
· Accessibility knowledge sorts : YESNO, BYTE, INTEGER, Extended, Single, DOUBLE, NUMERIC, Forex, COUNTER, Textual content, OLE, MEMO, GUID,DATETIME.
· Concurrent entry from numerous users (i.e., multiple application server threads).
· Connection pooling.
· ANSI ninety two SQL, core SQL-2008.
· MS Entry SQL.
· Main Accessibility functions implementation.
· You can execute decide on queries outlined and saved in Access. Because one.. 1 model, UCanAccess can execute crosstab queries (Transfom...Pivot...)
· LIKE operator accepts equally standard '_' and obtain precise '?' as wildcard character, each standard '%' and accessibility certain '*' as jolly, # for solitary digit( entry ), [xxx][!xxx]for figures intervals.
· Equally & and Sq. brackets for industry names, desk names and watch names ( Access Queries) such as spaces (e.g., pick [my column] from [my desk ] ).
· Entry date structure (e.g., # 11 /22/2003 ten : forty two : fifty eight PM#).
· Equally double quotation " and single quote ' as SQL string delimeters.
· Primary, readonly assist to advanced kinds (i.e., array of Edition, Attachment, SingleValue). Tables with 1 or additional colums of all those types are readable but readonly in the current improvement stage. Making use of ResultSet.getObject you can get array of internet.ucanaccess. complex. Edition, net.ucanaccess. intricate.Attachment and so on.
· Command Line Console. You can operate SQL instructions and screen their outcomes. CSV export command.

Necessities :

· HSQLDB two. 2.x
· Java
· Jackcess one. two. nine or later on

Restrictions :

· Only standard DDL is supported ( make desk with key essential, drop desk ).
· Lousy multi- course of action entry assist. Yet it tries to synchronize information when a concurrent approach modifies the access file.

What is actually New in This Launch : [ read total changelog ]

· extra create guidance sophisticated sorts (i.e., array of Version, Attachment, SingleValue)
· additional Lookup domain operate
· extra assistance for dynamic domain purpose (e.g. Decide on DCount("ID","Table1","ID

Via: UCanAccess 1.0.2