DBvolution: Always Java, Never SQL.
DBvolution automatically protects you from common SQL mistakes like Cartesian Joins or Blank Queries, makes outer joins trivial, helps you collect semantic knowledge, and makes your application completely portable across databases.
DBvolution removes Object/Relational Impedance by using classes to represent and store the information on each table, and using special datatypes to make setting query conditions trivial and intuitive.
To use DBV, first create a connection to your database using the DBDatabase
subclasses in nz.co.gregs.dbvolution.databases.
With the the DBDatabase you can create the DBRow classes required from the
database schema using
DBTableClassGenerator or you can
write your own. DBDatabase provides methods to create and "drop" tables from
the database so you can start from scratch or migrate easily. There are
examples to start from in nz.co.gregs.dbvolution.example.
Using your DBRow subclasses you can
create simple queries using
DBTable
or complex ones using
DBQuery.
You can create transactions easily using DBScript testing the
transaction with
test
or committing the changes with
implement.
I've been writing SQL for 20 years and DBV is better, I hope you like it.
Gregory Graham