Here is what I have done assuming JBoss/MySQL install.
1. Create a new MySQL database. I'll assume DB name is lc100.
2. Create a new datasource configuration file. Datasource
configuration files end with the suffix -ds.xml. Assume I create a
file lc-ds.xml. Contents might have something like:
<?xml version="1.0" encoding="UTF-8" ?>
<datasources>
<local-tx-datasource>
<jndi-name>LC100</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/lc100</connection-
url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>password</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>30</max-pool-size>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>
<prepared-statement-cache-size>100</prepared-statement-cache-
size>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-
isolation>
</local-tx-datasource>
</datasources>
You can actually copy the above text from the LC datasource file
located at C:\Adobe\LiveCycle8.2\jboss\server\all\deploy\adobe-ds.xml
and make the appropriate changes for your DB.
3. Copy this datasource configuration file (lc-ds.xml) to the JBoss
deploy directory (C:\Adobe\LiveCycle8.2\jboss\server\all\deploy).
4. Now when I use an operation that needs the datasource name for the
lc100 DB, I would use java:/LC100 as the datasource name.
Bob