JDBCRealm (Apache Tomcat 7.0.67 API Documentation)

java.lang.Object
- org.apache.catalina.util.LifecycleBase
- - org.apache.catalina.util.LifecycleMBeanBase
  - - org.apache.catalina.realm.RealmBase
    - - org.apache.catalina.realm.JDBCRealm

All Implemented Interfaces:

javax.management.MBeanRegistration, Lifecycle, Realm
```
public class JDBCRealm
extends RealmBase
```
Implementation of Realm that works with any JDBC supported database. See the JDBCRealm.howto for more details on how to set up the database and for configuration options.
For a Realm implementation that supports connection pooling and doesn't require synchronisation of authenticate(), getPassword(), roles() and getPrincipal() or the ugly connection logic use the DataSourceRealm.

Author:

Craig R. McClanahan, Carson McDonald, Ignacio Ortega

Nested Class Summary
- Nested classes/interfaces inherited from class org.apache.catalina.realm.RealmBase
  RealmBase.AllRolesMode

Field Summary

Fields
Modifier and Type	Field and Description
`protected java.lang.String`	`connectionName` The connection username to use when trying to connect to the database.
`protected java.lang.String`	`connectionPassword` The connection URL to use when trying to connect to the database.
`protected java.lang.String`	`connectionURL` The connection URL to use when trying to connect to the database.
`protected java.sql.Connection`	`dbConnection` The connection to the database.
`protected java.sql.Driver`	`driver` Instance of the JDBC Driver class we use as a connection factory.
`protected java.lang.String`	`driverName` The JDBC driver to use.
`protected static java.lang.String`	`info` Descriptive information about this Realm implementation.
`protected static java.lang.String`	`name` Descriptive information about this Realm implementation.
`protected java.sql.PreparedStatement`	`preparedCredentials` The PreparedStatement to use for authenticating users.
`protected java.sql.PreparedStatement`	`preparedRoles` The PreparedStatement to use for identifying the roles for a specified user.
`protected java.lang.String`	`roleNameCol` The column in the user role table that names a role
`protected java.lang.String`	`userCredCol` The column in the user table that holds the user's credentials
`protected java.lang.String`	`userNameCol` The column in the user table that holds the user's name
`protected java.lang.String`	`userRoleTable` The table that holds the relation between user's and roles
`protected java.lang.String`	`userTable` The table that holds user data.

Fields inherited from class org.apache.catalina.realm.RealmBase
allRolesMode, container, containerLog, digest, digestEncoding, md, md5Encoder, md5Helper, realmPath, sm, stripRealmForGss, support, validate, x509UsernameRetriever, x509UsernameRetrieverClassName

Fields inherited from class org.apache.catalina.util.LifecycleMBeanBase
mserver

Fields inherited from interface org.apache.catalina.Lifecycle
AFTER_DESTROY_EVENT, AFTER_INIT_EVENT, AFTER_START_EVENT, AFTER_STOP_EVENT, BEFORE_DESTROY_EVENT, BEFORE_INIT_EVENT, BEFORE_START_EVENT, BEFORE_STOP_EVENT, CONFIGURE_START_EVENT, CONFIGURE_STOP_EVENT, PERIODIC_EVENT, START_EVENT, STOP_EVENT

Constructor Summary

Constructors
Constructor and Description

JDBCRealm()

Constructors
Constructor and Description
`JDBCRealm()`

Method Summary

