Thread: generic SQL implementations

generic SQL implementations

From
"Vinay"
Date:
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 and another not SQL at all ,index sequential files). I want the DAO to access the database during runtime. So I want my DAO to be independent of the SQL statements.The Database Interfrace would talk to either MySQL,or Oracle or any other database.So that  there is no  need to have  DAO for each database syntax, rather , this should be handled by a API thru an interface.
 
Here's and examples
 
Let's say for select statement , we supply table name, column names, where cluase , and's etc
 
The following method should handle the query
 
List getSelect(String tablename, List columnnames, List Orderby,.....) etc {
 
 
return queryresult
}  
 
 
Any ideas appreciated
Thank you
Vinay

Re: generic SQL implementations

From
"Donald Fraser"
Date:
I believe Borland's database engine (part of Delphi and C++ builder) tried to do this. My experience with it, albeit some years ago now, was that it was extremely slow.
 
Regards
Donald Fraser
----- Original Message -----
From: Vinay
Sent: Monday, July 07, 2003 3:11 PM
Subject: [ADMIN] generic SQL implementations

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 and another not SQL at all ,index sequential files). I want the DAO to access the database during runtime. So I want my DAO to be independent of the SQL statements.The Database Interfrace would talk to either MySQL,or Oracle or any other database.So that  there is no  need to have  DAO for each database syntax, rather , this should be handled by a API thru an interface.
 
Here's and examples
 
Let's say for select statement , we supply table name, column names, where cluase , and's etc
 
The following method should handle the query
 
List getSelect(String tablename, List columnnames, List Orderby,.....) etc {
 
 
return queryresult
}  
 
 
Any ideas appreciated
Thank you
Vinay