generic SQL implementation

2003-07-07 Thread Vinay
Has anybody implemented a generic implementation for querying databases during runtime. I am using DAO's for data access layer. But I want to furthur move the database logic to down one more layer of abstraction.I am dealing with different kinds of database (eg. let's say a MySQL, MS Access

RE: generic SQL implementation

2003-07-07 Thread Hookom, Jacob
: generic SQL implementation Has anybody implemented a generic implementation for querying databases during runtime. I am using DAO's for data access layer. But I want to furthur move the database logic to down one more layer of abstraction.I am dealing with different kinds of database (eg

Re: generic SQL implementation

2003-07-07 Thread David Graham
There is a Mapper project in the commons sandbox that might help you. It allows you to store SQL in a properties file to remove it from your code. Also, it acts as a layer between your app and your persistence technology so you can swap in an O/R mapping tool, EJBs, etc if you decide against

Re: generic SQL implementation

2003-07-07 Thread Vinay
, 2003 11:35 AM Subject: Re: generic SQL implementation There is a Mapper project in the commons sandbox that might help you. It allows you to store SQL in a properties file to remove it from your code. Also, it acts as a layer between your app and your persistence technology so you can swap

Re: generic SQL implementation

2003-07-07 Thread Mark Lowe
I use torque and IMHO combined with struts , it slides through the molecules of wetness like an eel through sea weed .. http://db.apache.org/torque A chap called Ville who posted this group a few weeks ago sent me some notes where he spent a week of so gathering sources of info on how to get

Re: generic SQL implementation

2003-07-07 Thread David Graham
, this might be the one I am looking for ,even though I wanted to implement the API on my own. Thanks a lot VInay - Original Message - From: David Graham [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, July 07, 2003 11:35 AM Subject: Re: generic SQL

RE: generic SQL implementation

2003-07-07 Thread Yansheng Lin
); } -Original Message- From: David Graham [mailto:[EMAIL PROTECTED] Sent: July 7, 2003 10:24 AM To: Struts Users Mailing List Subject: Re: generic SQL implementation Mapper doesn't have a real website yet but you can view the source online at: http://cvs.apache.org/viewcvs.cgi/jakarta-commons

RE: generic SQL implementation

2003-07-07 Thread David Graham
( java.util.ArrayList, org.apache.commons.mapper.TestMapper); } -Original Message- From: David Graham [mailto:[EMAIL PROTECTED] Sent: July 7, 2003 10:24 AM To: Struts Users Mailing List Subject: Re: generic SQL implementation Mapper doesn't have a real