Software
We've compiled a list of 3 free and paid alternatives to JDBI. The primary competitors include NHibernate .NET, Hibernate. In addition to these, users also draw comparisons between JDBI and Fénix Framework. Also you can look at other similar options here: Development Tools.
We've compiled a list of 3 free and paid alternatives to JDBI. The primary competitors include NHibernate .NET, Hibernate. In addition to these, users also draw comparisons between JDBI and Fénix Framework. Also you can look at other similar options here: Development Tools.
NHibernate is a mature, open source object-relational mapper for the .NET framework.
A framework to develop enterprise applications that need transactions, persistence, and a rich...
JDBI is a SQL convenience library for Java.
JDBI is a SQL convenience library for Java.
Linux
Mac
Windows
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.
Java
Share your opinion about the software, leave a review and help make it even better!
Suggest Changes
Your Feedback
Your vote has been counted.
Do you have experience using this software?