Methods
Modifier and Type	Method and Description
`java.security.Principal`	`authenticate(java.sql.Connection dbConnection, java.lang.String username, java.lang.String credentials)` Return the Principal associated with the specified username and credentials, if there is one; otherwise return `null`.
`java.security.Principal`	`authenticate(java.lang.String username, java.lang.String credentials)` Return the Principal associated with the specified username and credentials, if there is one; otherwise return `null`.
`protected void`	`close(java.sql.Connection dbConnection)` Close the specified database connection.
`protected java.sql.PreparedStatement`	`credentials(java.sql.Connection dbConnection, java.lang.String username)` Return a PreparedStatement configured to perform the SELECT required to retrieve user credentials for the specified username.
`java.lang.String`	`getConnectionName()` Return the username to use to connect to the database.
`java.lang.String`	`getConnectionPassword()` Return the password to use to connect to the database.
`java.lang.String`	`getConnectionURL()` Return the URL to use to connect to the database.
`java.lang.String`	`getDriverName()` Return the JDBC driver that will be used.
`java.lang.String`	`getInfo()` Return descriptive information about this Realm implementation and the corresponding version number, in the format `<description>/<version>`.
`protected java.lang.String`	`getName()` Return a short name for this Realm implementation.
`protected java.lang.String`	`getPassword(java.lang.String username)` Return the password associated with the given principal's user name.
`protected java.security.Principal`	`getPrincipal(java.lang.String username)` Return the Principal associated with the given user name.
`java.lang.String`	`getRoleNameCol()` Return the column in the user role table that names a role.
`protected java.util.ArrayList<java.lang.String>`	`getRoles(java.lang.String username)` Return the roles associated with the gven user name.
`java.lang.String`	`getUserCredCol()` Return the column in the user table that holds the user's credentials.
`java.lang.String`	`getUserNameCol()` Return the column in the user table that holds the user's name.
`java.lang.String`	`getUserRoleTable()` Return the table that holds the relation between user's and roles.
`java.lang.String`	`getUserTable()` Return the table that holds user data..
`protected java.sql.Connection`	`open()` Open (if necessary) and return a database connection for use by this Realm.
`protected void`	`release(java.sql.Connection dbConnection)` Deprecated. Unused
`protected java.sql.PreparedStatement`	`roles(java.sql.Connection dbConnection, java.lang.String username)` Return a PreparedStatement configured to perform the SELECT required to retrieve user roles for the specified username.
`void`	`setConnectionName(java.lang.String connectionName)` Set the username to use to connect to the database.
`void`	`setConnectionPassword(java.lang.String connectionPassword)` Set the password to use to connect to the database.
`void`	`setConnectionURL(java.lang.String connectionURL)` Set the URL to use to connect to the database.
`void`	`setDriverName(java.lang.String driverName)` Set the JDBC driver that will be used.
`void`	`setRoleNameCol(java.lang.String roleNameCol)` Set the column in the user role table that names a role.
`void`	`setUserCredCol(java.lang.String userCredCol)` Set the column in the user table that holds the user's credentials.
`void`	`setUserNameCol(java.lang.String userNameCol)` Set the column in the user table that holds the user's name.
`void`	`setUserRoleTable(java.lang.String userRoleTable)` Set the table that holds the relation between user's and roles.
`void`	`setUserTable(java.lang.String userTable)` Set the table that holds user data.
`protected void`	`startInternal()` Prepare for the beginning of active use of the public methods of this component and implement the requirements of `LifecycleBase.startInternal()`.
`protected void`	`stopInternal()` Gracefully terminate the active use of the public methods of this component and implement the requirements of `LifecycleBase.stopInternal()`.

Methods inherited from class org.apache.catalina.util.LifecycleMBeanBase
destroyInternal, getDomain, getObjectName, postDeregister, postRegister, preDeregister, preRegister, register, setDomain, unregister

Methods inherited from class org.apache.catalina.util.LifecycleBase
addLifecycleListener, destroy, findLifecycleListeners, fireLifecycleEvent, getState, getStateName, init, removeLifecycleListener, setState, setState, start, stop

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - connectionName
```
protected java.lang.String connectionName
```
    The connection username to use when trying to connect to the database.
  - connectionPassword
```
protected java.lang.String connectionPassword
```
    The connection URL to use when trying to connect to the database.
  - connectionURL
```
protected java.lang.String connectionURL
```
    The connection URL to use when trying to connect to the database.
  - dbConnection
```
protected java.sql.Connection dbConnection
```
    The connection to the database.
  - driver
```
protected java.sql.Driver driver
```
    Instance of the JDBC Driver class we use as a connection factory.
  - driverName
```
protected java.lang.String driverName
```
    The JDBC driver to use.
  - info
```
protected static final java.lang.String info
```
    Descriptive information about this Realm implementation.
    
    See Also:
    Constant Field Values
  - name
```
protected static final java.lang.String name
```
    Descriptive information about this Realm implementation.
    
    See Also:
    Constant Field Values
  - preparedCredentials
```
protected java.sql.PreparedStatement preparedCredentials
```
    The PreparedStatement to use for authenticating users.
  - preparedRoles
```
protected java.sql.PreparedStatement preparedRoles
```
    The PreparedStatement to use for identifying the roles for a specified user.
  - roleNameCol
