Are too Many native queries in Spring MVC with JPA project a normal deal? -
project technology stack:i working project using spring mvc. using jpa orm. sql database mysql.
issue: business logic has become lot complex in application. fetch data application, code using lot of native sql queries multiple joins.
this creates lot of problem while creating integration test cases. happens due fact when entity persisted using jpa's entity manager entity in first level cache. when next fetch query(which written in native sql) tries fetch data, cannot. happens because native sql queries goto database whereas 1st level cache synchronises database after whole test case has executed.
i wanted know if there workaround this?
Comments
Post a Comment