Native MySQL usage

For performance reasons, some native mysql queries are used in Asqatasun.

These queries are present in 3 classes (found by searching the “createNativeQuery” occurence in the source code) :

  • ContentDAOImpl (persistence subproject of engine) -> 6 queries
  • StatisticsDAOImpl (tgol-persistence subproject of web-app) -> 10 queries
  • TgolParameterDAOImpl (tgol-persistence subproject of web-app) -> 1 query

In case of change of the JDBC layer, these queries HAVE to be refactored to fit with the new data source.

Another approach may lead to a change of these queries to make them use the JPA interface