JDBaccess for MySql

JDBaccess is the persistence library for the Java platform and defines major database access operations in an easy usable API
JDBaccess is the persistence library for the Java platform and defines major database access operations in an easy usable API. The main interface classes are Transaction, Insert, Update, Delete, Select, Result, Procedure, Function, and CallResult.

JDBaccess is completely written in the Java programming language and only has a small size of about 170 KB. It supports the major two database systems MySql and Oracle with their Type 4 JDBC drivers (Oracle thin driver and Connector/J).

JDBaccess applications are portable, and independent of the underlying database. You can focus on your object model and leave the details of persistence to the JDBaccess implementation. JDBC is completely hidden from the programmer. A JDBaccess application for example does not care about connection and statement handling. JDBaccess can help you to remove or encapsulate vendor-specific SQL code. JDBaccess goal is to relieve the developer from 90% of common data persistence related programming tasks.
JDBaccess is for programmers of the Java platform which do not sacrifice scalability but develop solutions that are simple and flexible.

JDBaccess can't be faster than JDBC itself, but it performs important operations by better usage of the JDBC methods. The average performance and throughput of applications with JDBaccess is much better than applications working with JDBC directly. We did a performance test with a typical application. You could see that these methods improve the overall performance and throughput.

You should use JDBaccess in a typical two-layer-architecture with a rich client and a database server. But within your client JDBaccess allows you to build your application in a typical three-layer-architecture with presentation, application and persistence layer. JDBaccess is the software between your persistence layer in the client and the JDBC driver for your database server. JDBaccess supports the data access object and transfer object pattern.

JDBaccess is an additional persistence framework to JDO and Hibernate, which are more usable for handling complex objects and in application server environments.

Main features of JDBaccess for MySql:

Support of MySql and Oracle

Simple

Fast

Cheap

Hidden SQL

Easy use of functions and procedures

Layer architecture


Requirements of JDBaccess for MySql:

J2SE 1.4.2 or higher; JDBC driver of MySql


Limitations of JDBaccess for MySql:

Usage of connections and statements

Free Download ( Evaluation | 987 KB )