LDBC (Liberty DataBase Connectivity) is a JDBC driver that provides vendor-independent database access. With LDBC, your application will just work on all major databases and you don't have to change any source code. LDBC is based on ANSI-SQL and JDBC.
LDBC radically simplifies porting of existing or new applications to new databases. The main components of LDBC are a JDBC driver and a SQL grammar converter. LDBC completely shields the application from database vendor specific code. Included SQL grammar and JDBC API documentation.
LDBC is not meant to be a persistence layer or object relation mapping.
The main idea of LDBC is providing a standard way to access a SQL database
from Java.
LDBC comes with a JDBC driver that makes every database behave exactly the same way. Internally, LDBC uses the 'regular' vendor specific JDBC driver, but this is not visible to the application.
Without the LDBC driver (BAD)
|
With the LDBC driver (GOOD)
|
The app works only with one database, because:
|
The application works with all major databases, because:
|
Grammar: The SQL syntax supported
Databases: The list of supported database vendors and drivers
JDBC API: Lists supported JDBC interfaces
Functionality: What is supported and what is not (yet) supported
How to Build: The software required to build LDBC yourself
FAQ: Frequently Asked Questions
Download: If you want to try it out
LGPL is used for the software. All software available here can be used in commercial applications at no cost. The application does not need to be LGPL or GPL to be able to use the software.
THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
THE DEVELOPMENT GROUP, OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.