JDBCRatingDAOBuilder (LensKit 2.2.1)

java.lang.Object
- org.grouplens.lenskit.data.sql.JDBCRatingDAOBuilder

```
public class JDBCRatingDAOBuilder
extends Object
```
Construct and configure a JDBC rating DAO. Get a builder with JDBCRatingDAO.newBuilder().

Since:

2.1

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`JDBCRatingDAO`	`build(Connection con)` Create a DAO backed by a database connection.
`String`	`getItemColumn()`
`String`	`getRatingColumn()`
`SQLStatementFactory`	`getStatementFactory()` Get the statement factory the DAO will use.
`String`	`getTableName()`
`String`	`getTimestampColumn()`
`String`	`getUserColumn()`
`boolean`	`isCloseWhenClosed()`
`JDBCRatingDAOBuilder`	`setCache(Cache<QueryKey,Object> cache)` Set the cache to use for user and item queries.
`JDBCRatingDAOBuilder`	`setCacheBuilder(CacheBuilder<? super QueryKey,Object> cb)` Set a cache builder to use for making the DAO's internal caches.
`JDBCRatingDAOBuilder`	`setCacheBuilder(CacheBuilderSpec spec)` Set a cache builder spec to use for making the DAO's internal caches.
`JDBCRatingDAOBuilder`	`setCacheBuilder(String spec)` Set the cache builder spec to use for making the DAO's internal caches.
`JDBCRatingDAOBuilder`	`setCloseWhenClosed(boolean close)` Configure whether the the DAO should close the database connection.
`JDBCRatingDAOBuilder`	`setItemColumn(String col)`
`JDBCRatingDAOBuilder`	`setRatingColumn(String col)`
`JDBCRatingDAOBuilder`	`setStatementFactory(SQLStatementFactory fac)` Set the statement factory to be used by the DAO.
`JDBCRatingDAOBuilder`	`setTableName(String table)`
`JDBCRatingDAOBuilder`	`setTimestampColumn(String col)`
`JDBCRatingDAOBuilder`	`setUserColumn(String col)`

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

- Method Detail
  - getTableName
```
public String getTableName()
```
  - setTableName
```
public JDBCRatingDAOBuilder setTableName(String table)
```
  - getUserColumn
```
public String getUserColumn()
```
  - setUserColumn
```
public JDBCRatingDAOBuilder setUserColumn(@Nonnull
                                          String col)
```
  - getItemColumn
```
public String getItemColumn()
```
  - setItemColumn
```
public JDBCRatingDAOBuilder setItemColumn(@Nonnull
                                          String col)
```
  - getRatingColumn
```
public String getRatingColumn()
```
  - setRatingColumn
```
public JDBCRatingDAOBuilder setRatingColumn(@Nonnull
                                            String col)
```
  - getTimestampColumn
```
public String getTimestampColumn()
```
  - setTimestampColumn
```
public JDBCRatingDAOBuilder setTimestampColumn(@Nullable
                                               String col)
```
  - isCloseWhenClosed
```
public boolean isCloseWhenClosed()
```
  - setCloseWhenClosed
```
public JDBCRatingDAOBuilder setCloseWhenClosed(boolean close)
```
    Configure whether the the DAO should close the database connection.
    
    Parameters:
    
    close - true to close the database connection with the DAO, false to leave it open.
    
    Returns:
    
    The builder (for chaining).
  - setStatementFactory
```
public JDBCRatingDAOBuilder setStatementFactory(SQLStatementFactory fac)
```
    Set the statement factory to be used by the DAO.
    
    Parameters:
    
    fac - The statement factory.
    
    Returns:
    
    The builder (for chaining).
  - getStatementFactory
```
public SQLStatementFactory getStatementFactory()
```
    Get the statement factory the DAO will use.
    
    Returns:
    
    The statement factory the DAO will use.
  - setCacheBuilder
```
public JDBCRatingDAOBuilder setCacheBuilder(CacheBuilder<? super QueryKey,Object> cb)
```
    Set a cache builder to use for making the DAO's internal caches. The default builder uses soft value, a maximum size of 1000, and a timeout of 5 minutes after load.
    
    Parameters:
    
    cb - The cache builder.
    
    Returns:
    
    The builder (for chaining).
  - setCacheBuilder
```
public JDBCRatingDAOBuilder setCacheBuilder(CacheBuilderSpec spec)
```
    Set a cache builder spec to use for making the DAO's internal caches.
    
    Parameters:
    
    spec - A cache builder spec.
    
    Returns:
    
    The builder (for chaining).
  - setCacheBuilder
```
public JDBCRatingDAOBuilder setCacheBuilder(String spec)
```
    Set the cache builder spec to use for making the DAO's internal caches.
    
    Parameters:
    
    spec - A cache builder spec.
    
    Returns:
    
    The builder (for chaining).
  - setCache
```
public JDBCRatingDAOBuilder setCache(Cache<QueryKey,Object> cache)
```
    Set the cache to use for user and item queries. Multiple instances can use the same cache safely. This overides setCacheBuilder(com.google.common.cache.CacheBuilder).
    
    Parameters:
    
    cache - The cache to use.
    
    Returns:
    
    The builder (for chaining).
  - build
```
public JDBCRatingDAO build(Connection con)
```
    Create a DAO backed by a database connection.
    
    Parameters:
    
    con - The database connection.
    
    Returns:
    
    A DAO backed by con.

Class JDBCRatingDAOBuilder

Method Summary

Methods inherited from class java.lang.Object

Method Detail

getTableName

setTableName

getUserColumn

setUserColumn

getItemColumn

setItemColumn

getRatingColumn

setRatingColumn

getTimestampColumn

setTimestampColumn

isCloseWhenClosed

setCloseWhenClosed

setStatementFactory

getStatementFactory

setCacheBuilder

setCacheBuilder

setCacheBuilder

setCache

build