How to setup the JBoss JDBC connections?
Posted by Appeon Support on 04 April 2012 10:57 AM

1. Copy the JDBC driver(Microsoft SQL Server JDBC driver: sqljdbc.jar or jTDS JDBC driver: jtds-1.2.jar) to the Jboss folder.
%JBOSS_HOME%\server\instance\lib (%JBOSS_HOME% indicates the JBoss installation path)

Here we take SQL Server as an example, for more information about your specific driver type, please refer to APB Help|Appeon Server Configuration Guide for J2EE|Database Connection Setup|JDBC driver preparation|Copying drivers to Appeon Server.

2. Configure the JBoss datasource.
Copy the [jboss_root_directory]/docs/examples/jca/ mssql-ds.xml,  you can modify the contents red below. And then copied to the [jboss_root_directory]/server/default/deploy directory.

This is the Microsoft SQL Server JDBC driver datsource xml file.








        <!-- sql to call when connection is created

        <new-connection-sql>some arbitrary sql</new-connection-sql>



        <!-- sql to call on an existing pooled connection when it is obtained from pool

        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>



      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->


         <type-mapping>MS SQLSERVER</type-mapping>




3. Restart the JBoss.

4. Go to the AEM Console > Application Properties > Transaction Objects > [your application name] to setup the Transaction Object.

(1 votes)
This article was helpful
This article was not helpful

Comments (0)
Post a new comment 

Please login if you wish to leave a comment about this article.

Help Desk Software by Kayako Fusion

Copyright © 2019 Appeon.  All rights reserved.  Terms of Use | Privacy Statement