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
-
CLASSALIASCOUNT
-
-
INDEXCOUNT
-
-
LOGICCOUNT
-
-
OTHERALIASCOUNT
-
-
SPSSTATEMENTCOUNT
-
-
TABLECOUNT
-
-
TRIGGERCOUNT
-
-
VIEWCOUNT
-
-
CreateSchema()
-
-
createClassAliases(Connection)
- Creates the class aliases in the database.
-
createDatabaseClasspath(Connection)
- Store logic in the database.
-
createIndexes(Connection)
- Creates the indexes in the database.
-
createMainDatabaseObjects(Connection)
- Creates the main database objects (all except stored prepared statements,
which we should create later, after data is loaded.);
-
createOtherAliases(Connection)
- Creates the other aliases (method aliases, aggregates) in the database.
-
createSQLScript(Connection)
- Creates a script that rebuilds the database schema.
-
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.
-
createTables(Connection)
- Creates the tables the database.
-
createTriggers(Connection)
- Don't create triggers until after we load data.
-
createViews(Connection)
- Creates the views in the database.
CLASSALIASCOUNT
public static int CLASSALIASCOUNT
TABLECOUNT
public static int TABLECOUNT
INDEXCOUNT
public static int INDEXCOUNT
VIEWCOUNT
public static int VIEWCOUNT
OTHERALIASCOUNT
public static int OTHERALIASCOUNT
SPSSTATEMENTCOUNT
public static int SPSSTATEMENTCOUNT
TRIGGERCOUNT
public static int TRIGGERCOUNT
LOGICCOUNT
public static int LOGICCOUNT
CreateSchema
public CreateSchema()
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.
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.
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.
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.
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.
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.
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.
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.
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.
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