org.opensubsystems.core.persist.db.mssql
Class MSSQLVersionedDatabaseSchema

java.lang.Object
  org.opensubsystems.core.persist.db.DatabaseSchemaImpl
      org.opensubsystems.core.persist.db.VersionedDatabaseSchema
          org.opensubsystems.core.persist.db.mssql.MSSQLVersionedDatabaseSchema

All Implemented Interfaces:

DatabaseOperations, DatabaseSchema

public class MSSQLVersionedDatabaseSchema
extends VersionedDatabaseSchema

MS SQL Server versioned database schema provide functionality of creating and upgrading of MS SQL Server database schemas in the database based on their versions. This class keeps track of existing and current versiones of MS SQL Server database schemas and upgrades them as necesary

Version:

$Id: MSSQLVersionedDatabaseSchema.java,v 1.8 2007/01/07 06:14:54 bastafidli Exp $

Author:

Julo Legeny

Code reviewer:

Miro Halas

Code reviewed:

1.6 2005/10/10 09:00:32 bastafidli

Field Summary

Fields inherited from class org.opensubsystems.core.persist.db.VersionedDatabaseSchema

SCHEMA_TABLE_NAME, VERSIONED_SCHEMA_NAME, VERSIONED_SCHEMA_VERSION

Fields inherited from class org.opensubsystems.core.persist.db.DatabaseSchemaImpl

DATABASE_SCHEMA_PREFIX, DATABASE_SCHEMA_PREFIX_DEFAULT, m_arrDependentSchemas, m_bIsInDomain, m_iSchemaVersion, m_strSchemaName, NL

Fields inherited from interface org.opensubsystems.core.persist.db.DatabaseOperations

DBOP_DELETE, DBOP_INSERT, DBOP_SELECT, DBOP_UPDATE

Constructor Summary

MSSQLVersionedDatabaseSchema()

Method Summary

void	create(java.sql.Connection cntDBConnection, java.lang.String strUserName) Create the schema.

Methods inherited from class org.opensubsystems.core.persist.db.VersionedDatabaseSchema

add, createOrUpgradeSchemas, init, loadExistingSchemas

Methods inherited from class org.opensubsystems.core.persist.db.DatabaseSchemaImpl

getDependentSchemas, getJoinFromWhere, getName, getOwnerColumnNames, getSchemaPrefix, getVersion, handleSQLException, isExistingIndex, isInDomain, upgrade, upgradeView

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MSSQLVersionedDatabaseSchema

public MSSQLVersionedDatabaseSchema()
                             throws OSSException

Throws:

OSSException - - database cannot be started.

Method Detail

create

public void create(java.sql.Connection cntDBConnection,
                   java.lang.String strUserName)
            throws java.sql.SQLException

Create the schema.

Specified by:

create in interface DatabaseSchema

Overrides:

create in class VersionedDatabaseSchema

Parameters:

cntDBConnection - - valid connection to database

strUserName - - name of user who will be accessing this table

Throws:

java.sql.SQLException - - problem creating the schema