net.sf.borg.model.db.jdbc

Class JdbcDBUpgrader

java.lang.Object

net.sf.borg.model.db.jdbc.JdbcDBUpgrader

public class JdbcDBUpgrader
extends Object

Class JdbcDBUpgrader is used to upgrade HSQL database in-place when the schema changes for a release. This class will check an update condition, and if true, execute SQL to upgrade the DB. It is meant to be called during model initialization - preferably from the constructors of the JdbcDB classes

Constructor Summary

Constructors

Constructor and Description
JdbcDBUpgrader(String checkSql, String usql) Instantiates a new jdbc db upgrader.
JdbcDBUpgrader(String checkSql, String[] usql) Instantiates a new jdbc db upgrader.

Method Summary

Methods

Modifier and Type	Method and Description
void	upgrade() run the upgrade check and then upgrade if needed

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcDBUpgrader

public JdbcDBUpgrader(String checkSql,
              String usql)

Instantiates a new jdbc db upgrader.

Parameters:

checkSql - the sql that checks if an upgrade is needed

usql - the sql to upgrade the db if needed

JdbcDBUpgrader

public JdbcDBUpgrader(String checkSql,
              String[] usql)

Instantiates a new jdbc db upgrader.

Parameters:

checkSql - the sql that checks if an upgrade is needed

usql - an array of SQL statements to execute to perform the upgrade

Method Detail

upgrade

public void upgrade()

run the upgrade check and then upgrade if needed