permaculture playing cards*
The moose likes JDBC and the fly likes jdbc driver or any logic  for multiple database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc driver or any logic  for multiple database" Watch "jdbc driver or any logic  for multiple database" New topic
Author

jdbc driver or any logic for multiple database

shivahire
Greenhorn

Joined: Mar 05, 2001
Posts: 2
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
 
subject: jdbc driver or any logic for multiple database