Working with Database Connection Pools
Follow this procedure to add connection pool information for all database connection pools, including the connection pools for OneData metadata, work, and release areas.
This procedure also contains the configurations required for SSO with integrated Windows authentication. For the additional SSO configurations, see
Implementing Kerberos-based SSO with
Integrated Windows Authentication.
1. Navigate to the directory < Software AG_directory >\profiles\ODE\configuration\com.softwareag.platform.config.propsloader.
2. For each database connection in your environment, follow these steps:
a. Create a property file for the connection pool in the format:
com.softwareag.catalina.resource.pid-<Repository_ID><Connection_Pool_Name>
.properties
b. In the connection pool properties file, add the following content:
url=jdbc:wm:<Database_Type>://<Host_Name>:<Port>;serviceName=<Database_Name>
;catalogOptions=1
name=jdbc /<Connection_Pool_Name>
@secure.password=<Password_in_Clear_Text>
context=/<OneData_Application_Context_Name>
maxIdle=10
maxActive=15
driverClassName=<Database_Connection_Driver>
maxWait=50000
username=<Database_Schema_User_Name>
factory=org.apache.tomcat.jdbc.pool.DataSourceFactory
type=javax.sql.DataSource
Note:
Do not include double quotes for any value in the properties file.
Example for MyRemoteConnection connection pool properties file MyRepo repository com.softwareag.catalina.resource.pid-MyRepoMyRemoteConnection:
url=jdbc:wm:oracle://MYHOST:1521;serviceName=ORCL;catalogOptions=1
name=jdbc/MyRemoteConnection
@secure.password=rdb_pswd
context=/onedata
maxIdle=10
maxActive=15
driverClassName=com.wm.dd.jdbc.oracle.OracleDriver
maxWait=5000
username=rdb_user
factory=org.apache.tomcat.jdbc.pool.DataSourceFactory
type=javax.sql.DataSource
c. Save and close the properties file.
3. Navigate to < Software AG_directory >\profiles\ODE\workspace\webapps\onedata\WEB-INF, and follow these steps:
a. Open the web.xml file.
b. Add the following <resource-ref> content for each database connection pool:
<resource-ref>
<description><Repository_Description></description>
<res-ref-name>jdbc/<Connection_Pool_Name></res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
Example for MyRemoteConnection connection pool:
<resource-ref>
<description>OneData MD DataSource</description>
<res-ref-name>jdbc/MyRemoteConnection</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
c. Save and close the file.
4. If OneData application is running, restart it.