Recently I have encountered this question and answer is ......... ok .. first tell me what comes in your mind for solution. Something like me when I first encountered with this question :-).
Initially I thought as a solution that we can prepare multiple Query.xml and Query.properties or SQLMap( Ibatis) to supports multiple databases and can cache those during startup and would use @ runtime in application ...
But .. then I found another best way to do .... one of my friend suggested me to write Open SQL which supports all the databases . So single file and query plan which suites to all database helps to improve the scalabilty of the applciation with less coding and less maintainance.
SAP is implemented it .. check it out this link :
http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3969358411d1829f0000e829fbfe/content.htm
Cheers.....
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Ways to Cut Your Claude Code Token Usage Large language models are incredibly powerful, but they can also become surprisingly expensive wh...
-
If each of your microservices is containerized using Docker, you can use Docker Compose to define and run all of your services in one go. T...
-
Recently while installing android SDK , I was getting following error "Unable to elevate" error Solution I tried : 1. R... -
1 Right click on the project and select Export... . Select Javadoc , and click Next . 2 Make sure the Javadoc command refers to the Ja...
No comments:
Post a Comment
Thanks for your comment, will revert as soon as we read it.