jaLISQJava language integrated and type safe SQL queryingjaLISQ offers type-safe and language integrated SQL querying for the Java programming language.
If you want to help out and know SQL and/or Java and/or Eclipse plugin development please don't hesitate to drop me a line at wwechsung (at) web.de.
jaLISQ uses JDBC metadata to generate Java representations of SQL. As regards typesafety this enables programs using jaLISQ to bind to the data layer at the earliest possible time.
jaLISQ project goalscreate a typesafe way to compose SQL in Java programs. provide SQL syntax highlighting and assisting and auto completion as well as inline documentation from within Java programs enable easy SQL refactoring with respect to the DB schema jaLISQ scopeSQL Metadata to Java artifacts generator Java DSL styled API (domain specific language) for creating typesafe DML statements. Plugins for Netbeans and Eclipse to enable transparent integration of jaLISQ support for ANSI SQL 99 and major SQL dialects (MySQL, MSSQL, Oracle) Not in scope:jaLISQ is not supposed to be an ORM or database cache. DDL and dynamic DDL. jaLISQ will not support tables that are subject to dynamic structure changes. The assumption of this project is that usage of jaLISQ will largely follow this process: -> define DB schema -> run jaLISQ artifact generator -> deploy and ensure that test and production db use the same schema
