...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
<!-- Oracle database data source needs commons-dbcp-1.4.jar, commons-pool-1.x.jar, ojdbcx.jar in edit-webapp/WEB-INF/lib/ --> <!-- global.xml needs a new Oracle DB bean as in the previous example, but validationQuery needs to be modified in "select 1 from dual" --> <!-- Oracle Spring connection pooling data source configuration --> <bean id="OracleDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" p:driverClassName="%{datasource.driverClass}" p:url="%{datasource.jdbcUrl}" p:username="%{datasource.user}" p:password="%{datasource.password}" p:maxActive="10" p:maxIdle="5" p:maxWait="2000" p:testOnBorrow="true" p:validationQuery="select 1 from dual" p:validationQueryTimeout="5" /> <!-- Attributes in idp.properties --> datasource.driverClass = oracle.jdbc.OracleDriver datasource.jdbcUrl = jdbc:oracle:thin:@<serverFQDN>:1521:<dbmame> datasource.user = <USER> datasource.password = <PASS> <!-- example of attribute-resolver.xml portion for an attribute resolution using principalName as key--> <DataConnector xsi:type="dc:RelationalDatabase" id="oracledbcf" > <BeanManagedConnection>OracleDataSource</dc:BeanManagedConnection> <QueryTemplate> <![CDATA[ SELECT CF from DB.TABLE where USER_ID='$requestContext$resolutionContext.principalNameprincipal' ]]> </QueryTemplate> <Column columnName="CF" attributeID="personalUniqueID_it_CF" /> </DataConnector> |
...