# OpenAM Administration Guide
2.2. Configuring Authentication Modules

Sidebar | Prev | Up | Next

### 2.2.11. Hints For the JDBC Authentication Module

The Java Database Connectivity (JDBC) module lets OpenAM connect to a database such as MySQL or Oracle DB to authenticate users.

ssoadm service name: `sunAMAuthJDBCService`

Connection Type

  Choose Connection pool is retrieved via JNDI to connect using the Java Naming and Directory Interface connection pool supported by the web container in which OpenAM runs. Choose Non-persistent JDBC connection to connect directly through the JDBC driver.

  ssoadm attribute: `sunAMAuthJDBCConnectionType`

Connection Pool JNDI Name

  When using Connection pool is retrieved via JNDI, this specifies the pool. How you configure connection pooling depends on the web container where you run OpenAM. Refer to the documentation for your web container for instructions on setting up connection pooling.

  ssoadm attribute: `sunAMAuthJDBCJndiName`

JDBC Driver

  When using Non-persistent JDBC connection, this specifies the JDBC driver provided by the database.

  The .jar containing the JDBC driver belongs in the `WEB-INF/lib` directory of the deployed OpenAM instance, and so you should add it to a custom OpenAM .war file that you deploy.

  ssoadm attribute: `sunAMAuthJDBCDriver`

JDBC URL

  When using Non-persistent JDBC connection, this specifies the URL to connect to the database.

  ssoadm attribute: `sunAMAuthJDBCUrl`

Database Username

  Specify the user name to open the database connection.

  ssoadm attribute: `sunAMAuthJDBCDbuser`

Database Password

  Specify the password for the user opening the database connection.

  ssoadm attribute: `sunAMAuthJDBCDbpassword`

Password Column Name

  Specify the database column name where passwords are stored.

  ssoadm attribute: `sunAMAuthJDBCPasswordColumn`

Prepared Statement

  Specify the SQL query to return the password corresponding to the user to authenticate.

  ssoadm attribute: `sunAMAuthJDBCStatement`

Class to Transform Password Syntax

  Specify the class that transforms the password retrieved to the same format as provided by the user.

  The default class expects the password in clear text. Custom classes must implement the `JDBCPasswordSyntaxTransform` interface.

  ssoadm attribute: `sunAMAuthJDBCPasswordSyntaxTransformPlugin`

Authentication Level

  Sets the authentication level used to indicate the level of security associated with the module. The value can range from 0 to any positive integer.

  ssoadm attribute: `sunAMAuthJDBCAuthLevel`