* Drop the XWikiPage* fake tables (that were mapped to an SQL query) and use named native queries instead in order to keep the joins and constraints inside the union
* Drop the hierarchy.hbm.xml file as a consequence.
* Add support for executing native named queries (they behave exactly as a HQL named query)
* Put the named native SQL queries in a separate queries.hbm.xml that is loaded when XWiki starts (through an ApplicationStartedEvent listener)
* Write some query filters to modify the named native SQL queries (in order to limit the code that is aware of the SQL usage). Only these query filters need to be updated in case we move to HQL.

* Move the hierarchy mapping in a separate file to avoid duplication.

XWIKI-13400: Hibernate does not send characters in the right encoding to the MySQL database in default Debian setup

[Misc] Since we use a third-party connection pool (DBCP by default) we don't need to set Hibernat's internal pool configuration (they're not used). See https://docs.jboss.org/hibernate/orm/3.3/reference/en-US/html/session-configuration.html#configuration-hibernatejdbc for example.

XWIKI-11858: Upgrade Hibernate and DBCP Connection Provider code to work with DBCP 2.1

* Added config

XWIKI-9131: xwiki.virtual_mode propety is inserted at the wrong location in the hibernate configuration file

* fix wrong order in hibernate configuration

* Added configuration option so that existing postgresql users who are using the database mode are not broke,. Note: they'll need to read the release notes and set <property name="xwiki.virtual_mode">database</property>

* Tested on PostGreSQL 8.4.12 with basic manual tests. Need to be tested more thoroughly on various versions and with more tests.

  - fix the hibernate config to have no impact on other DB than HSQLDB and to be more easy to be edited by a sed script

* Use correct BoneCP class (thanks Thomas Mortagne)

+ Removed deprecated usage of session.connection()
+ Added configuration options (commented out) for using BoneCP with Hibernate (ATM using DBCP fails with HSQLDB for some unknown reasons but it seems to work fine with BoneCP - Need to be tested more though)

 * Set Hibernate "jdbc.use_streams_for_binary" to "false", according to recommendation here: https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 (Note that we need to keep the "materialized_clob" typedef in xwiki.oracle.hbm.xml even though the Hibernate migration guide says the issue was fixed in Hibernate 3.6.1, see http://bit.ly/z6xNZs )
 * Aligned "connection.SetBigStringTryClob" and "jdbc.batch_size" properties with the other properties by removing the "hibernate." prefix.
 * Comment improvements

* Added custom style for shell/properties files
* Started fixing some license headers in xwiki-platform

Updating configuration

Done.

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/platform/xwiki-tools/trunk@24773 f329d543-caf0-0310-9063-dda96c69346f

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/platform/xwiki-tools/trunk@23874 f329d543-caf0-0310-9063-dda96c69346f

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/platform/xwiki-tools/trunk@23864 f329d543-caf0-0310-9063-dda96c69346f

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/platform/xwiki-tools/trunk@23861 f329d543-caf0-0310-9063-dda96c69346f

Done.


git-svn-id: https://svn.xwiki.org/svnroot/xwiki/platform/xwiki-tools/trunk@19415 f329d543-caf0-0310-9063-dda96c69346f

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/xwiki-platform/xwiki-tools/trunk@8776 f329d543-caf0-0310-9063-dda96c69346f

Use Oracle10gDialect hibernate dialect by default since OracleDialect dialect is now deprecated in Hibernate 3.2.5.ga


git-svn-id: https://svn.xwiki.org/svnroot/xwiki/xwiki-platform/xwiki-tools/trunk@6935 f329d543-caf0-0310-9063-dda96c69346f

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/xwiki-platform/xwiki-tools/trunk@6400 f329d543-caf0-0310-9063-dda96c69346f

Fixed.
Workaround needed because the way hibernate works with boolean fields in mysql.
Needs to be tested.


git-svn-id: https://svn.xwiki.org/svnroot/xwiki/xwiki-platform/xwiki-tools/trunk@6345 f329d543-caf0-0310-9063-dda96c69346f

XTOOLS-17: Add commented out configuration for PostreSQL in the default Hibernate configuration file

git-svn-id: https://svn.xwiki.org/svnroot/xwiki/xwiki-platform/xwiki-tools/trunk@5333 f329d543-caf0-0310-9063-dda96c69346f