...

1. A transactional data source where the local client application's Rice tables are located. This is required by JOTM.

   Code Block
   borderStyle solid title classpath:edu/ucdavis/myapp/config/application-data.xml
   <bean id="dataSource" class="org.kuali.rice.core.database.XAPoolDataSource"> <property name="transactionManager" ref="jotm" /> <property name="driverClassName" value="${datasource.driver.name}" /> <property name="url" value="${datasource.url}" /> <property name="maxSize" value="${datasource.pool.size}" /> <property name="minSize" value="${datasource.initialSize}" /> <property name="maxWait" value="${datasource.pool.maxWait}" /> <property name="validationQuery" value="${datasource.pool.validationQuery}" /> <property name="username" value="${datasource.username}" /> <property name="password" value="${datasource.password}" /> </bean>

2. A non-transactional data source pointing to those same Rice tables. This is required by Quartz.

   Code Block
   borderStyle solid title classpath:edu/ucdavis/myapp/config/application-data.xml
   <bean id="nonTransactionalDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassNameurl" value="${datasource.driver.nameurl}" /> <property name="urlusername" value="${datasource.urlusername}" /> <property name="maxActivepassword" value="${datasource.pool.maxActivepassword}" /> <property name="minIdledriverClassName" value="${datasource.driver.minIdlename}" /> <property name="initialSize" value="${datasource.initialSize}" /> <property name="validationQueryminIdle" value="${datasource.pool.validationQueryminIdle}" /> <property name="usernamemaxActive" value="${datasource.usernamemaxActive}" /> <property name="passwordmaxWait" value="${datasource.passwordmaxWait}" /> <property name="accessToUnderlyingConnectionAllowedvalidationQuery" value="${datasource.accessToUnderlyingConnectionAllowedvalidationQuery}" /> </bean>

   A transactional data source pointing to the database of the Rice Standalone Server.

   Code Block
   borderStyle solid title classpath:edu/ucdavis/myapp/config/application-data.xml
   <bean id="standaloneDataSource" class="org.kuali.rice.core.database.XAPoolDataSource" <property name="testOnBorrow" value="${datasource.testOnBorrow}" /> <property name="transactionManagertestOnReturn" ref="jotm" /> <property name="driverClassName" value="${standalone.datasource.driver.namevalue="${datasource.testOnReturn}" /> <property name="urltestWhileIdle" value="${standalone.datasource.urltestWhileIdle}" /> <property name="maxSizeaccessToUnderlyingConnectionAllowed" value="${standalone.datasource.pool.sizeaccessToUnderlyingConnectionAllowed}" /> <property name="minSize</bean>

   Tip
   To take advantage of pooling capabilities, testOnBorrow should be set to true.

3. A transactional data source pointing to the database of the Rice Standalone Server.

   Code Block
   borderStyle solid title classpath:edu/ucdavis/myapp/config/application-data.xml
   <bean id="standaloneDataSource" class="org.kuali.rice.core.database.XAPoolDataSource"> <property name="transactionManager" ref="jotm" /> <property name="driverClassName" value="${standalone.datasource.driver.name}" /> <property name="url" value="${standalone.datasource.url}" /> <property name="maxSize" value="${standalone.datasource.pool.size}" /> <property name="minSize" value="${standalone.datasource.initialSize}" /> <property name="maxWait" value="${standalone.datasource.pool.maxWait}" /> <property name="validationQuery" value="${standalone.datasource.pool.validationQuery}" /> <property name="username" value="${standalone.datasource.username}" /> <property name="password" value="${standalone.datasource.password}" /> </bean>

KIM Service Configuration

UCD has implemented a custom KIM Identity Service which fetches Entity and Principal information from UCD LDAP.

Data Source Configuration

KIM Identity Service requires a data source for the UCD LDAP server defined by a bean named ldapContextSource

<bean id="ldapContextSource" class="org.springframework.ldap.core.support.LdapContextSource">
    <property name="url" value="${

...

ldap.

...

url}" />
    <property name="

...

base" value="${

...

ldap.base}" />
    <property name="

...

pooled" value="${

...

ldap.pooled}" />
    <property name="

...

userDn" value="${

...

ldap.

...

user}" />
    <property name="password" value="${

...

ldap.password}" />
</bean>

...

KIM Service Configuration

UCD has implemented a custom KIM Identity Service which fetches Entity and Principal information from UCD LDAP.

Data Source Configuration

...

Optionally, KIM Identity Service provides access to the PEOPLE_DISPLAY_NAME view in the ORG schema in Mothra defined by a bean named ldapContextSource whitePagesDataSource

<bean id="whitePagesDataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="url" value="${whitepages.datasource.url}"/>
    <property name="urlusername" value="${ldapwhitepages.datasource.urlusername}" />
    <property name="basepassword" value="${ldapwhitepages.datasource.basepassword}" />
    <property name="pooleddriverClassName" value="${ldap.pooledwhitepages.datasource.driver.name}" />
    <property name="userDninitialSize" value="${ldapwhitepages.datasource.userinitialSize}" />
    <property name="passwordminIdle" value="${ldapwhitepages.datasource.passwordminIdle}" />
</bean>

Optionally, KIM Identity Service provides access to the PEOPLE_DISPLAY_NAME view in the ORG schema in Mothra defined by a bean named whitePagesDataSource

<bean id="whitePagesDataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource"
    <property name="maxActive" value="${whitepages.datasource.maxActive}" />
    <property name="maxWait" value="${whitepages.datasource.maxWait}" />
    <property name="validationQuery" value="${whitepages.datasource.validationQuery}" />
    <property name="driverClassNametestOnBorrow" value="${whitepages.datasource.driver.nametestOnBorrow}" />
    <property name="urltestOnReturn" value="${whitepages.datasource.urltestOnReturn}" />
    <property name="usernametestWhileIdle" value="${whitepages.datasource.usernametestWhileIdle}" />
    <property name="passwordaccessToUnderlyingConnectionAllowed" value="${whitepages.datasource.passwordaccessToUnderlyingConnectionAllowed}" />
</bean>

Spring Bean Configuration

...