Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Abstraction Layer : any implementation ?

 
Claude Moore
Ranch Hand
Posts: 793
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,

I'm wondering if exists any working implementation of a Database Abstraction layer concepts. With Database abstraction layer, I mean
a software which acts as a mediator between your programs and actual DBMS, hiding specific DBMS SQL dialects with one dialect of its own,
and letting you to write stored procs which may transparently access data to different DBMS.



 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Java Persistence API (JPA): http://docs.oracle.com/javaee/6/tutorial/doc/bnbpz.html

Hibernate: http://www.hibernate.org/

There are others. But none handle stored procedures in a generic fashion - those are always database specific (as far as I know)
 
Claude Moore
Ranch Hand
Posts: 793
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for your answer, Peter... JPA is a good choice but I had in mind something more similar to a middleware product which would act as a proxy for your queries and stored procedure.

For example, I can run SQL PreparedStatements against that middleware and it in turn will translate on the fly my queries into SQL Server, Db2 or other vendors' SQL specific dialect..

Of course, I have no idea if such software exists...
 
rohit chavan
Ranch Hand
Posts: 132
Hibernate Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As mentioned by Peter,
Hibernate already does that.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic