Use of other database instead of H2

In production environment it's recommended to use MySql, MS-SQL or Oracle database instead of H2 for reldb, insightdb, mapdb and tempdb.

Oracle is supported since Version 12c R2 because of name restriction to 30characters in former versions.

The following steps are necessary to change database to MS-SQL.

1. Stop wildfly-process.
2. For MS-SQL please download sqljdbc4.jar and copy to x:\GIS\wildfly\modules\system\layers\base\com\microsoft\main.

3. Edit standalone.xml.

   To deactivate h2 for reldb please edit x:\GIS\wildlfy\standalone\configuration\standalone.xml and

   a) Rename

   <datasource jndi-name="java:/jdbc/reldb"

   to

   <datasource jndi-name="java:/jdbc/reldb-h2"

   
   
   

   To activate mssql for reldb please rename

   <datasource jndi-name="java:/jdbc/reldb-mssql"

   to

   <datasource jndi-name="java:/jdbc/reldb"

   b) Set enabled=true in

   <datasource jndi-name= ... enabled="true"

   c) Adjust database-Url and user/password.

4. Start wildfly-process Oracle is very similiar. You should download ojdbc.jar and put it into x:\GIS\wildfly\modules \system\layers\base\com\oracle\main and rename <datasource jndi-name="java:/jdbc/reldb-oracle"

insightdb, mapdb and tempdb can be handled like reldb described above.

Please run "createIndex" for a single tree-configuration to check the system http://localhost:8080/insight-indexer-new.

Use of MySql

If you use MySQL please check parameter max_allowed_packet.

    mysql> select @@max_allowed_packet;

The default value for max_allowed_packet is 4mb and too low for downloads. Please adjust this value to 256mb and restart Wildfly or Tomee.

    mysql> set global max_allowed_packet=268435456;

Parameter can also be adjusted in Config-Files for mysql.