This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc driver or any logic for multiple database

 
shivahire
Greenhorn
Posts: 2
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic