Framework is designed to provide simple database access using native SQL queries.
It will care about connection handling and object closing statements to foreclose connection leaks.
Containing a pure Java connection pool, it can be used in fat clients, web applications, batch jobs - everything based on Java.
Export features are available:
CSV, HTML, XML, XML-Spreadsheets (Excel)
Can be used as XA and None-XA datasource, statement parameters are available.
JPA library is used to provide EntityManager compliance, it is not required for normal DatabaseAccessor. (used for DatabaseAccessorJPA)
ATTENTION:
You should use one DatabaseAccessor instance per database, so please use Singleton pattern in multi-thread environments like web applications. DatabaseAccessor is implementing DataSource interface, so you might use it directly in your existing code as an extension.
Features
- multiple native Java connection pools
- can be used with server connection pools
- CSV, HTML, XML, XML-Spreadsheet export functionality
- prepared and unprepared statements
- code including example
- main class execution functionality
- main class Bytes export fuctionality