PostgreSQLNameIndex (Apache Jackrabbit 2.23.1-beta API)

java.lang.Object
- org.apache.jackrabbit.core.persistence.pool.DbNameIndex
- - org.apache.jackrabbit.core.persistence.pool.PostgreSQLNameIndex

All Implemented Interfaces:

StringIndex
```
public class PostgreSQLNameIndex
extends DbNameIndex
```
Same as DbNameIndex but does not make use of the Statement.RETURN_GENERATED_KEYS feature as it is not provided by the underlying database driver for PostgreSQL.

Field Summary

Fields
Modifier and Type Field Description

protected String generatedKeySelectSQL
- Fields inherited from class org.apache.jackrabbit.core.persistence.pool.DbNameIndex
  conHelper, indexSelectSQL, nameInsertSQL, nameSelectSQL

Constructor Summary

Constructors
Constructor Description

PostgreSQLNameIndex(ConnectionHelper connectionHelper, String schemaObjectPrefix)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected int`	`getGeneratedKey()`	Retrieves the last assigned key from the database.
`protected void`	`init(String schemaObjectPrefix)`	Inits this index and prepares the statements.
`protected int`	`insertString(String string)`	Inserts a string into the database and returns the new index.

Methods inherited from class org.apache.jackrabbit.core.persistence.pool.DbNameIndex
close, getIndex, getString, indexToString, stringToIndex

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

- Field Detail
  - generatedKeySelectSQL
```
protected String generatedKeySelectSQL
```
- Constructor Detail
  - PostgreSQLNameIndex
```
public PostgreSQLNameIndex(ConnectionHelper connectionHelper,
                           String schemaObjectPrefix)
                    throws SQLException
```
    Throws:
    
    SQLException
- Method Detail
  - init
```
protected void init(String schemaObjectPrefix)
             throws SQLException
```
    Inits this index and prepares the statements.
    
    Overrides:
    
    init in class DbNameIndex
    
    Parameters:
    
    schemaObjectPrefix - the prefix for table names
    
    Throws:
    
    SQLException - if the statements cannot be prepared.
  - insertString
```
protected int insertString(String string)
```
    Inserts a string into the database and returns the new index.
    Instead of using the Statement.RETURN_GENERATED_KEYS feature, the newly inserted index is retrieved by a 2nd select statement.
    
    Overrides:
    
    insertString in class DbNameIndex
    
    Parameters:
    
    string - the string to insert
    
    Returns:
    
    the new index.
  - getGeneratedKey
```
protected int getGeneratedKey()
```
    Retrieves the last assigned key from the database.
    
    Returns:
    
    the index.