java.lang.Object

org.eclipse.net4j.spi.db.DBAdapter

org.eclipse.net4j.db.postgresql.PostgreSQLAdapter

All Implemented Interfaces:: IDBAdapter, IDBAdapterID

public class PostgreSQLAdapter extends DBAdapter

A DB adapter for PostgreSQL databases.

Author:: Victor Roldan Betancort

Nested Class Summary

Nested classes/interfaces inherited from class org.eclipse.net4j.spi.db.DBAdapter
DBAdapter.FieldInfo, DBAdapter.IndexInfo

Nested classes/interfaces inherited from interface org.eclipse.net4j.db.IDBAdapter
IDBAdapter.Registry
Field Summary

Fields

Modifier and Type

Field

Description

static final String

NAME

static final String

VERSION

Fields inherited from interface org.eclipse.net4j.db.IDBAdapter
REGISTRY
Constructor Summary

Constructors

Modifier

Constructor

Description

PostgreSQLAdapter()

protected

PostgreSQLAdapter(String name, String version)
Method Summary

Modifier and Type

Method

Description

protected void

doCreateTable(IDBTable table, Statement statement)

protected void

forEachTable(Connection connection, String schemaName, boolean caseSensitive, org.eclipse.net4j.util.ConsumerWithException<String,SQLException> tableNameConsumer)

Enumerates the tables that belong to a schema while reading a database schema.

String

getDefaultSchemaName(Connection connection)

int

getJDBCTypeForNull(DBType type)

Returns the JDBC type to use when binding a null value for the given database type.

int

getMaxFieldNameLength()

int

getMaxTableNameLength()

String[]

getReservedWords()

protected String

getTypeName(IDBField field)

boolean

isCaseSensitive()

boolean

isColumnNotFoundException(SQLException ex)

See Appendix A.

boolean

isDuplicateKeyException(SQLException ex)

See Appendix A.

boolean

isDuplicateKeyTransactionAbort()

PostgreSQL marks the current transaction as aborted after a duplicate-key violation.

boolean

isTableNotFoundException(SQLException ex)

See Appendix A.

protected void

readIndices(Connection connection, DatabaseMetaData metaData, IDBTable table, String schemaName)

String

sqlCharIndex(Object substring, Object string)

Methods inherited from class org.eclipse.net4j.spi.db.DBAdapter
adaptType, addIndex, addIndexField, alterTable, appendFieldDefs, appendFieldNames, convertString, convertString, convertString, convertToSQL, createConnectionProvider, createConstraints, createField, createField, createFieldDefinition, createFieldDefinitions, createIndex, createIndex, createIndex, createIndexFields, createJDBCDataSource, createPrimaryKey, createSchema, createTable, createTable, createTables, dropField, dropField, dropIndex, dropIndex, dropPrimaryKey, dropTable, dropTable, dropTables, equals, format, format, generateReservedWords, getDefaultDBLength, getDropTableSQL, getFieldLength, getIndexInfos, getJDBCDriver, getName, getNullableConstraint, getSQL92ReservedWords, getVersion, hashCode, isPrimaryKeyShadow, isReservedWord, isTypeIndexable, isValidFirstChar, modifyConnection, openSchemaTransaction, readFields, readIndices, readSchema, readSchema, readTables, sqlCharIndexFunction, sqlConcat, sqlModifyField, sqlModifyField, sqlRenameField, sqlSubstring, sqlSubstring, sqlSubstringFunction, toString, updateSchema, validateTable

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

Field Details
- NAME
  
  public static final String NAME
  See Also:
  
  Constant Field Values
- VERSION
  
  public static final String VERSION
  See Also:
  
  Constant Field Values
Constructor Details
- PostgreSQLAdapter
  
  public PostgreSQLAdapter()
- PostgreSQLAdapter
  
  protected PostgreSQLAdapter(String name, String version)
  
  Since:
  
  4.4
Method Details
- isCaseSensitive
  
  public boolean isCaseSensitive()
  
  Specified by:
  
  isCaseSensitive in interface IDBAdapter
  
  Overrides:
  
  isCaseSensitive in class DBAdapter
- forEachTable
  
  protected void forEachTable(Connection connection, String schemaName, boolean caseSensitive, org.eclipse.net4j.util.ConsumerWithException<String,SQLException> tableNameConsumer)
  
  Description copied from class: DBAdapter
  
  Enumerates the tables that belong to a schema while reading a database schema.
  
  Overrides:
  
  forEachTable in class DBAdapter
