Hi, Maintenance wise it's nice to keep queries in separate XML. And I think it's better to keep all the generic queries in a one section of the XML and keep DBMS specific queries in separate sections. So you don't need to rewrite common queries for each type. Also better to consider MS SQL Server as well in testing ( if it's supported DB type) as there are many syntax differences compared to Oracle and mysql
On Fri, Nov 28, 2014 at 4:49 PM, Damith Wickramasinghe <[email protected]> wrote: > Hi, > > Currently we have the support only for Mysql and it is decided to > implement a generic adapter to support any RDBMS database. For now adapter > implementation will be focused on supporting Oracle, Mysql and H2. > > I will update the thread on decided architecture for the said requirement > soon. Any feedbacks on the requirement will be greatly appreciated. > > Regards, > Damith. > > -- > Software Engineer > WSO2 Inc.; http://wso2.com > <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> > lean.enterprise.middleware > > mobile: *+94728671315 <%2B94728671315>* > > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- *Lahiru Cooray* Software Engineer WSO2, Inc.;http://wso2.com/ lean.enterprise.middleware Mobile: +94 715 654154
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
