User Guide

Adobe LiveCycle Manually Configuring JBoss for BAM Server
Installing and Configuring LiveCycle for JBoss Connecting JBoss to the BAM metadata database 79
➤ To modify the SQL Server data-type mappings on JBoss:
1. Navigate to the [jboss bam root]/server/default/conf directory and open the
standardjbosscmp-jdbc.xml file in a text editor.
2. In the
<defaults> section near the top of the file, change the following parameter as indicated by the
bold text:
<datasource>java:/com.celequest.metadata.metaDatasource</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
<create-table>false</create-table>
...
<list-cache-max>10000</list-cache-max>
3. Locate the type-mappings element that has a name child element that contains the text
MS SQLSERVER2000, and insert the following code below the final function-mapping element:
<mapping>
<java-type>com.celequest.metadata.ejb.BigString</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
<java-type>com.celequest.jar.Jar</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
<java-type>com.celequest.alert.AlertFiring</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
<java-type>com.celequest.alert.AlertAck</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
<java-type>com.celequest.alert.AlertInstance</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
<java-type>com.celequest.util.misc.SerializableWrapper</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
4. Save and close the file.
5. Restart JBoss.