- readIndices
  
  protected void readIndices(Connection connection, DatabaseMetaData metaData, IDBTable table, String schemaName) throws SQLException
  
  Overrides:
  
  readIndices in class DBAdapter
  
  Throws:
  
  SQLException
- getDefaultSchemaName
  
  public String getDefaultSchemaName(Connection connection)
  
  Specified by:
  
  getDefaultSchemaName in interface IDBAdapter
  
  Overrides:
  
  getDefaultSchemaName in class DBAdapter
- getMaxTableNameLength
  
  public int getMaxTableNameLength()
  
  Specified by:
  
  getMaxTableNameLength in interface IDBAdapter
  
  Overrides:
  
  getMaxTableNameLength in class DBAdapter
  
  Since:
  
  2.0
- getMaxFieldNameLength
  
  public int getMaxFieldNameLength()
  
  Specified by:
  
  getMaxFieldNameLength in interface IDBAdapter
  
  Overrides:
  
  getMaxFieldNameLength in class DBAdapter
  
  Since:
  
  2.0
- getJDBCTypeForNull
  
  public int getJDBCTypeForNull(DBType type)
  
  Description copied from interface: IDBAdapter
  
  Returns the JDBC type to use when binding a null value for the given database type.
  
  Specified by:
  
  getJDBCTypeForNull in interface IDBAdapter
  
  Overrides:
  
  getJDBCTypeForNull in class DBAdapter
- getTypeName
  
  protected String getTypeName(IDBField field)
  
  Overrides:
  
  getTypeName in class DBAdapter
- getReservedWords
  
  public String[] getReservedWords()
- isDuplicateKeyTransactionAbort
  
  public boolean isDuplicateKeyTransactionAbort()
  
  PostgreSQL marks the current transaction as aborted after a duplicate-key violation. A savepoint is therefore required when the violation is an expected outcome.
  
  Specified by:
  
  isDuplicateKeyTransactionAbort in interface IDBAdapter
  
  Overrides:
  
  isDuplicateKeyTransactionAbort in class DBAdapter
- isDuplicateKeyException
  
  public boolean isDuplicateKeyException(SQLException ex)
  
  See Appendix A. PostgreSQL Error Codes.
  
  Specified by:
  
  isDuplicateKeyException in interface IDBAdapter
  
  Overrides:
  
  isDuplicateKeyException in class DBAdapter
- isTableNotFoundException
  
  public boolean isTableNotFoundException(SQLException ex)
  
  See Appendix A. PostgreSQL Error Codes.
  
  Specified by:
  
  isTableNotFoundException in interface IDBAdapter
  
  Overrides:
  
  isTableNotFoundException in class DBAdapter
- isColumnNotFoundException
  
  public boolean isColumnNotFoundException(SQLException ex)
  
  See Appendix A. PostgreSQL Error Codes.
  
  Specified by:
  
  isColumnNotFoundException in interface IDBAdapter
  
  Overrides:
  
  isColumnNotFoundException in class DBAdapter
- doCreateTable
  
  protected void doCreateTable(IDBTable table, Statement statement) throws SQLException
  
  Overrides:
  
  doCreateTable in class DBAdapter
  
  Throws:
  
  SQLException
  
  Since:
  
  4.1
- sqlCharIndex
  
  public String sqlCharIndex(Object substring, Object string)
  
  Specified by:
  
  sqlCharIndex in interface IDBAdapter
  
  Overrides:
  
  sqlCharIndex in class DBAdapter

Class PostgreSQLAdapter

Nested Class Summary

Nested classes/interfaces inherited from class org.eclipse.net4j.spi.db.DBAdapter

Nested classes/interfaces inherited from interface org.eclipse.net4j.db.IDBAdapter

Field Summary

Fields inherited from interface org.eclipse.net4j.db.IDBAdapter

Constructor Summary

Method Summary

Methods inherited from class org.eclipse.net4j.spi.db.DBAdapter

Methods inherited from class java.lang.Object

Field Details

NAME

VERSION

Constructor Details

PostgreSQLAdapter

PostgreSQLAdapter

Method Details

isCaseSensitive

forEachTable

readIndices

getDefaultSchemaName

getMaxTableNameLength

getMaxFieldNameLength

getJDBCTypeForNull

getTypeName

getReservedWords

isDuplicateKeyTransactionAbort

isDuplicateKeyException

isTableNotFoundException

isColumnNotFoundException

doCreateTable

sqlCharIndex