mondrian.gui
Class JDBCMetaData

java.lang.Object
  mondrian.gui.JDBCMetaData

public class JDBCMetaData
extends Object

Nested Class Summary

(package private) class	JDBCMetaData.Database
(package private) class	JDBCMetaData.DbSchema
(package private) class	JDBCMetaData.DbTable
(package private) class	JDBCMetaData.FactTable

Field Summary

(package private) Connection	conn
(package private) String	jdbcConnectionUrl
(package private) String	jdbcDriverClassName
(package private) String	jdbcPassword
(package private) String	jdbcUsername
(package private) DatabaseMetaData	md
(package private) Workbench	workbench

Constructor Summary

JDBCMetaData(Workbench wb, String jdbcDriverClassName, String jdbcConnectionUrl, String jdbcUsername, String jdbcPassword)

Method Summary

void	closeConnection()
Vector<String>	getAllColumns(String schemaName, String tableName)
Vector<String>	getAllSchemas()
Vector<String>	getAllTables(String schemaName)
Vector<String>	getAllTables(String schemaName, String minusTable)
int	getColumnDataType(String schemaName, String tableName, String colName)
String	getDatabaseProductName()
String	getDbCatalogName()
Vector<String>	getDimensionTables(String schemaName, String factTable)
String	getErrMsg()
Vector<String>	getFactTableFKs(String schemaName, String factTable)
Vector<String>	getFactTables(String schemaName)
I18n	getResourceConverter()
String	getTablePK(String schemaName, String tableName)
String	initConnection()
boolean	isColExists(String schemaName, String tableName, String colName)
boolean	isTableExists(String schemaName, String tableName)
static void	main(String[] args)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

jdbcDriverClassName

String jdbcDriverClassName

jdbcConnectionUrl

String jdbcConnectionUrl

jdbcUsername

String jdbcUsername

jdbcPassword

String jdbcPassword

conn

Connection conn

md

DatabaseMetaData md

workbench

Workbench workbench

Constructor Detail

JDBCMetaData

public JDBCMetaData(Workbench wb,
                    String jdbcDriverClassName,
                    String jdbcConnectionUrl,
                    String jdbcUsername,
                    String jdbcPassword)

Method Detail

getResourceConverter

public I18n getResourceConverter()

Returns:

the workbench i18n converter

initConnection

public String initConnection()

closeConnection

public void closeConnection()

getAllSchemas

public Vector<String> getAllSchemas()

getAllTables

public Vector<String> getAllTables(String schemaName)

getAllTables

public Vector<String> getAllTables(String schemaName,
                                   String minusTable)

getFactTables

public Vector<String> getFactTables(String schemaName)

getDimensionTables

public Vector<String> getDimensionTables(String schemaName,
                                         String factTable)

isTableExists

public boolean isTableExists(String schemaName,
                             String tableName)

isColExists

public boolean isColExists(String schemaName,
                           String tableName,
                           String colName)

getFactTableFKs

public Vector<String> getFactTableFKs(String schemaName,
                                      String factTable)

getTablePK

public String getTablePK(String schemaName,
                         String tableName)

getAllColumns

public Vector<String> getAllColumns(String schemaName,
                                    String tableName)

getColumnDataType

public int getColumnDataType(String schemaName,
                             String tableName,
                             String colName)

getDbCatalogName

public String getDbCatalogName()

getDatabaseProductName

public String getDatabaseProductName()

getErrMsg

public String getErrMsg()

main

public static void main(String[] args)