public class CdmDataSource extends CdmSource
DEFAULT_ENTRY, NULL_PORT, server
Modifier | Constructor and Description |
---|---|
protected |
CdmDataSource(DatabaseTypeEnum dbType,
java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password,
java.lang.String filePath,
H2Mode mode) |
Modifier and Type | Method and Description |
---|---|
boolean |
checkConnection()
Tests, if a database connection can be established.
|
void |
closeOpenConnections()
Closes any open connections to this CDM Source
|
void |
commitTransaction()
Commits the transaction for the given datasource.
|
java.sql.ResultSet |
executeQuery(java.lang.String query)
Executes a query and returns the ResultSet.
|
int |
executeUpdate(java.lang.String sqlUpdate)
Executes an update
|
java.sql.Connection |
getConnection() |
java.sql.Connection |
getConnection(java.lang.String username,
java.lang.String password) |
java.lang.String |
getConnectionMessage()
Returns the message to display when connecting to this CDM Source
|
java.lang.String |
getDatabase() |
DatabaseTypeEnum |
getDatabaseType()
Returns the database type of the data source.
|
org.springframework.beans.factory.config.BeanDefinition |
getDatasourceBean()
Returns a BeanDefinition object of type DataSource that contains
datsource properties (url, username, password, ...)
|
java.lang.String |
getDbSchemaVersion()
Returns the CDM schema version of this CDM Source
|
java.lang.String |
getDestroyMethodName() |
java.lang.String |
getFilePath() |
org.springframework.beans.factory.config.BeanDefinition |
getHibernatePropertiesBean(DbSchemaValidation hbm2dll) |
org.springframework.beans.factory.config.BeanDefinition |
getHibernatePropertiesBean(DbSchemaValidation hbm2dll,
java.lang.Boolean showSql,
java.lang.Boolean formatSql,
java.lang.Boolean registerSearchListener,
java.lang.Class<? extends org.hibernate.cache.spi.RegionFactory> cacheProviderClass)
Deprecated.
|
org.springframework.beans.factory.config.BeanDefinition |
getHibernatePropertiesBean(DbSchemaValidation hbm2dll,
HibernateConfiguration hibernateConfig) |
java.lang.String |
getInitMethodName() |
int |
getLoginTimeout() |
java.io.PrintWriter |
getLogWriter() |
java.sql.DatabaseMetaData |
getMetaData()
Returns
DatabaseMetaData for this datasource. |
java.util.Map<CdmMetaDataPropertyName,java.lang.String> |
getMetaDataMap() |
H2Mode |
getMode() |
java.lang.String |
getName()
Returns the name representation of this CDM Source
|
java.util.logging.Logger |
getParentLogger() |
java.lang.String |
getPassword() |
int |
getPort()
Returns the port on which this CDM Source is listening
|
java.lang.String |
getServer()
Returns the server (string representation) where this CDM Source resides
|
java.lang.Object |
getSingleValue(java.lang.String query)
Returns the first value of the first row of a result set.
If no row exists in the result set null is returned. |
java.lang.String |
getUsername() |
boolean |
isDbEmpty()
Checks whether the underlying database is empty
|
boolean |
isWrapperFor(java.lang.Class<?> iface) |
protected org.springframework.beans.factory.support.AbstractBeanDefinition |
makeHibernatePropertiesBean(DatabaseTypeEnum dbType,
DbSchemaValidation hbm2dll,
boolean showSql,
boolean formatSql,
boolean registerAuditing,
boolean registerSearchListener,
java.lang.Class<? extends org.hibernate.cache.spi.RegionFactory> cacheProviderClass) |
static CdmDataSource |
NewH2EmbeddedInstance(java.lang.String database,
java.lang.String username,
java.lang.String password)
in work
|
static CdmDataSource |
NewH2EmbeddedInstance(java.lang.String database,
java.lang.String username,
java.lang.String password,
java.lang.String filePath)
in work
|
static CdmDataSource |
NewH2InMemoryInstance()
in work
|
static CdmDataSource |
NewInstance(DatabaseTypeEnum dbType,
java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewInstance(DatabaseTypeEnum dbType,
java.lang.String server,
java.lang.String database,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewInstance(ICdmDataSource dataSource) |
static CdmDataSource |
NewMySqlInstance(java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewMySqlInstance(java.lang.String server,
java.lang.String database,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewPostgreSQLInstance(java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewSqlServer2005Instance(java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewSqlServer2008Instance(java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password) |
static CdmDataSource |
NewSqlServer2012Instance(java.lang.String server,
java.lang.String database,
int port,
java.lang.String username,
java.lang.String password) |
void |
rollback()
Rolls the connection back.
|
void |
setDatabase(java.lang.String database) |
void |
setDestroyMethodName(java.lang.String destroyMethodName) |
void |
setInitMethodName(java.lang.String initMethodName) |
void |
setLoginTimeout(int seconds) |
void |
setLogWriter(java.io.PrintWriter out) |
void |
setMode(H2Mode h2Mode) |
void |
setPassword(java.lang.String password) |
void |
setUsername(java.lang.String username) |
void |
startTransaction()
Starts a transaction for the given datasource.
|
boolean |
testConnection()
Tests, if a database connection can be established.
|
java.lang.String |
toString() |
<T> T |
unwrap(java.lang.Class<T> iface) |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
setName, setPort, setServer
protected CdmDataSource(DatabaseTypeEnum dbType, java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password, java.lang.String filePath, H2Mode mode)
server
- database
- port
- public static CdmDataSource NewInstance(DatabaseTypeEnum dbType, java.lang.String server, java.lang.String database, java.lang.String username, java.lang.String password)
public static CdmDataSource NewInstance(DatabaseTypeEnum dbType, java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password)
public static CdmDataSource NewMySqlInstance(java.lang.String server, java.lang.String database, java.lang.String username, java.lang.String password)
public static CdmDataSource NewMySqlInstance(java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password)
public static CdmDataSource NewPostgreSQLInstance(java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password)
public static CdmDataSource NewSqlServer2005Instance(java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password)
public static CdmDataSource NewSqlServer2008Instance(java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password)
public static CdmDataSource NewSqlServer2012Instance(java.lang.String server, java.lang.String database, int port, java.lang.String username, java.lang.String password)
public static CdmDataSource NewH2EmbeddedInstance(java.lang.String database, java.lang.String username, java.lang.String password)
code
- TODOpublic static CdmDataSource NewH2EmbeddedInstance(java.lang.String database, java.lang.String username, java.lang.String password, java.lang.String filePath)
code
- TODOpublic static CdmDataSource NewH2InMemoryInstance()
public static CdmDataSource NewInstance(ICdmDataSource dataSource)
public java.lang.String getName()
ICdmSource
getName
in interface ICdmSource
getName
in class CdmSource
public java.lang.String getServer()
ICdmSource
getServer
in interface ICdmSource
getServer
in class CdmSource
public int getPort()
ICdmSource
getPort
in interface ICdmSource
getPort
in class CdmSource
public org.springframework.beans.factory.config.BeanDefinition getDatasourceBean()
ICdmDataSource
public org.springframework.beans.factory.config.BeanDefinition getHibernatePropertiesBean(DbSchemaValidation hbm2dll)
@Deprecated public org.springframework.beans.factory.config.BeanDefinition getHibernatePropertiesBean(DbSchemaValidation hbm2dll, java.lang.Boolean showSql, java.lang.Boolean formatSql, java.lang.Boolean registerSearchListener, java.lang.Class<? extends org.hibernate.cache.spi.RegionFactory> cacheProviderClass)
public org.springframework.beans.factory.config.BeanDefinition getHibernatePropertiesBean(DbSchemaValidation hbm2dll, HibernateConfiguration hibernateConfig)
hbm2dll
- schema validationhibernateConfig
- the hibernate configurationbean definition
public java.lang.String getInitMethodName()
public void setInitMethodName(java.lang.String initMethodName)
public java.lang.String getDestroyMethodName()
public void setDestroyMethodName(java.lang.String destroyMethodName)
public java.lang.String getDatabase()
public void setDatabase(java.lang.String database)
public DatabaseTypeEnum getDatabaseType()
ICdmDataSource
null
if the bean or the driver class property does not exist or the driver class is unknown.public java.lang.String getFilePath()
public H2Mode getMode()
public void setMode(H2Mode h2Mode)
public java.lang.String getPassword()
public void setPassword(java.lang.String password)
public java.lang.String getUsername()
public void setUsername(java.lang.String username)
public java.sql.Connection getConnection() throws java.sql.SQLException
getConnection
in interface javax.sql.DataSource
java.sql.SQLException
public java.sql.Connection getConnection(java.lang.String username, java.lang.String password) throws java.sql.SQLException
getConnection
in interface javax.sql.DataSource
java.sql.SQLException
public boolean testConnection() throws java.lang.ClassNotFoundException, java.sql.SQLException
ICdmDataSource
testConnection
in interface ICdmDataSource
java.lang.ClassNotFoundException
java.sql.SQLException
public boolean checkConnection() throws CdmSourceException
ICdmSource
checkConnection
in interface ICdmSource
checkConnection
in class CdmSource
CdmSourceException
- if any underlying errorpublic java.lang.String getConnectionMessage()
ICdmSource
getConnectionMessage
in interface ICdmSource
getConnectionMessage
in class CdmSource
public java.lang.Object getSingleValue(java.lang.String query) throws java.sql.SQLException
ICdmDataSource
null
is returned.
Caution This method opens a connection on first use. Subsequent calls will use the same connection.
Please close the connection when not needed anymore with ICdmSource.closeOpenConnections()
getSingleValue
in interface ICdmDataSource
java.sql.SQLException
public java.lang.String getDbSchemaVersion() throws CdmSourceException
ICdmSource
getDbSchemaVersion
in interface ICdmSource
getDbSchemaVersion
in class CdmSource
CdmSourceException
- if any underlying errorpublic boolean isDbEmpty() throws CdmSourceException
ICdmSource
isDbEmpty
in interface ICdmSource
isDbEmpty
in class CdmSource
CdmSourceException
public java.sql.ResultSet executeQuery(java.lang.String query) throws java.sql.SQLException
executeQuery
in interface ICdmDataSource
java.sql.SQLException
public int executeUpdate(java.lang.String sqlUpdate) throws java.sql.SQLException
ICdmDataSource
executeUpdate
in interface ICdmDataSource
java.sql.SQLException
public void startTransaction()
ICdmDataSource
startTransaction
in interface ICdmDataSource
public void commitTransaction() throws java.sql.SQLException
ICdmDataSource
commitTransaction
in interface ICdmDataSource
java.sql.SQLException
public void rollback() throws java.sql.SQLException
ICdmDataSource
rollback
in interface ICdmDataSource
java.sql.SQLException
public java.sql.DatabaseMetaData getMetaData()
ICdmDataSource
DatabaseMetaData
for this
datasource.
ICdmSource.closeOpenConnections()
getMetaData
in interface ICdmDataSource
public void closeOpenConnections()
ICdmSource
closeOpenConnections
in interface ICdmSource
closeOpenConnections
in class CdmSource
public java.util.Map<CdmMetaDataPropertyName,java.lang.String> getMetaDataMap() throws CdmSourceException
getMetaDataMap
in interface ICdmSource
CdmSourceException
public java.io.PrintWriter getLogWriter() throws java.sql.SQLException
getLogWriter
in interface javax.sql.CommonDataSource
java.sql.SQLException
public void setLogWriter(java.io.PrintWriter out) throws java.sql.SQLException
setLogWriter
in interface javax.sql.CommonDataSource
java.sql.SQLException
public void setLoginTimeout(int seconds) throws java.sql.SQLException
setLoginTimeout
in interface javax.sql.CommonDataSource
java.sql.SQLException
public int getLoginTimeout() throws java.sql.SQLException
getLoginTimeout
in interface javax.sql.CommonDataSource
java.sql.SQLException
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
java.sql.SQLException
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
java.sql.SQLException
public java.util.logging.Logger getParentLogger()
getParentLogger
in interface javax.sql.CommonDataSource
protected org.springframework.beans.factory.support.AbstractBeanDefinition makeHibernatePropertiesBean(DatabaseTypeEnum dbType, DbSchemaValidation hbm2dll, boolean showSql, boolean formatSql, boolean registerAuditing, boolean registerSearchListener, java.lang.Class<? extends org.hibernate.cache.spi.RegionFactory> cacheProviderClass)
hbm2dll
- showSql
- formatSql
- registerAuditing
- registerSearchListener
- cacheProviderClass
- Copyright © 2007-2020 EDIT. All Rights Reserved.