```
protected java.lang.String roleNameCol
```
    The column in the user role table that names a role
  - userCredCol
```
protected java.lang.String userCredCol
```
    The column in the user table that holds the user's credentials
  - userNameCol
```
protected java.lang.String userNameCol
```
    The column in the user table that holds the user's name
  - userRoleTable
```
protected java.lang.String userRoleTable
```
    The table that holds the relation between user's and roles
  - userTable
```
protected java.lang.String userTable
```
    The table that holds user data.
- Constructor Detail
  - JDBCRealm
```
public JDBCRealm()
```
- Method Detail
  - getConnectionName
```
public java.lang.String getConnectionName()
```
    Return the username to use to connect to the database.
  - setConnectionName
```
public void setConnectionName(java.lang.String connectionName)
```
    Set the username to use to connect to the database.
    
    Parameters:
    connectionName - Username
  - getConnectionPassword
```
public java.lang.String getConnectionPassword()
```
    Return the password to use to connect to the database.
  - setConnectionPassword
```
public void setConnectionPassword(java.lang.String connectionPassword)
```
    Set the password to use to connect to the database.
    
    Parameters:
    connectionPassword - User password
  - getConnectionURL
```
public java.lang.String getConnectionURL()
```
    Return the URL to use to connect to the database.
  - setConnectionURL
```
public void setConnectionURL(java.lang.String connectionURL)
```
    Set the URL to use to connect to the database.
    
    Parameters:
    connectionURL - The new connection URL
  - getDriverName
```
public java.lang.String getDriverName()
```
    Return the JDBC driver that will be used.
  - setDriverName
```
public void setDriverName(java.lang.String driverName)
```
    Set the JDBC driver that will be used.
    
    Parameters:
    driverName - The driver name
  - getRoleNameCol
```
public java.lang.String getRoleNameCol()
```
    Return the column in the user role table that names a role.
  - setRoleNameCol
```
public void setRoleNameCol(java.lang.String roleNameCol)
```
    Set the column in the user role table that names a role.
    
    Parameters:
    roleNameCol - The column name
  - getUserCredCol
```
public java.lang.String getUserCredCol()
```
    Return the column in the user table that holds the user's credentials.
  - setUserCredCol
```
public void setUserCredCol(java.lang.String userCredCol)
```
    Set the column in the user table that holds the user's credentials.
    
    Parameters:
    userCredCol - The column name
  - getUserNameCol
```
public java.lang.String getUserNameCol()
```
    Return the column in the user table that holds the user's name.
  - setUserNameCol
```
public void setUserNameCol(java.lang.String userNameCol)
```
    Set the column in the user table that holds the user's name.
    
    Parameters:
    userNameCol - The column name
  - getUserRoleTable
```
public java.lang.String getUserRoleTable()
```
    Return the table that holds the relation between user's and roles.
  - setUserRoleTable
```
public void setUserRoleTable(java.lang.String userRoleTable)
```
    Set the table that holds the relation between user's and roles.
    
    Parameters:
    userRoleTable - The table name
  - getUserTable
```
public java.lang.String getUserTable()
```
    Return the table that holds user data..
  - setUserTable
```
public void setUserTable(java.lang.String userTable)
```
    Set the table that holds user data.
    
    Parameters:
    userTable - The table name
  - getInfo
```
public java.lang.String getInfo()
```
    Return descriptive information about this Realm implementation and the corresponding version number, in the format <description>/<version>.
    
    Specified by:
    
    getInfo in interface Realm
    
    Overrides:
    
    getInfo in class RealmBase
  - authenticate
