de.schwarzrot.data.access.jdbc
Class JDBCModelScanner

java.lang.Object
  de.schwarzrot.data.access.jdbc.JDBCModelScanner

public class JDBCModelScanner
extends Object

class to get database model informations out from the JDBC-metadata information.

Playing together with XMLExporter and XMLImporter it is a powerful weapon to port database schema.

Author:

Reinhard Mantey

Constructor Summary

JDBCModelScanner(Connection conn)

Method Summary

protected void	adoptTables(DatabaseModel dbInfo, Collection<TableDefinition> tables)
protected void	dumpRS(ResultSet rs)
DatabaseModel	scan() scans the entire metadata-information of database from datasource definition
DatabaseModel	scan(DatabaseModel dbInfo) scans entire database meta information and place information into given DatabaseModel instance.
DatabaseModel	scan(DatabaseModel dbInfo, String schemaName) scans given schema from database metadata-information.
DatabaseModel	scan(String schemaName) scans given schema from database meta information
protected void	scanColumns(DatabaseModel dbInfo, TableDefinition ti)
protected void	scanIndexes(DatabaseModel dbInfo, TableDefinition td)
protected void	scanSchemata(DatabaseModel dbInfo, String schemaOnly)
protected void	scanTables(DatabaseModel dbInfo, String schemaOnly)

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCModelScanner

public JDBCModelScanner(Connection conn)

Method Detail

scan

public DatabaseModel scan()

scans the entire metadata-information of database from datasource definition

Returns:

the created model definition

scan

public DatabaseModel scan(DatabaseModel dbInfo)

scans entire database meta information and place information into given DatabaseModel instance. That instance will be returned too

Parameters:

dbInfo - - a DatabaseModel instance to hold meta information

Returns:

- instance of DatabaseModel filled with meta information

scan

public DatabaseModel scan(DatabaseModel dbInfo,
                          String schemaName)

scans given schema from database metadata-information.

Parameters:

dbInfo - - instance that holds database model information. Use null if you can live with return value only.

schemaName - - the schema to scan, null for all

Returns:

- the created model definition

scan

public DatabaseModel scan(String schemaName)

scans given schema from database meta information

Parameters:

schemaName - - the schema to scan, null for all

Returns:

- instance of DatabaseModel filled with meta information

adoptTables

protected void adoptTables(DatabaseModel dbInfo,
                           Collection<TableDefinition> tables)

dumpRS

protected void dumpRS(ResultSet rs)

scanColumns

protected void scanColumns(DatabaseModel dbInfo,
                           TableDefinition ti)

scanIndexes

protected void scanIndexes(DatabaseModel dbInfo,
                           TableDefinition td)

scanSchemata

protected void scanSchemata(DatabaseModel dbInfo,
                            String schemaOnly)

scanTables

protected void scanTables(DatabaseModel dbInfo,
                          String schemaOnly)