Recent Posts by Andres Almiray

Last year I blogged on how you could configure the Oracle JDBC drivers in a Spring Boot project. At the time, Spring Boot 2.3.0.RELEASE did not include explicit integration with Oracle UCP, the preferred connection pool when connecting to Oracle databases. However, that wasn't much of a problem as thanks to the highly configurable and extensible options provided by Spring Boot one could write their own Oracle UCP Connection Pool bean as shown in that particular blog post. Some...

Following the previous post of Connecting to Oracle Autonomous Database with JDBI today I'd like to showcase another lightweight option know as MyBatis. MyBatis began life as iBATIS back in 2001 moving to Apache some years later. While at Apache it gathered quite the following until competing DAO solutions emerged, despite this, the project kept going now outside of Apache and renamed to MyBatis. However the legacy of iBATIS continues on, you may find it in some package...

The Java ecosystem has no shortage of options for dealing with any particular aspect of application development, it is perhaps one of its greatest assets, data persistence is no exception. We've got from SQL-to-Java mappers, SQL parsers, SQL generators, ORMs, ODMs, and everything in between. Hibernate and JPA are quite the popular choices that developers pick to connect to databases and handle data but by no means are the only choices. Today I'd like to showcase Jdbi, a...

Welcome back to the Mastering Maven series. In recent entries we've explored additional features provided by Maven related to dependency resolution: <optional> dependencies, <dependencyManagement>, exclusions. These features not only let you configure dependencies for your project but also fix common issues when the dependency tree does not have the appropriate contents. Some of these issues are easy to spot and fox, but there will be times when spotting issues is not that...

It's no secret that one of the compelling reasons to choose Java for development it's the sheer amount of libraries and frameworks to choose from. The use of said libraries typically requires a build system and bundling dependencies with the production code, otherwise execution will fail. Thus build tools such as Apache Maven and Gradle have become a staple of Java development around the world, offering a range of packaging and deployment options. However there are times when...

Connecting to an Oracle Autonomous Database instance via JDBC requires just a couple of steps which will be described in this post. If you happen to use Apache Maven or Gradle to build your project then you'll be able to copy the configuration snippets shown next, if not you can still download the required JARs directly from Maven Central or the Oracle JDBC Drivers Maven Central Guide. I'm assuming you may be already familiar with Autonomous Database and have an instance...

Helidon 2.0 was recently released and with it came a host of new features and capabilities. Please refer to the docs & guides to know more about these features. Today I'd like to showcase how to build, test, and package a Helidon SE application using the Gradle build tool. Unlike Apache Maven, Gradle does not provide a mechanism similar to Maven archetypes to bootstrap projects. There's nothing stopping us from creating a Helidon SE project from scratch, however we can also...

In recent weeks I've been re-learning Go, looking for similarities with existing Java libraries. Naturally, I went on a search for storing and retrieving data from an Oracle database. There are no shortages of options in the Java space for interacting with data stored in a database. Options range from plain JDBC, lightweight data mappers such as Sql2o and Jdbi, more elaborate mappers such as MyBatis, all the way to the full-fledged ORMs such as Hibernate, Eclipselink, and...

Version 19.7.0.0 of the Oracle JDBC drivers and related binaries have been recently posted to Maven Central. There are quite a good number of goodies and features found in this release, however, in terms of distribution things have changed for the better: POM files for all binaries are now available in minimal form (i.e. with their minimum set of required dependencies). Additionally, a BOM file has also been published, whose responsibility is to define the set of...