db-commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian McCallister <bri...@apache.org>
Subject Re: new project question
Date Sun, 18 Jan 2004 19:35:28 GMT
Do you have the code available anywhere at the moment? Does anyone work 
on it aside from yourself?


On Jan 18, 2004, at 12:33 PM, Oliver Heger wrote:

> This posting was originally sent to the Jakarta commons-dev list. The 
> people there pointed me to the Apache DB project.
> Oliver Heger wrote:
>> Hi all,
>> I am working on a SQL generator library and would like to donate it 
>> to an open source community. I think it would fit into Jakarta 
>> Commons. Here is some information about it:
>> The library was part of a view framework for web applications. It can 
>> generate SELECT statements to retrieve data. The single parts of a 
>> SELECT query are represented as objects that can be plugged together 
>> (e.g. fields to be retrieved, conditions). Finally a renderer 
>> processes this object tree and generates SQL code. This is the list 
>> of the goals that are to be achieved:
>> - Hiding the complex syntax of SQL queries by providing a high level 
>> API to construct them.
>> - Improving performance over naive programming by consequent usage of 
>> prepared statements with placeholders where possible.
>> - Providing mapping facilities between logic names of (bean) 
>> properties and database column names.
>> - Providing (a certain level of) database independency by supporting 
>> different renderers that can be customized to specific SQL dialects.
>> - Persistence of database queries in different storages (e.g. XML 
>> files, in a database, ...)
>> - Supporting dynamic query generation, e.g. if columns from different 
>> database tables are involved, the correct join conditions can be 
>> generated automatically
>> - Easy extensibility: just implement your own query part classes
>> Please let me know if there is some interest in this code. If not, 
>> what other options do I have to make it open source?
>> Thanks!
>> Oliver
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: commons-dev-help@jakarta.apache.org
> In the meantime I found out that there is surely some overlapping with 
> existing code in DB, e.g. the Criteria in Torque. But I suppose the 
> goals are a bit different (so an advantage of this library may be that 
> it is independent of a specific persistence engine). Maybe there is 
> enough space for a coexistence at first and later doublicate code can 
> be refactored?
> Thanks!
> Oliver

View raw message