MyBatis has a long standing history of enabling developers to connect to databases using a lightweight approach on top of JDBC. This post shows how to use it to connect to an Oracle Autonomous Database.
Jdbi is a lightweight data access/persistence library on top of JDBC. This post describes how to set it up to interact with Oracle Autonomous Database.