The sql2java team has released a new version of its java code generator which can generate a simple framework, yet powerfull, to access any database schema. The release comes with a working sample. In less than 1 hour you can create your api and start using it in production. This tool is ideal for small or large projet that do not need all the ejb infrastructure.