```
public java.security.Principal authenticate(java.lang.String username,
                                   java.lang.String credentials)
```
    Return the Principal associated with the specified username and credentials, if there is one; otherwise return null. If there are any errors with the JDBC connection, executing the query or anything we return null (don't authenticate). This event is also logged, and the connection will be closed so that a subsequent request will automatically re-open it.
    
    Specified by:
    
    authenticate in interface Realm
    
    Overrides:
    
    authenticate in class RealmBase
    
    Parameters:
    username - Username of the Principal to look up
    credentials - Password or other credentials to use in authenticating this username
  - authenticate
```
public java.security.Principal authenticate(java.sql.Connection dbConnection,
                                   java.lang.String username,
                                   java.lang.String credentials)
```
    Return the Principal associated with the specified username and credentials, if there is one; otherwise return null.
    
    Parameters:
    dbConnection - The database connection to be used
    username - Username of the Principal to look up
    credentials - Password or other credentials to use in authenticating this username
  - close
```
protected void close(java.sql.Connection dbConnection)
```
    Close the specified database connection.
    
    Parameters:
    dbConnection - The connection to be closed
  - credentials
```
protected java.sql.PreparedStatement credentials(java.sql.Connection dbConnection,
                                     java.lang.String username)
                                          throws java.sql.SQLException
```
    Return a PreparedStatement configured to perform the SELECT required to retrieve user credentials for the specified username.
    
    Parameters:
    dbConnection - The database connection to be used
    username - Username for which credentials should be retrieved
    
    Throws:
    
    java.sql.SQLException - if a database error occurs
  - getName
```
protected java.lang.String getName()
```
    Return a short name for this Realm implementation.
    
    Specified by:
    
    getName in class RealmBase
  - getPassword
```
protected java.lang.String getPassword(java.lang.String username)
```
    Return the password associated with the given principal's user name.
    
    Specified by:
    
    getPassword in class RealmBase
  - getPrincipal
```
protected java.security.Principal getPrincipal(java.lang.String username)
```
    Return the Principal associated with the given user name.
    
    Specified by:
    
    getPrincipal in class RealmBase
  - getRoles
```
protected java.util.ArrayList<java.lang.String> getRoles(java.lang.String username)
```
    Return the roles associated with the gven user name.
  - open
```
protected java.sql.Connection open()
                            throws java.sql.SQLException
```
    Open (if necessary) and return a database connection for use by this Realm.
    
    Throws:
    
    java.sql.SQLException - if a database error occurs
  - release
```
@Deprecated
protected void release(java.sql.Connection dbConnection)
```
    Deprecated. Unused
    
    Release our use of this connection so that it can be recycled.
    
    Parameters:
    dbConnection - The connection to be released
  - roles
```
protected java.sql.PreparedStatement roles(java.sql.Connection dbConnection,
                               java.lang.String username)
                                    throws java.sql.SQLException
```
    Return a PreparedStatement configured to perform the SELECT required to retrieve user roles for the specified username.
    
    Parameters:
    dbConnection - The database connection to be used
    username - Username for which roles should be retrieved
    
    Throws:
    
    java.sql.SQLException - if a database error occurs
  - startInternal
```
protected void startInternal()
                      throws LifecycleException
```
    Prepare for the beginning of active use of the public methods of this component and implement the requirements of LifecycleBase.startInternal().
    
    Overrides:
    
    startInternal in class RealmBase
    
    Throws:
    
    LifecycleException - if this component detects a fatal error that prevents this component from being used
  - stopInternal
```
protected void stopInternal()
                     throws LifecycleException
```
    Gracefully terminate the active use of the public methods of this component and implement the requirements of LifecycleBase.stopInternal().
    
    Overrides:
    
    stopInternal in class RealmBase
    
    Throws:
    
    LifecycleException - if this component detects a fatal error that needs to be reported

Class JDBCRealm

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.catalina.realm.RealmBase

Field Summary

Fields inherited from class org.apache.catalina.realm.RealmBase

Fields inherited from class org.apache.catalina.util.LifecycleMBeanBase

Fields inherited from interface org.apache.catalina.Lifecycle

Constructor Summary

Method Summary

Methods inherited from class org.apache.catalina.realm.RealmBase

Methods inherited from class org.apache.catalina.util.LifecycleMBeanBase

Methods inherited from class org.apache.catalina.util.LifecycleBase

Methods inherited from class java.lang.Object

Field Detail

connectionName

connectionPassword

connectionURL

dbConnection

driver

driverName

info

name

preparedCredentials

preparedRoles

roleNameCol

userCredCol

userNameCol

userRoleTable

userTable

Constructor Detail

JDBCRealm

Method Detail

getConnectionName

setConnectionName

getConnectionPassword

setConnectionPassword

getConnectionURL

setConnectionURL

getDriverName

setDriverName

getRoleNameCol

setRoleNameCol

getUserCredCol

setUserCredCol

getUserNameCol

setUserNameCol

getUserRoleTable

setUserRoleTable

getUserTable

setUserTable

getInfo

authenticate

authenticate

close

credentials

getName

getPassword

getPrincipal

getRoles

open

release

roles

startInternal

stopInternal