org.opensubsystems.core.persist.db.mysql
Class MySQLVersionedDatabaseSchema

java.lang.Object
  org.opensubsystems.core.persist.db.DatabaseSchemaImpl
      org.opensubsystems.core.persist.db.VersionedDatabaseSchema
          org.opensubsystems.core.persist.db.mysql.MySQLVersionedDatabaseSchema

All Implemented Interfaces:

DatabaseOperations, DatabaseSchema

public class MySQLVersionedDatabaseSchema
extends VersionedDatabaseSchema

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

Version:

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

Author:

Julo Legeny

Code reviewer:

Miro Halas

Code reviewed:

1.4 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

MySQLVersionedDatabaseSchema()

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

MySQLVersionedDatabaseSchema

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