ActiveJDBC

ActiveJDBC is a Java implementation of the Active Record design pattern developed by Igor Polevoy. It was inspired by ActiveRecord ORM from Ruby on Rails. It is based on a set of conventions and does not require configuration.

Writing models

Similar to Ruby on Rails, the ActiveJDBC infers meta data from a database. The result is that models do not require setters and getters.

Example

Creating and updating records

Creation of and saving new records in a table:

Employee e = new Employee();
e.set("first_name", "John");
e.set("last_name", "Doe");
e.saveIt();

or the same on one line:

Employee.createIt("first_name", "John", "last_name", "Doe");

And for updating an existing record:

Employee e = Employee.findFirst("first_name = ?", "John");
e.set("last_name", "Steinbeck").saveIt();

Finding records

ActiveJDBC does not have a query language. Search criteria are written in abbreviated SQL.

List<Employee> employees = Employee.where("first_name = ?", "John");

Related projects

While ActiveJDBC is a general purpose Java ORM, it served as a first building block for ActiveWeb

External links

• Official website
• Active Record pattern by Martin Fowler
• activejdbc — active record for Java
• ActiveJDBC Group
• ActiveJDBC Source Code
• StackOverflow questions
• Griffon-ActiveJDBC Plugin