<source adapterClass="edu.internet2.middleware.grouper.subj.GrouperJdbcSourceAdapter2">
    <id>tng</id>
    <name>TNG users</name>
     <type>person</type>
     <init-param>
       <param-name>jdbcConnectionProvider</param-name>
       <param-value>edu.internet2.middleware.subject.provider.C3p0JdbcConnectionProvider</param-value>
     </init-param>

     <init-param>
       <param-name>maxResults</param-name>
       <param-value>1000</param-value>
     </init-param>

    <!-- on a findPage() this is the most results returned -->
    <init-param>
      <param-name>maxPageSize</param-name>
      <param-value>100</param-value>
    </init-param>

     <!-- note: again, if you use GrouperJdbcConnectionProvider, then you should not fill out maxActive, maxIdle,
                maxWait, dbDriver, dbUrl, dbUser, dbPwd, since it will use the grouper.hibernate.properties db settings -->

     <init-param>
       <param-name>maxActive</param-name>
       <param-value>16</param-value>
     </init-param>
     <init-param>
       <param-name>maxIdle</param-name>
       <param-value>16</param-value>
     </init-param>
     <init-param>
       <param-name>maxWait</param-name>
       <param-value>-1</param-value>
     </init-param>

     <!--
                     e.g. mysql:           com.mysql.jdbc.Driver
      e.g. p6spy (log sql): com.p6spy.engine.spy.P6SpyDriver
        for p6spy, put the underlying driver in spy.properties
      e.g. oracle:          oracle.jdbc.driver.OracleDriver
      e.g. hsqldb:          org.hsqldb.jdbcDriver
      e.g. postgres:        org.postgresql.Driver -->

     <init-param>
       <param-name>dbDriver</param-name>
       <param-value>com.p6spy.engine.spy.P6SpyDriver</param-value>
     </init-param>

     <!--
                e.g. mysql:           jdbc:mysql://localhost:3306/grouper
      e.g. p6spy (log sql): [use the URL that your DB requires]
      e.g. oracle:          jdbc:oracle:thin:@server.school.edu:1521:sid
      e.g. hsqldb (a):      jdbc:hsqldb:dist/run/grouper;create=true
      e.g. hsqldb (b):      jdbc:hsqldb:hsql://localhost:9001
      e.g. postgres:        jdbc:postgresql:grouper -->

     <init-param>
       <param-name>dbUrl</param-name>
       <param-value>jdbc:mysql://localhost:3306/tng</param-value>
     </init-param>
     <init-param>
       <param-name>dbUser</param-name>
       <param-value>root</param-value>
     </init-param>
     <init-param>
       <param-name>dbPwd</param-name>
       <param-value></param-value>
     </init-param>

      <init-param>
       <param-name>dbTableOrView</param-name>
       <param-value>TNG_USERS</param-value>
     </init-param>
      <init-param>
       <param-name>subjectIdCol</param-name>
       <param-value>idTNG_USERS</param-value>
     </init-param>
     <init-param>
       <param-name>nameCol</param-name>
       <param-value>users</param-value>
     </init-param>
     <init-param>
       <param-name>descriptionCol</param-name>
       <param-value>users</param-value>
     </init-param>
     <init-param>
       <!-- search col where general searches take place, lower case -->
       <param-name>lowerSearchCol</param-name>
       <param-value>users</param-value>
     </init-param>
     <init-param>
       <!-- optional col if you want the search results sorted in the API (note, UI might override) -->
       <param-name>defaultSortCol</param-name>
       <param-value>users</param-value>
     </init-param>
     <init-param>
       <!-- col which identifies the row, perhaps not subjectId, add multiple by incrementing the 0 index -->
       <param-name>subjectIdentifierCol0</param-name>
       <param-value>idTNG_USERS</param-value>
     </init-param>
     <!-- now you can count up from 0 to N of attributes for various cols.
          The name is how to reference in subject.getAttribute() -->
     <init-param>
       <param-name>subjectAttributeCol0</param-name>
       <param-value>type</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeName0</param-name>
       <param-value>type</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeCol1</param-name>
       <param-value>email</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeName1</param-name>
       <param-value>email</param-value>
     </init-param>
     <init-param>
       <param-name>sortAttribute0</param-name>
       <param-value>users</param-value>
     </init-param>
     <init-param>
       <param-name>searchAttribute0</param-name>
       <param-value>searchAttribute0</param-value>
     </init-param>
     <internal-attribute>searchAttribute0</internal-attribute>
   </source>