Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc driver or any logic for multiple database

 
shivahire
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
We r in process of developing a product using J2EE platform. The core requirement is that my product should work for any underlying database(db). For discrepancy in few functions and keywords in various db we r not building the query in EJB directly. We r sending the broken form of query like criterias for search where in some support classes are used to
1) check the underlying instance of database
2) translate the functions(like max to maximum) which r db generic to specific db.
3) build the sql using a query builder and fire the query and get back the results to ejb.
I strongly feel its a very crude path. Is there any other way to do this? I have read about JDBC type 3 driver, which does all these magic for us. Kindly contribute ur i/p on this issue.
bye,
Shiva
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic