DSRG.MW
Class DBMOracle

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

public class DBMOracle
extends DBManager
implements java.io.Serializable

See Also:
Serialized Form

Field Summary
private  java.lang.String date_datatype
           
private  java.lang.String numeric_datatype
          Oracle specific data types.
 
Fields inherited from class DSRG.MW.DBManager
className, connected, connection, date_datatype, DEBUG, driver, ISName, numeric_datatype, passwd, url, user
 
Constructor Summary
DBMOracle()
          Constructor.
DBMOracle(java.lang.String myISName, java.lang.String usr, java.lang.String pswd, java.lang.String URL)
          Constructor that takes input for the user and passwd...
 
Method Summary
 boolean addAttribute(java.lang.String RelationName, java.lang.String AttributeName, java.lang.String type, int size)
          addAttribute.
 boolean addRelation(java.lang.String relName, java.util.Vector attNames, java.util.Vector attTypes)
          /** addRelation.
 boolean deleteAttribute(java.lang.String RelationName, java.lang.String attributeName)
          deleteAttribute.
 boolean deleteRelation(java.lang.String name, boolean silent)
          deleteRelation.
private  java.lang.String getSchema(java.lang.String relationName)
          Helper function.
 boolean renameAttribute(java.lang.String RelationName, java.lang.String oldName, java.lang.String newName)
          renameAttribute.
 boolean renameRelation(java.lang.String oldName, java.lang.String newName)
          renameRelation
2/4/98 koeller
 void resetDB(java.lang.String filename)
          Reset the Oracle database.
 boolean storeRelation(Table table)
          stores a Table object in a database.
 
Methods inherited from class DSRG.MW.DBManager
executeQuery, executeViewQuery, getAttributeExtent, getAttributeNames, getAttributeType, getISName, getRelationNames, getTableName, isConnected, makeSelectClause, privateExecuteQuery, renameAttributeInSchema, sendUpdate, stripAttributeFromSchema
 
Methods inherited from class java.lang.Object
, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 

Field Detail

numeric_datatype

private final java.lang.String numeric_datatype
Oracle specific data types.

date_datatype

private final java.lang.String date_datatype
Constructor Detail

DBMOracle

public DBMOracle()
Constructor.

DBMOracle

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

addRelation

public boolean addRelation(java.lang.String relName,
                           java.util.Vector attNames,
                           java.util.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

deleteRelation

public boolean deleteRelation(java.lang.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

renameAttribute

public boolean renameAttribute(java.lang.String RelationName,
                               java.lang.String oldName,
                               java.lang.String newName)
renameAttribute.
10/6/97 koeller
Overrides:
renameAttribute in class DBManager

addAttribute

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

deleteAttribute

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

renameRelation

public boolean renameRelation(java.lang.String oldName,
                              java.lang.String newName)
renameRelation
2/4/98 koeller
Overrides:
renameRelation in class DBManager

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

getSchema

private java.lang.String getSchema(java.lang.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)

resetDB

public void resetDB(java.lang.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.