org.opensubsystems.core.persist.db.sybase
Class SybaseVersionedDatabaseSchema

java.lang.Object
  org.opensubsystems.core.persist.db.DatabaseSchemaImpl
      org.opensubsystems.core.persist.db.VersionedDatabaseSchema
          org.opensubsystems.core.persist.db.sybase.SybaseVersionedDatabaseSchema

All Implemented Interfaces:

DatabaseOperations, DatabaseSchema

public class SybaseVersionedDatabaseSchema
extends VersionedDatabaseSchema

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

Version:

$Id: SybaseVersionedDatabaseSchema.java,v 1.6 2007/01/07 06:14:45 bastafidli Exp $

Author:

Julo Legeny

Code reviewer:

Miro Halas

Code reviewed:

1.4 2005/10/10 09:00:30 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

SybaseVersionedDatabaseSchema()

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

SybaseVersionedDatabaseSchema

public SybaseVersionedDatabaseSchema()
                              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