Modifying WildFly settings

This section explains how to modify the bin\Standalone.conf.bat, bin/standalone.conf.ps1 and standalone\configuration\standalone.xml files.

bin\Standalone.conf.bat or bin/standalone.conf.ps1
- : By default WildFly is configured to only allow 512 mb of memory for Java. Search “Xmx” in these files and set it to at least 2048M. If the Expere cache manager is showing On-Disk Hits, that is an indicator you need to increase the Xmx setting to achieve better performance.
  Note: It is also recommended to set JAVA_HOME to the location were Java is installed.
standalone\configuration\standalone.xml
- Consider changing the <root-logger> log level from INFO to ERROR to reduce the amount of logs generated from WildFly.
- Consider changing the port used by WildFly. By default WildFly uses port 8080. If your server already has a different application using that port then you configure that by searching for “offset” in standalone.xml. Change the "0" at the end of jboss.socket.binding.port-offset:0 to determine the port. For example if you set that to 1 then WildFly will run on port 8081.
- To set up Expere to use a Microsoft SQL database for your content, perform the following:
  1. Add the following to standalone.xml after the “ExampleDS” entry:
```
<datasource jta="true" jndi-name="java:/jdbc/ExpereDoc" pool-name="ExpereDoc" enabled="true" use-java-context="true" use-ccm="true">
    <connection-url>jdbc:jtds:sqlserver://localhost:1433;DatabaseName=ExpereApp</connection-url>
        <driver>jTDS</driver>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <pool>
            <min-pool-size>10</min-pool-size>
            <max-pool-size>100</max-pool-size>
            <prefill>true</prefill>
            <use-strict-min>false</use-strict-min>
            <flush-strategy>FailingConnectionOnly</flush-strategy>
        </pool>
    
    <statement>
        <prepared-statement-cache-size>100</prepared-statement-cache-size>
        <share-prepared-statements>true</share-prepared-statements>
    </statement>
</datasource>
```
  2. Add the following to the <drivers> section after the h2 driver:
```
<driver name="jTDS" module="net.sourceforge.jtds">
    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
    <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
</driver>
```
  3. Change the <default-bindings> entry to the following:
```
<default-bindings context-service="java:jboss/ee/concurrency/context/default" 
datasource="java:/jdbc/ExpereDoc" managed-executor-
service="java:jboss/ee/concurrency/executor/default" managed-scheduled-executor-
service="java:jboss/ee/concurrency/scheduler/default" managed-thread-
factory="java:jboss/ee/concurrency/factory/default"/>
```
  4. In the wildfly-10.0.0.Final\modules folder, perform the following:
    1. Download the jTDS driver here.
      Note: Expere supports version 1.2.5.
    2. Create a folder called net; create a subfolder called sourceforge.
    3. Within sourceforge create a folder called jtds; create a subfolder called main.
    4. Inside main, copy the jtds-1.2.5.jar from the downloaded dist ZIP file
    5. Create a file called module.xml that contains the following:
```
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="net.sourceforge.jtds">
  <resources>
    <resource-root path="jtds-1.2.5.jar"/>
        
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>
```
    6. From the dist ZIP file, copy ntlmauth.dll from the x64 folder to your Java JRE bin folder; for example: C:\Program Files\Java\jdk1.8.0_162\jre\bin.