org.jminor.common.db.dbms
Class SQLServerDatabase
java.lang.Object
org.jminor.common.db.AbstractDatabase
org.jminor.common.db.dbms.SQLServerDatabase
- All Implemented Interfaces:
- Database
public final class SQLServerDatabase
- extends AbstractDatabase
A Database implementation based on the SQL Server (2000 or higher) database.
Fields inherited from interface org.jminor.common.db.Database |
DATABASE_EMBEDDED, DATABASE_HOST, DATABASE_IMPLEMENTATION_CLASS, DATABASE_POOL_STATISTICS, DATABASE_PORT, DATABASE_SID, DATABASE_TYPE, DEFAULT_LOGIN_TIMEOUT, DERBY, H2, HSQL, MYSQL, ORACLE, PASSWORD_PROPERTY, POSTGRESQL, SQLSERVER, USER_PROPERTY |
Methods inherited from class org.jminor.common.db.AbstractDatabase |
addConnectionProperties, createConnection, getAuthenticationInfo, getCheckConnectionQuery, getDatabaseType, getErrorMessage, getHost, getLoginTimeout, getPort, getSequenceSQL, getSid, isEmbedded, shutdownEmbedded, supportsIsValid, supportsNowait |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
SQLServerDatabase
public SQLServerDatabase()
- Instantiates a new SQLServerDatabase.
SQLServerDatabase
public SQLServerDatabase(String host,
String port,
String databaseName)
- Instantiates a new SQLServerDatabase.
- Parameters:
host
- the host nameport
- the port numberdatabaseName
- the database name
loadDriver
public void loadDriver()
throws ClassNotFoundException
- Loads the database driver
- Throws:
ClassNotFoundException
- in case the driver class in not found
getAutoIncrementValueSQL
public String getAutoIncrementValueSQL(String idSource)
- Returns a query string for retrieving the last automatically generated id from the given id source
- Parameters:
idSource
- the source for the id, for example a sequence name or in the case of Derby, the name of the table
- Returns:
- a query string for retrieving the last auto-increment value from idSource
getURL
public String getURL(Properties connectionProperties)
-
- Parameters:
connectionProperties
- the connection properties, used primarily to provide
embedded databases with user info for authentication purposes
- Returns:
- the database url of the active database, based on system properties