borland Packages  Class Hierarchy  datastore Package 

DataStorePump component

java.lang.Object
   +----com.borland.datastore.DataStorePump

About the DataStorePump component

Constructors  Properties  Methods  

Implements Designable

Note: This is a feature of JBuilder Professional and Enterprise.

DataStorePump can be used to easily migrate data into a JDataStore from another data source.


DataStorePump constructors

DataStorePump properties

*Read-only properties **Write-only properties

Properties implemented in this class

Properties implemented in java.lang.Object

DataStorePump methods

Methods implemented in this class

Methods implemented in java.lang.Object


DataStorePump constructors

DataStorePump()

  public DataStorePump()

DataStorePump properties

catalogPattern

 public String getCatalogPattern()
 public void setCatalogPattern(String newCatalogPattern)
Catalog Pattern used by getTableDefs() method when calling java.sql.DatabaseMetaData.getTables() against the external database to select tables for import.

databaseSource

 public Database getDatabaseSource()
 public void setDatabaseSource(Database database)
Database to copy tables from.

dataStore

 public DataStore getDataStore()
 public void setDataStore(DataStore dataStore)
DataStore to copy tables to.

enableRefresh

 public boolean isEnableRefresh()
 public void setEnableRefresh(boolean newEnableRefresh)
If true, the TableDef.enableRefresh property will be set to true for every TableDef returned by getTableDefs() method.

enableSave

 public boolean isEnableSave()
 public void setEnableSave(boolean newEnableSave)
If true, the TableDef.enableSave property will be set to true for every TableDef returned by getTableDefs() method.

importIndexes

 public boolean isImportIndexes()
 public void setImportIndexes(boolean newimportIndexes)
If true, index definitions from the external database will be created for the same table inside the JDataStore database.

recordQueries

 public boolean isRecordQueries()
 public void setRecordQueries(boolean newRecordQueries)
If true, the queries used to import the table definitions will be recorded in the /SYS/QUERIES and /SYS/CONNECTIONS tables.

schemaPattern

 public String getSchemaPattern()
 public void setSchemaPattern(String newSchemaPattern)
Schema Pattern used by getTableDefs() method when calling java.sql.DatabaseMetaData.getTables() against the external database to select tables for import.

tableDefs

 public TableDef[] getTableDefs()
Creates an array of TableDefs for all tables from the database whose name matches the pattern specifications for catalog, schema and table names.

tablePattern

 public String getTablePattern()
 public void setTablePattern(String newTablePattern)
Schema Pattern used by getTableDefs() method when calling java.sql.DatabaseMetaData.getTables() against the external database to select tables for import.

upperCaseColumnNames

 public boolean isUpperCaseColumnNames()
 public void setUpperCaseColumnNames(boolean upperCase)
If true, column names of imported tables are forced to upper case.

upperCaseIndexNames

 public boolean isUpperCaseIndexNames()
 public void setUpperCaseIndexNames(boolean upperCase)
If true, force names of indexes from imported tables to upper case.

upperCaseTableNames

 public boolean isUpperCaseTableNames()
 public void setUpperCaseTableNames(boolean upperCase)
If true, force names of imported tables to upper case.

DataStorePump methods

close()

  public void close()
This method should be called when DataStorePump is no longer needed.

copyTable(td)

  public void copyTable(TableDef td)
Copy a table into the JDataStore based on the TableDef specification. Note that TableDefs can be modified to change identifier casing or remove secondary or primary index specifications.

getConnectionsTable()

  public static TableDataSet getConnectionsTable()
Creates SYS/CONNECTIONS table used for refreshing table data from another database and saving table data back to another database.

See also: DataStoreSync

getExtendedProperties(java.lang.String)

  public static Properties getExtendedProperties(String s)
Creates an extended properties object that can be used by a JDBC driver from a comma separated list of attribute value pairs e.g. "username=joe,password=joey54,charset=Western"

getIndexes(td)

  public SortDescriptor[] getIndexes(TableDef td)
Get an array of SortDescriptors that specify all secondary and primary indexes for the table specified by the TableDef.

getQueriesTable()

  public static TableDataSet getQueriesTable()
Creates SYS/QUERIES table used for refreshing table data from another database and saving table data back to another database.

See also: DataStoreSync

getSelectForTable(java.lang.String, java.lang.String, java.lang.String)

  public String getSelectForTable(String catalogName, String schemaName, String tableName)
Builds a default select statement for a table with the given name from the database specified by the databaseSource property.

open()

  public void open()
Call this to use the DataStorePump. Must be called after setting databaseSource and dataStore properties.