Sql2o is a small java library, with the purpose of making database interaction easy. When fetching data from the
database, the resultset will automatically be filled into you POJO objects. Kind of like an ORM, but without the sql generation capabilities.
Check out the sql2o website for examples.
To run the oracle database tests it is necessary to download the oracle jdbc driver manually, and register it with maven. Oracle
does not have a public repository where maven can download the driver automatically.
- Download the ojdbc6.jar version 11.2.0.3 from this page: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
- Install it into your local maven repo by running this command:
mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.3 -Dpackaging=jar -Dfile=ojdbc6.jar -DgeneratePom=true