All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class DSRG.MW.DBMOracle

java.lang.Object
   |
   +----DSRG.MW.DBManager
           |
           +----DSRG.MW.DBMOracle

public class DBMOracle
extends DBManager
implements Serializable

Variable Index

 o date_datatype
 o numeric_datatype
Oracle specific data types.

Constructor Index

 o DBMOracle()
Constructor.
 o DBMOracle(String, String, String, String)
Constructor that takes input for the user and passwd...

Method Index

 o addAttribute(String, String, String, int)
addAttribute.
 o addRelation(String, Vector, Vector)
/** addRelation.
 o deleteAttribute(String, String)
deleteAttribute.
 o deleteRelation(String, boolean)
deleteRelation.
 o getSchema(String)
Helper function.
 o renameAttribute(String, String, String)
renameAttribute.
 o renameRelation(String, String)
renameRelation
2/4/98 koeller
 o resetDB(String)
Reset the Oracle database.
 o storeRelation(Table)
stores a Table object in a database.

Variables

 o numeric_datatype
 private final String numeric_datatype
Oracle specific data types.

 o date_datatype
 private final String date_datatype

Constructors

 o DBMOracle
 public DBMOracle()
Constructor.

 o DBMOracle
 public DBMOracle(String myISName,
                  String usr,
                  String pswd,
                  String URL)
Constructor that takes input for the user and passwd... rather than using the dflt eve, eve;

Methods

 o addRelation
 public boolean addRelation(String relName,
                            Vector attNames,
                            Vector attTypes)
/** addRelation.
creates only the schema, does not insert data or anything
The types have to be like "VARCHAR2(.." otherwise they're overwritten by "VARCHAR2(31) 10/9/97 koeller

Overrides:
addRelation in class DBManager
 o deleteRelation
 public boolean deleteRelation(String name,
                               boolean silent)
deleteRelation.

Parameters:
name - the name of the relation to be deleted
silent - a flag that shows if the error message for deleting a non-existent relation should be suppressed.
Overrides:
deleteRelation in class DBManager
 o renameAttribute
 public boolean renameAttribute(String RelationName,
                                String oldName,
                                String newName)
renameAttribute.
10/6/97 koeller

Overrides:
renameAttribute in class DBManager
 o addAttribute
 public boolean addAttribute(String RelationName,
                             String AttributeName,
                             String type,
                             int size)
addAttribute.
Extents are being ignored, not needed/possible for the demo
10/6/97 koeller

Overrides:
addAttribute in class DBManager
 o deleteAttribute
 public boolean deleteAttribute(String RelationName,
                                String attributeName)
deleteAttribute.
This overwrites any table in the database that is called "tmp31415926". 10/6/97 koeller

Overrides:
deleteAttribute in class DBManager
 o renameRelation
 public boolean renameRelation(String oldName,
                               String newName)
renameRelation
2/4/98 koeller

Overrides:
renameRelation in class DBManager
 o storeRelation
 public boolean storeRelation(Table table)
stores a Table object in a database.
Creates a schema and stores data in there. Uses the relation's name and attribute names and lengths everything is created as "VARCHAR2" !! This is for view recomputation and should only be used on LocalIS

Overrides:
storeRelation in class DBManager
 o getSchema
 private String getSchema(String relationName)
Helper function.
This will read the Schema of a given table in the IS, concatenating it to a string of the form ([columnname type,] columnname type)

 o resetDB
 public void resetDB(String filename)
Reset the Oracle database. this is a hack for the EVE-Demo. It runs a SQL-script whose name is defined in the eve.properties.


All Packages  Class Hierarchy  This Package  Previous  Next  Index