TopAlter.com

JDBI Alternatives

JDBI Alternatives

JDBI

JDBI is a SQL convenience library for Java. It attempts to expose relational database access in idiommatic Java, using collections, beans, and so on, while maintaining the same level of detail as JDBC. It exposes two different style APIs, a fluent style and a sql object style.

The DBI type is analogous to a JDBC DataSource, and will usually be constructed by passing in a JDBC DataSource. There are alternate constructors which take JDBC URL and credentials, and other means. From the DBI instance you obtain Handle instances. A Handle represents a single connection to the database. Handles rely on an underlying JDBC connection object.

With a handle you may create and execute statements, queries, calls, batches, or prepared batches. In the above example we execute a statement to define a table, execute another statement, this time with two positional arguments to insert a value, and finally construct a query, bind a value to a named argument in the query, map the results to a a String, and take the first result which comes back.

The named argument facility on statements and queries is provided by JDBI – it parses out the SQL and uses positional parameters when actually constructing the prepared statements. The above example uses the default colon-demarcated parser, but an alternative hash delimited parser is included as well for use with databases which use colons in their grammars, such as PostgreSQL.

Best JDBI Alternatives for Linux

Looking for other JDBI-like programs? We've rounded up our favorites JDBI alternatives. Try any one of these fan favorites to see if they'll support your system and meet your specific needs.

Hibernate

Hibernate

FreeOpen SourceMacWindowsLinux

Hibernate an open source Java persistence framework project. Perform powerful object relational mapping and query databases using HQL and SQL.

Features:

  • Database
  • Java
Ebean ORM

Ebean ORM

FreeOpen SourceMacWindowsLinuxAndroid

ORM for Java / Kotlin.

JDBI Reviews

Add your reviews & share your experience when using JDBI to the world. Your opinion will be useful to others who are looking for the best JDBI alternatives.

Table of Contents

Copyright © 2021 TopAlter.com

Sites we Love: AnswerBun, MenuIva, UKBizDB, Sharing RPP