public abstract class AbstractPostgresDatasource extends AbstractHibernateFullDBDatasource
HibernateDatasourceConstants.DatabaseConcept
Modifier and Type | Field and Description |
---|---|
protected static String |
FUNC_POSTGIS_VERSION |
protected static String |
HOST_DESCRIPTION |
protected static Pattern |
JDBC_URL_PATTERN |
protected static String |
PASSWORD_DEFAULT_VALUE |
protected static String |
PASSWORD_DESCRIPTION |
protected static int |
PORT_DEFAULT_VALUE |
protected static String |
PORT_DESCRIPTION |
protected static String |
POSTGRES_DRIVER_CLASS |
protected static String |
SCHEMA_DEFAULT_VALUE |
protected static String |
TAB_SPATIAL_REF_SYS |
protected static String |
USERNAME_DEFAULT_VALUE |
protected static String |
USERNAME_DESCRIPTION |
BATCH_SIZE_DEFAULT_VALUE, BATCH_SIZE_DESCRIPTION, BATCH_SIZE_KEY, BATCH_SIZE_TITLE, DATABASE_CONCEPT_DEFAULT_VALUE, DATABASE_CONCEPT_DESCRIPTION, DATABASE_CONCEPT_KEY, DATABASE_CONCEPT_TITLE, MULTILINGUALISM_DEFAULT_VALUE, MULTILINGUALISM_DESCRIPTION, MULTILINGUALISM_KEY, MULTILINGUALISM_TITLE, PROVIDED_JDBC_DRIVER_DEFAULT_VALUE, PROVIDED_JDBC_DRIVER_DESCRIPTION, PROVIDED_JDBC_DRIVER_KEY, PROVIDED_JDBC_DRIVER_TITLE, SCHEMA_DESCRIPTION, SCHEMA_KEY, SCHEMA_TITLE, SCHMEA_DEFAULT_VALUE, TRANSACTIONAL_DEFAULT_VALUE, TRANSACTIONAL_DESCRIPTION, TRANSACTIONAL_KEY, TRANSACTIONAL_TITLE, USERNAME_KEY
C3P0_CONNECTION_POOL, DATABASE_DEFAULT_VALUE, DATABASE_DESCRIPTION, DATABASE_KEY, DATABASE_TITLE, HOST_DEFAULT_VALUE, HOST_KEY, HOST_TITLE, MAX_POOL_SIZE_DEFAULT_VALUE, MAX_POOL_SIZE_DESCRIPTION, MAX_POOL_SIZE_KEY, MAX_POOL_SIZE_TITLE, MIN_POOL_SIZE_DEFAULT_VALUE, MIN_POOL_SIZE_DESCRIPTION, MIN_POOL_SIZE_KEY, MIN_POOL_SIZE_TITLE, PASSWORD_KEY, PASSWORD_TITLE, PORT_KEY, PORT_TITLE, USERNAME_TITLE
DEFAULT_COUNT, FROM, SELECT
AMPERSAND_CHAR, AMPERSAND_STRING, BACKSLASH_CHAR, BACKSLASH_STRING, BLANK_CHAR, BLANK_STRING, CLOSE_BRACE_CHAR, CLOSE_BRACE_STRING, COLON_CHAR, COLON_STRING, COMMA_CHAR, COMMA_SPACE_STRING, COMMA_STRING, CSV_BLOCK_SEPARATOR, CSV_TOKEN_SEPARATOR, DASH_CHAR, DASH_STRING, DEFAULT_ENCODING, DOLLAR_CHAR, DOLLAR_STRING, DOT_CHAR, DOT_STRING, DOUBLE_COLON_STRING, EMPTY_STRING, EPSG_WGS84, EPSG_WGS84_3D, EQUAL_SIGN_CHAR, EQUAL_SIGN_STRING, GREATER_THAN_SIGN_STRING, HASH_CODE_13, HASH_CODE_17, HASH_CODE_19, HASH_CODE_23, HASH_CODE_29, HASH_CODE_3, HASH_CODE_31, HASH_CODE_37, HASH_CODE_41, HASH_CODE_43, HASH_CODE_47, HASH_CODE_5, HASH_CODE_7, HTTP, INT_0, INT_1, INT_2, INT_3, INT_4, INVERTED_COMMA_CHAR, INVERTED_COMMA_STRING, LESS_THAN_SIGN_STRING, LINE_SEPARATOR_CHAR, LINE_SEPARATOR_STRING, MINUS_CHAR, MINUS_STRING, NUMBER_SIGN_CHAR, NUMBER_SIGN_STRING, OPEN_BRACE_CHAR, OPEN_BRACE_STRING, PERCENT_CHAR, PERCENT_STRING, PLUS_CHAR, PLUS_STRING, QUERSTIONMARK_CHAR, QUERSTIONMARK_STRING, SEMICOLON_CHAR, SEMICOLON_STRING, SLASH_CHAR, SLASH_STRING, SPACE_CHAR, SPACE_STRING, UNDERSCORE_CHAR, UNDERSCORE_STRING, URN
ADVANCED_GROUP, BASE_GROUP
CONNECTION_PROVIDER_IDENTIFIER
DATASOURCE_DAO_IDENTIFIER, IDEPENDET_IDENTIFIER
HIBERNATE_ANNOTADED_CLASSES, HIBERNATE_DEFAULT_OGM_PACKAGE, HIBERNATE_DIRECTORY, HIBERNATE_DRIVER_CLASS, HIBERNATE_MAPPING_CORE_PATH, HIBERNATE_MAPPING_EREPORTING_CONCEPT_OBSERVATION_PATH, HIBERNATE_MAPPING_EXTENSION, HIBERNATE_MAPPING_EXTENSION_READONLY, HIBERNATE_MAPPING_I18N_PATH, HIBERNATE_MAPPING_OLD_CONCEPT_OBSERVATION_PATH, HIBERNATE_MAPPING_PATH, HIBERNATE_MAPPING_SERIES_CONCEPT_OBSERVATION_PATH, HIBERNATE_MAPPING_SERIES_CONCEPT_PATH, HIBERNATE_MAPPING_TRANSACTIONAL_PATH, HIBERNATE_RESOURCES, HIBERNATPE_MAPPING_OLD_CONCEPT_PATH, OGM_CONNECTION_PROVIDER_IDENTIFIER, OGM_DATASOURCE_DAO_IDENTIFIER, ORM_CONNECTION_PROVIDER_IDENTIFIER, ORM_DATASOURCE_DAO_IDENTIFIER, PATH_SEPERATOR, PROVIDED_JDBC
Constructor and Description |
---|
AbstractPostgresDatasource() |
Modifier and Type | Method and Description |
---|---|
protected String[] |
checkDropSchema(String[] dropSchema)
Check if drop schema contains alter table ... drop constraint ... .
|
protected void |
checkPostgis(Connection con,
Map<String,Object> settings) |
boolean |
checkSchemaCreation(Map<String,Object> settings)
Check if it is possible to create the schema (e.g. test if the privilege
are sufficient).
|
protected void |
checkSpatialRefSys(Connection con,
org.hibernate.tool.hbm2ddl.DatabaseMetadata metadata,
Map<String,Object> settings) |
void |
clear(Properties properties)
Clear the contents of the datasource.
|
protected org.hibernate.dialect.Dialect |
createDialect()
Create a new Hibernate dialect
|
Properties |
getDatasourceProperties(Map<String,Object> settings)
Create the datasource properties used by the
ConnectionProvider
to connect. |
protected String |
getDriverClass()
Gets the qualified name of the driver class.
|
protected Connection |
openConnection(Map<String,Object> settings)
Open a new SQL connection
|
protected String[] |
parseURL(String url)
Parses the given JDBC string searching for host, port and database
|
boolean |
supportsClear() |
protected String |
toURL(Map<String,Object> settings)
Converts the given connection settings into a valid JDBC string.
|
protected void |
validatePrerequisites(Connection con,
org.hibernate.tool.hbm2ddl.DatabaseMetadata metadata,
Map<String,Object> settings)
Check if the required extensions are available
|
createBatchSizeDefinition, createProvidedJdbcDriverDefinition, createSchemaDefinition, getChangableSettingDefinitions, getSettingDefinitions, parseDatasourceProperties, setBatchSizeDefault, setProvidedJdbcDefault, setSchemaDefault, setSchemaDescription
addMappingFileDirectories, checkCreateSchema, checkIfSchemaExists, checkIfSchemaExists, checkPostCreation, checkSchema, checkScriptForGeneratedAndDuplicatedEntries, close, close, createBatchSizeDefinition, createDatabaseConceptDefinition, createMultilingualismDefinition, createProvidedJdbcDriverDefinition, createSchema, createSchemaDefinition, createTransactionalDefinition, createUsernameDefinition, dropSchema, execute, execute, executePostCreateSchema, filter, getCallback, getConfig, getConnectionProviderIdentifier, getDatabaseConceptDefinition, getDatabaseConceptMappingDirectory, getDatabaseMetadata, getDatasourceDaoIdentifier, getDialectInternal, getMulitLanguageDefiniton, getPostSchemaScript, getPreSchemaScript, getSchema, getTransactionalDefiniton, isMultiLanguage, isMultiLanguageDatasource, isPostCreateSchema, isSetSchema, isTransactional, isTransactionalDatasource, needsSchema, prepare, resource, setMultiLangugage, setTransactional, updateSchema, validateConnection, validateConnection, validatePrerequisites, validatePrerequisites, validateSchema, validateSchema
createDatabaseDefinition, createDatabaseDefinition, createHostDefinition, createHostDefinition, createMaxPoolSizeDefinition, createMaxPoolSizeDefinition, createMinPoolSizeDefinition, createMinPoolSizeDefinition, createPasswordDefinition, createPasswordDefinition, createPortDefinition, createPortDefinition, createUsernameDefinition, getDatasourceProperties, mergeProperties, setDatabaseDefault, setDatabaseDescription, setHostDefault, setHostDescription, setMaxPoolSizeDefault, setMinPoolSizeDefault, setPasswordDefault, setPasswordDescription, setPortDefault, setPortDescription, setUsernameDefault, setUsernameDescription
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getDialectName
protected static final String POSTGRES_DRIVER_CLASS
protected static final Pattern JDBC_URL_PATTERN
protected static final String USERNAME_DESCRIPTION
protected static final String USERNAME_DEFAULT_VALUE
protected static final String PASSWORD_DESCRIPTION
protected static final String PASSWORD_DEFAULT_VALUE
protected static final String HOST_DESCRIPTION
protected static final String PORT_DESCRIPTION
protected static final int PORT_DEFAULT_VALUE
protected static final String SCHEMA_DEFAULT_VALUE
protected static final String FUNC_POSTGIS_VERSION
protected static final String TAB_SPATIAL_REF_SYS
protected org.hibernate.dialect.Dialect createDialect()
AbstractHibernateDatasource
createDialect
in class AbstractHibernateDatasource
protected String getDriverClass()
AbstractHibernateDatasource
getDriverClass
in class AbstractHibernateDatasource
public boolean checkSchemaCreation(Map<String,Object> settings)
Datasource
needsSchema()
returns true
.settings
- the settings to connectprotected void validatePrerequisites(Connection con, org.hibernate.tool.hbm2ddl.DatabaseMetadata metadata, Map<String,Object> settings)
AbstractHibernateDatasource
validatePrerequisites
in class AbstractHibernateDatasource
con
- SQL connectionmetadata
- Current database metadatasettings
- Datasource settingsprotected void checkPostgis(Connection con, Map<String,Object> settings)
protected void checkSpatialRefSys(Connection con, org.hibernate.tool.hbm2ddl.DatabaseMetadata metadata, Map<String,Object> settings)
protected String toURL(Map<String,Object> settings)
AbstractHibernateCoreDatasource
toURL
in class AbstractHibernateCoreDatasource
settings
- the connection settings, containing keys from
AbstractHibernateDatasource
(HOST_KEY
,
PORT_KEY
, ...).protected String[] parseURL(String url)
AbstractHibernateCoreDatasource
parseURL
in class AbstractHibernateCoreDatasource
url
- the JDBC string to parsepublic boolean supportsClear()
true
public void clear(Properties properties)
Datasource
supportsClear()
returns true
.properties
- the settings to connectprotected Connection openConnection(Map<String,Object> settings) throws SQLException
AbstractHibernateDatasource
openConnection
in class AbstractHibernateDatasource
settings
- Datasource setting: URL, username, passsword, database, ...SQLException
- If the SQL connection creation failsprotected String[] checkDropSchema(String[] dropSchema)
AbstractHibernateDatasource
checkDropSchema
in class AbstractHibernateDatasource
dropSchema
- Schema to checkpublic Properties getDatasourceProperties(Map<String,Object> settings)
Datasource
ConnectionProvider
to connect.getDatasourceProperties
in interface Datasource
getDatasourceProperties
in class AbstractHibernateFullDBDatasource
settings
- the settings to connectCopyright © 2012-2015 52north.org. All Rights Reserved.