I do understand that we'd already spent considerable amount of time rewriting the DAO layers implemented as part of RSS Manager to use JPA. However, some of the inconsistencies/issues observed in JPA provider implementations such as OpenJPA, etc got me thinking we should probably try to make things simpler particularly, since all of these database logics could be implemented in an ANSII compliant and vendor-neutral manner using native SQL. Then again, one might wonder why we don't opt to go get the JPA related issues fixed/use some stable JPA library to get over the said issues. That's obviously going be a little complicated as we might probably depend on some third party library acting as the JPA provider, the control of which is out of our hands. Therefore, this effort is primarily aimed at making things simpler and maintainable without getting ourselves dependent on any third party library for persisting entities manipulated as part of the respective DAO layers.
I'm +1 for this. Cheers, Prabath On Wed, Oct 15, 2014 at 2:37 PM, Harsha Kumara <hars...@wso2.com> wrote: > Hi, > > I'm looking through the feasibility and complexity of migrating rss > manager data access from JPA to native SQL. This is due to inconsistencies > cause by the JPA in the rss manager core. > > With the JPA most of the internal data access APIs use object mode to > perform CRUD operations. > With the migrations we will needs to change some APIs and and redesigns > things as there is no such a object model with native SQL. Also internal > data service access methods also take the benefit of the JPA object model > during the persistence. Most of the current APIs design in the way that > suits for the persistence. With the native all the persistence activities > will needs to be written with the SQL. Internal restructure will be needed > with the migration. > > @Prabath and Dhanuka WDYT? > > Appreciate any suggestions and thoughts on this. > > Thanks, > Harsha > > -- > Harsha Kumara > Software Engineer, WSO2 Inc. > Mobile: +94775505618 > Blog:harshcreationz.blogspot.com > -- Prabath Abeysekara Associate Technical Lead, Data TG. WSO2 Inc. Email: praba...@wso2.com Mobile: +94774171471
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
