Issue

• What are the relevant datasource parameters for below parameters in EAP 6?
  • <prepared-statement-cache-size/>
  • <share-prepared-statements/>
  • <type-mapping/>
  • <no-tx-datasource/>
• I have a question about the configuration of datasources in standalone.xml . We are going to upgrade one of our JBoss EAP 5 to JBoss EAP 6.3.3.
  In the JBoss EAP 5 there is file called abc-ds.xml and looks as follow:

<datasources>
  <no-tx-datasource>
    <jndi-name>TestDataSource</jndi-name>
    <driver-class>oracle.jdbc.OracleDriver</driver-class>

    <connection-url>jdbc:oracle:thin:@hostname:1521:XYZ</connection-url>
    <connection-property name="readOnly">true</connection-property>
    <user-name>User</user-name>
    <password>Password</password>

    <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
    <!-- valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name -->
    <!-- Checks the Oracle error codes and messages for fatal errors -->
    <!-- exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name -->

    <min-pool-size>10</min-pool-size>
    <max-pool-size>20</max-pool-size>

    <!-- idle-timeout-minutes>0</idle-timeout-minutes -->
    <!-- blocking-timeout-millis>9000</blocking-timeout-millis -->
    <!-- Enable statement-cache - default is 0 with parse everything -->

    <prepared-statement-cache-size>30</prepared-statement-cache-size>
    <share-prepared-statements>true</share-prepared-statements>
    <type-mapping>Oracle9i</type-mapping>
  </no-tx-datasource>
</datasources>