All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class JBMSTours.CreateSchema

java.lang.Object
   |
   +----JBMSTours.CreateSchema

public class CreateSchema
extends Object
Look at the Source. Creates the schema for the database.

See Also:
CreateToursDB

Variable Index

 o CLASSALIASCOUNT
 o INDEXCOUNT
 o LOGICCOUNT
 o OTHERALIASCOUNT
 o SPSSTATEMENTCOUNT
 o TABLECOUNT
 o TRIGGERCOUNT
 o VIEWCOUNT

Constructor Index

 o CreateSchema()

Method Index

 o createClassAliases(Connection)
Creates the class aliases in the database.
 o createDatabaseClasspath(Connection)
Store logic in the database.
 o createIndexes(Connection)
Creates the indexes in the database.
 o createMainDatabaseObjects(Connection)
Creates the main database objects (all except stored prepared statements, which we should create later, after data is loaded.);
 o createOtherAliases(Connection)
Creates the other aliases (method aliases, aggregates) in the database.
 o createSQLScript(Connection)
Creates a script that rebuilds the database schema.
 o createStoredPreparedStatements(Connection)
we create the stored prepared statements in a separate method, because we want to create them only after we have loaded the data.
 o createTables(Connection)
Creates the tables the database.
 o createTriggers(Connection)
Don't create triggers until after we load data.
 o createViews(Connection)
Creates the views in the database.

Variables

 o CLASSALIASCOUNT
 public static int CLASSALIASCOUNT
 o TABLECOUNT
 public static int TABLECOUNT
 o INDEXCOUNT
 public static int INDEXCOUNT
 o VIEWCOUNT
 public static int VIEWCOUNT
 o OTHERALIASCOUNT
 public static int OTHERALIASCOUNT
 o SPSSTATEMENTCOUNT
 public static int SPSSTATEMENTCOUNT
 o TRIGGERCOUNT
 public static int TRIGGERCOUNT
 o LOGICCOUNT
 public static int LOGICCOUNT

Constructors

 o CreateSchema
 public CreateSchema()

Methods

 o createClassAliases
 public boolean createClassAliases(Connection conn) throws SQLException
Creates the class aliases in the database. Do this first, so that we can reference the aliases in the schema.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createTables
 public boolean createTables(Connection conn) throws SQLException
Creates the tables the database.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createIndexes
 public boolean createIndexes(Connection conn) throws SQLException
Creates the indexes in the database.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createViews
 public boolean createViews(Connection conn) throws SQLException
Creates the views in the database.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createOtherAliases
 public boolean createOtherAliases(Connection conn) throws SQLException
Creates the other aliases (method aliases, aggregates) in the database.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createMainDatabaseObjects
 public boolean createMainDatabaseObjects(Connection conn) throws SQLException
Creates the main database objects (all except stored prepared statements, which we should create later, after data is loaded.);

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createStoredPreparedStatements
 public boolean createStoredPreparedStatements(Connection conn) throws SQLException
we create the stored prepared statements in a separate method, because we want to create them only after we have loaded the data. The statements won't be optimized correctly if the tables are empty

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createTriggers
 public boolean createTriggers(Connection conn) throws SQLException
Don't create triggers until after we load data.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createDatabaseClasspath
 public boolean createDatabaseClasspath(Connection conn) throws SQLException
Store logic in the database. Do this only in pre-building database.

Parameters:
conn - Connection
Returns:
boolean if the creation worked
Throws: SQLException
an error occurred.
 o createSQLScript
 public boolean createSQLScript(Connection conn) throws SQLException
Creates a script that rebuilds the database schema.

Parameters:
conn - Connection
Returns:
boolean
Throws: SQLException
an error occurred.

All Packages  Class Hierarchy  This Package  Previous  Next  Index