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

Project Activity

See All Activity >

Follow NativeSQLPersistence

NativeSQLPersistence Web Site

Other Useful Business Software
MongoDB Atlas runs apps anywhere Icon
MongoDB Atlas runs apps anywhere

Deploy in 115+ regions with the modern database for every enterprise.

MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of NativeSQLPersistence!

Additional Project Details

Registered

2017-02-02
Report inappropriate content