BeanManagedConnection

[Cantor, Scott]

On 10/22/20, 10:15 AM, "users on behalf of REDDIMALLI, ANUSHA" <users-bounces at shibboleth.net on behalf of REDDIMAA at mailbox.sc.edu> wrote:

>    What are replaceable attributes for the below to use in BeanManagedConnection?

That is up to the documentation of the JDBC driver you happen to be using, and those settings are pooling-related, which is up to the JDBC pooling driver you happen to be using.

The most common pooling drivers around are commons-dbcp2 and c3p0. dbcp2 is included in the distribution because it's used internally by the SimpleManagedConnection code.

Personally my data source for MariaDB looks like:

    <bean id="osu.LocalCache" class="org.apache.commons.dbcp2.BasicDataSource"
        p:driverClassName="org.mariadb.jdbc.Driver"
        p:url="jdbc:mysql://localhost:3306/shibboleth"
        p:username="root"
        p:password="%{osu.mariadb.password}"
        p:maxTotal="20"
        p:maxIdle="5"
        p:maxWaitMillis="5000"
        p:testOnBorrow="true"
        p:validationQuery="select 1"
        p:validationQueryTimeout="5" />

-- Scott