For the JBoss Turnkey, all LiveCycle database connections to MySQL are through a JDBC connection pool. This is usually defined in %LC_INSTALL_ROOT%\jboss\server\all\deploy\adobe-ds.xml.
Usually, three connection pools are defined. EDC_DS is for Rights Management, IDP_DS is for the rest of LiveCycle and com.celequest.metadata.metaDatasource is for Ithe IBM Cognos Business Activity Monitor (BAM).
If you don’t plan to use Rights Management ES or BAM, you can delete the definitions for those two.
For a long-running, reliable and stable LiveCycle ES environment, the data source definition for MySQL should look something like as shown below. Only the definiton for IDP_DS is shown. If parts of the XML are cut off in the display, please look at the page source or download it (hover over the link, right-click the mouse and choose “save target as”.
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>IDP_DS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/adobe</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>adobe</user-name> <password>password</password> <min-pool-size>1</min-pool-size> <max-pool-size>30</max-pool-size> <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> <new-connection-sql>SELECT count(*) from DUAL</new-connection-sql> <check-valid-connection-sql>SELECT count(*) from DUAL</check-valid-connection-sql> <blocking-timeout-millis>20000</blocking-timeout-millis> <idle-timeout-minutes>1</idle-timeout-minutes> <autoReconnect>true</autoReconnect> <prepared-statement-cache-size>50</prepared-statement-cache-size> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> </local-tx-datasource> </datasources>
