rdbtoonto.dbmodel
Class Oracle_Reader

java.lang.Object
  extended by rdbtoonto.dbmodel.DBReader
      extended by rdbtoonto.dbmodel.Oracle_Reader

public class Oracle_Reader
extends DBReader

Author:
scdtncf This class is intended to provide an implementation to a pure JDBC reader for Oracle databases

Constructor Summary
Oracle_Reader(java.lang.String DBUrl, java.lang.String user, java.lang.String password)
           
 
Method Summary
 boolean addColumns(TableDef td)
           
 boolean addForeignKeys()
           
 boolean addPrimaryKey(TableDef td)
           
 boolean addPrimaryKeys()
           
static void close()
          Closes the connection to the database file
 boolean connectToDatabase()
           
 boolean createSystemTable()
           
 java.util.Vector<java.lang.String> getDatabaseTables()
           
static java.util.Vector<java.lang.String> getTableCols(java.lang.String tableName)
           
static java.lang.String makeTableDataQuery(TableDef td)
           
 boolean populateSysTable(Table ataTab)
           
 boolean readDataTable(TableDef td)
           
 boolean readSchema()
           
 AType toXSDType(java.lang.String col, int sqlType)
           
 
Methods inherited from class rdbtoonto.dbmodel.DBReader
getDatabase, lookForAttIgnoreCase, lookForTableIgnoreCase, readData, readDatabase
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Oracle_Reader

public Oracle_Reader(java.lang.String DBUrl,
                     java.lang.String user,
                     java.lang.String password)
              throws DBReaderException
Throws:
DBReaderException
Method Detail

readSchema

public boolean readSchema()
Overrides:
readSchema in class DBReader

addColumns

public boolean addColumns(TableDef td)

toXSDType

public AType toXSDType(java.lang.String col,
                       int sqlType)

addPrimaryKeys

public boolean addPrimaryKeys()

addPrimaryKey

public boolean addPrimaryKey(TableDef td)

addForeignKeys

public boolean addForeignKeys()

readDataTable

public boolean readDataTable(TableDef td)
Overrides:
readDataTable in class DBReader

connectToDatabase

public boolean connectToDatabase()

getDatabaseTables

public java.util.Vector<java.lang.String> getDatabaseTables()

getTableCols

public static java.util.Vector<java.lang.String> getTableCols(java.lang.String tableName)

makeTableDataQuery

public static java.lang.String makeTableDataQuery(TableDef td)

close

public static void close()
Closes the connection to the database file


createSystemTable

public boolean createSystemTable()

populateSysTable

public boolean populateSysTable(Table ataTab)