Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Database Abstraction Layer : any implementation ?

 
Bartender
Posts: 1269
39
IBM DB2 Netbeans IDE Spring Java
  • 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.



 
author
Posts: 5856
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
Bartender
Posts: 1269
39
IBM DB2 Netbeans IDE Spring Java
  • 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...
 
Ranch Hand
Posts: 133
Hibernate Oracle Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As mentioned by Peter,
Hibernate already does that.
 
Ew. You guys are ugly with a capital UG. Here, maybe this tiny ad can help:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic