Hi, An approach we can follow is, to give query templates from a configuration file, so we don't have to embed/hard-code any queries in the code. I'm using this approach in our new BAM RDBMS connector implementation, where I'm going to use an XML configuration to have separate sections for each database type, the required queries. This implementation can be found here [1], specifically look for something like "H2FileDBAnalyticsDataSourceTest", "MySQLInnoDBAnalyticsDataSourceTest", and "QueryConfiguration" classes. QueryConfiguration will actually be converted to an JAXB mapping class in the future to represent a section in the source XML file that has the mappings. Reading from the actual XML configuration file is not yet done in my code.
[1] https://github.com/wso2-dev/carbon-analytics/tree/master/components/xanalytics Cheers, Anjana. On Fri, Nov 28, 2014 at 5:23 PM, Sriskandarajah Suhothayan <[email protected]> wrote: > The main issue is that we have to solve is the ability to handle different > syntax. > Please have a look at DSS and Hive Table definitions (from BAM) they may > help. > > Suho > > 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>* >> >> > > > -- > > *S. Suhothayan* > Technical Lead & Team Lead of WSO2 Complex Event Processor > *WSO2 Inc. *http://wso2.com > * <http://wso2.com/>* > lean . enterprise . middleware > > > *cell: (+94) 779 756 757 <%28%2B94%29%20779%20756%20757> | blog: > http://suhothayan.blogspot.com/ <http://suhothayan.blogspot.com/>twitter: > http://twitter.com/suhothayan <http://twitter.com/suhothayan> | linked-in: > http://lk.linkedin.com/in/suhothayan <http://lk.linkedin.com/in/suhothayan>* > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- *Anjana Fernando* Senior Technical Lead WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
