JDBaccess

What is JDBaccess?

JDBaccess is a persistence library for the Java SE platform. It 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. You select for example database rows by (see the manual for more examples):

Select select = new Select();
select.setSql("select * from employee");
Result result = select.execute();
ArrayList list = result.getNextElements();

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 works with the Java Standard Edition (Java SE). No complex application server structure and no Java Enterprise Edition (Java EE) is needed. JDBaccess is used in a typical two-layer-architecture with a plain Java application client and a database server. But within the Java application client JDBaccess allows you to develop 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 application and the JDBC driver for your database server. JDBaccess supports the data access object and transfer object pattern.

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.

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