Uses of Class
net.sf.jailer.configuration.DBMS

Packages that use DBMS

Package	Description
net.sf.jailer
net.sf.jailer.api
net.sf.jailer.configuration
net.sf.jailer.database
net.sf.jailer.datamodel
net.sf.jailer.dbunit
net.sf.jailer.ddl
net.sf.jailer.enhancer
net.sf.jailer.entitygraph
net.sf.jailer.entitygraph.intradatabase
net.sf.jailer.entitygraph.local
net.sf.jailer.entitygraph.remote
net.sf.jailer.importfilter
net.sf.jailer.modelbuilder
net.sf.jailer.subsetting
net.sf.jailer.util

Uses of DBMS in net.sf.jailer

Methods in net.sf.jailer that return DBMS

Modifier and Type	Method	Description
DBMS	ExecutionContext.getTargetDBMS()	Gets target-DBMS: ORACLE, MSSQL, DB2, MySQL, POSTGRESQL, SYBASE, SQLITE, HSQL or H2

Methods in net.sf.jailer with parameters of type DBMS

Modifier and Type	Method	Description
void	ExecutionContext.setTargetDBMS(DBMS targetDBMS)	Sets target-DBMS: ORACLE, MSSQL, DB2, MySQL, POSTGRESQL, SYBASE, SQLITE, HSQL or H2

Uses of DBMS in net.sf.jailer.api

Methods in net.sf.jailer.api that return DBMS

Modifier and Type	Method	Description
DBMS	Subsetter.getDbms()	Gets the DBMS of the database.
DBMS	Subsetter.getTargetDBMS()	Gets target-DBMS.

Methods in net.sf.jailer.api with parameters of type DBMS

Modifier and Type	Method	Description
void	Subsetter.setDbms(DBMS dbms)	Sets the DBMS of the database.
void	Subsetter.setTargetDBMS(DBMS targetDBMS)	Sets target-DBMS.

Constructors in net.sf.jailer.api with parameters of type DBMS

Modifier	Constructor	Description
	Subsetter(DataSource dataSource, DBMS dbms, File dataModel, File extractionModel, ScriptFormat scriptFormat)	Creates a new Subsetter with all mandatory attributes.
	Subsetter(DataSource dataSource, DBMS dbms, URL dataModel, URL extractionModel, ScriptFormat scriptFormat)	Creates a new Subsetter with all mandatory attributes.

Uses of DBMS in net.sf.jailer.configuration

Fields in net.sf.jailer.configuration declared as DBMS

Modifier and Type	Field	Description
static final DBMS	DBMS.CLICKHOUSE
static final DBMS	DBMS.CLOADSCAPE
static final DBMS	DBMS.DB2
static final DBMS	DBMS.DB2_ZOS
static final DBMS	DBMS.DERBY
static final DBMS	DBMS.FIREBIRD
static final DBMS	DBMS.H2
static final DBMS	DBMS.HSQL
static final DBMS	DBMS.INFORMIX
static final DBMS	DBMS.MSSQL
static final DBMS	DBMS.MySQL
static final DBMS	DBMS.ORACLE
static final DBMS	DBMS.POSTGRESQL
static final DBMS	DBMS.SQLITE
static final DBMS	DBMS.SYBASE

Methods in net.sf.jailer.configuration that return DBMS

Modifier and Type	Method	Description
static DBMS	DBMS.forDBMS(String dbmsId)	Gets DBMS specific configuration.
static DBMS[]	DBMS.values()	Gets all DBMSes.

Methods in net.sf.jailer.configuration that return types with arguments of type DBMS

Modifier and Type	Method	Description
List<DBMS>	Configuration.getDBMS()	Gets all DBMS configurations.

Method parameters in net.sf.jailer.configuration with type arguments of type DBMS

Modifier and Type	Method	Description
void	Configuration.setdBMSConfigurations(List<DBMS> dBMSConfigurations)	Sets all DBMS configurations.

Uses of DBMS in net.sf.jailer.database

Fields in net.sf.jailer.database declared as DBMS

Modifier and Type	Field	Description
final DBMS	BasicDataSource.dbms	The DBMS.
final DBMS	Session.dbms	The DBMS.

Methods in net.sf.jailer.database with parameters of type DBMS

Modifier and Type	Method	Description
protected CellContentConverter	Session.AbstractResultSetReader.getCellContentConverter(ResultSet resultSet, Session session, DBMS targetDBMSConfiguration)	Gets and caches the CellContentConverter for the result set.

Constructors in net.sf.jailer.database with parameters of type DBMS

Modifier	Constructor	Description
	BasicDataSource(String driverClassName, String dbUrl, String dbUser, String dbPassword, DBMS dbms, int maxPoolSize, URL... jdbcDriverURL)	Constructor.
protected	DMLTransformer(Table table, OutputStreamWriter scriptFileWriter, boolean upsertOnly, int maxBodySize, Session session, DBMS targetDBMSConfiguration, ImportFilterTransformer importFilterTransformer, AtomicReference<Table> identityInsertTable, ExecutionContext executionContext)	Constructor.
	Factory(OutputStreamWriter scriptFileWriter, int maxBodySize, Session session, DBMS targetDBMSConfiguration, ExecutionContext executionContext)	Constructor.
	Factory(OutputStreamWriter scriptFileWriter, boolean upsertOnly, int maxBodySize, Session session, DBMS targetDBMSConfiguration, ExecutionContext executionContext)	Constructor.
	Session(DataSource dataSource, DBMS dbms, Integer isolationLevel)	Constructor.
	Session(DataSource dataSource, DBMS dbms, Integer isolationLevel, WorkingTableScope scope, boolean transactional)	Constructor.
	Session(DataSource dataSource, DBMS dbms, Integer isolationLevel, WorkingTableScope scope, boolean transactional, boolean local)	Constructor.
	UpdateTransformer(Table table, Set<Column> columns, OutputStreamWriter scriptFileWriter, int maxBodySize, Session session, DBMS targetDBMSConfiguration, ImportFilterTransformer importFilterTransformer, boolean inSourceSchema, String reason, ExecutionContext executionContext)	Constructor.

Uses of DBMS in net.sf.jailer.datamodel

Constructors in net.sf.jailer.datamodel with parameters of type DBMS

Modifier	Constructor	Description
	RowIdSupport(DataModel dataModel, DBMS configuration, boolean useRowIds, boolean useRowIdsOnlyForTablesWithoutPK)	Constructor.
	RowIdSupport(DataModel dataModel, DBMS configuration, String rowIdType, boolean useRowIds, boolean useRowIdsOnlyForTablesWithoutPK)	Constructor.
	RowIdSupport(DataModel dataModel, DBMS configuration, String rowIdType, ExecutionContext executionContext)	Constructor.
	RowIdSupport(DataModel dataModel, DBMS configuration, ExecutionContext executionContext)	Constructor.

Uses of DBMS in net.sf.jailer.dbunit

Constructors in net.sf.jailer.dbunit with parameters of type DBMS

Modifier	Constructor	Description
	Factory(TransformerHandler transformerHandler, DatabaseMetaData metaData, DBMS dbms, ExecutionContext executionContext)	Constructor.

Uses of DBMS in net.sf.jailer.ddl

Methods in net.sf.jailer.ddl with parameters of type DBMS

Modifier and Type	Method	Description
boolean	DDLCreator.createDDL(DataSource dataSource, DBMS dbms, WorkingTableScope temporaryTableScope, String workingTableSchema)	Creates the DDL for the working-tables.
String	DDLCreator.getTableInConflict(DataSource dataSource, DBMS dbms)	Checks for conflicts of existing tables and working-tables.
boolean	DDLCreator.isUptodate(DataSource dataSource, DBMS dbms, boolean useRowId, boolean useRowIdsOnlyForTablesWithoutPK, String workingTableSchema)	Checks whether working-tables schema is up-to-date.

Uses of DBMS in net.sf.jailer.enhancer

Methods in net.sf.jailer.enhancer with parameters of type DBMS

Modifier and Type	Method	Description
void	FileBasedScriptEnhancer.addComments(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds nothing.
void	HelperTableEnhancer.addComments(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds nothing.
void	ScriptEnhancer.addComments(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds comments to the script.
void	FileBasedScriptEnhancer.addEpilog(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds epilogs.
void	HelperTableEnhancer.addEpilog(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Drops the JL_DUAL helper table at the bottom of the script if it was needed.
void	ScriptEnhancer.addEpilog(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds statements at bottom of the script.
void	FileBasedScriptEnhancer.addProlog(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds prologs.
void	HelperTableEnhancer.addProlog(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Creates and populates the JL_DUAL helper table at the top of the script if needed.
void	ScriptEnhancer.addProlog(Writer script, ScriptType scriptType, Session session, DBMS targetDBMSConfiguration, EntityGraph entityGraph, Set<Table> progress, ExecutionContext executionContext)	Adds statements at top of the script.

Uses of DBMS in net.sf.jailer.entitygraph

Methods in net.sf.jailer.entitygraph with parameters of type DBMS

Modifier and Type	Method	Description
void	EntityGraph.dropMappingTables(OutputStreamWriter result, DBMS targetDBMSConfiguration)	Creates the DROP-statements for the mapping tables.
void	EntityGraph.fillAndWriteMappingTables(JobManager jobManager, OutputStreamWriter dmlResultWriter, int numberOfEntities, Session targetSession, DBMS targetDBMSConfiguration, DBMS dbmsConfiguration)	Inserts the values of columns with non-derived import-filters into the local database.
abstract void	EntityGraph.updateEntities(Table table, Set<Column> columns, OutputStreamWriter scriptFileWriter, DBMS targetConfiguration, boolean inSourceSchema, String reason)	Updates columns of a table.

Uses of DBMS in net.sf.jailer.entitygraph.intradatabase

Methods in net.sf.jailer.entitygraph.intradatabase with parameters of type DBMS

Modifier and Type	Method	Description
void	IntraDatabaseEntityGraph.dropMappingTables(OutputStreamWriter result, DBMS targetDBMSConfiguration)	Creates the DROP-statements for the mapping tables.
void	IntraDatabaseEntityGraph.fillAndWriteMappingTables(JobManager jobManager, OutputStreamWriter receiptWriter, int numberOfEntities, Session targetSession, DBMS targetDBMSConfiguration, DBMS dbmsConfiguration)	Insert the values of columns with non-derived-import-filters into the local database.
void	IntraDatabaseEntityGraph.updateEntities(Table table, Set<Column> columns, OutputStreamWriter scriptFileWriter, DBMS targetConfiguration, boolean inSourceSchema, String reason)	Updates columns of a table.

Uses of DBMS in net.sf.jailer.entitygraph.local

Methods in net.sf.jailer.entitygraph.local with parameters of type DBMS

Modifier and Type	Method	Description
void	LocalEntityGraph.updateEntities(Table table, Set<Column> columns, OutputStreamWriter scriptFileWriter, DBMS targetConfiguration, boolean inSourceSchema, String reason)	Updates columns of a table.

Uses of DBMS in net.sf.jailer.entitygraph.remote

Methods in net.sf.jailer.entitygraph.remote with parameters of type DBMS

Modifier and Type	Method	Description
void	RemoteEntityGraph.updateEntities(Table table, Set<Column> columns, OutputStreamWriter scriptFileWriter, DBMS targetConfiguration, boolean inSourceSchema, String reason)	Updates columns of a table.

Uses of DBMS in net.sf.jailer.importfilter

Methods in net.sf.jailer.importfilter with parameters of type DBMS

Modifier and Type	Method	Description
void	ImportFilterManager.createMappingTables(DBMS configuration, OutputStreamWriter result)	Creates the DDL for the mapping tables.
void	ImportFilterManager.fillAndWriteMappingTables(EntityGraph entityGraph, JobManager jobManager, OutputStreamWriter dmlResultWriter, int numberOfEntities, Session targetSession, DBMS targetDBMSConfiguration)	Inserts the values of columns with non-derived import-filters into the local database and writes the mapping table DML to the given writer.

Uses of DBMS in net.sf.jailer.modelbuilder

Methods in net.sf.jailer.modelbuilder with parameters of type DBMS

Modifier and Type	Method	Description
static void	ModelBuilder.build(DataSource dataSource, DBMS dbms, String schema, StringBuffer warnings, ExecutionContext executionContext)	Builds the data model and writes generated definitions to CSV files.
static void	ModelBuilder.buildAndMerge(DataSource dataSource, DBMS dbms, String schema, StringBuffer warnings, ExecutionContext executionContext)	Builds and merges the data model.
static int	JDBCMetaDataBasedModelElementFinder.filterLength(int length, int precision, String typeName, int type, DBMS dbms, int origLength)	Filters the length attribute of a column in a DBMS specific way.
static int	JDBCMetaDataBasedModelElementFinder.filterPrecision(int length, int precision, String typeName, int type, DBMS dbms, int origLength)	Filters the precision attribute of a column in a DBMS specific way.
static String	JDBCMetaDataBasedModelElementFinder.filterType(String sqlType, int length, String typeName, int type, DBMS dbms, int origLength)	Filters the type attribute of a column in a DBMS specific way.

Uses of DBMS in net.sf.jailer.subsetting

Methods in net.sf.jailer.subsetting with parameters of type DBMS

Modifier and Type	Method	Description
ExportStatistic	SubsettingEngine.export(String whereClause, URL extractionModelURL, String scriptFile, String deleteScriptFileName, DataSource dataSource, DBMS dbms, ScriptFormat scriptFormat, int modelPoolSize)	Exports entities.

Uses of DBMS in net.sf.jailer.util

Methods in net.sf.jailer.util with parameters of type DBMS

Modifier and Type	Method	Description
static String	SqlUtil.columnLabel(Quoting quoting, Session session, DBMS targetDBMSConfiguration, Table table, String columnLabel)	Gets the properly quoted column label for use in a SQL statement.
static int	SqlUtil.getColumnType(DBMS configuration, ResultSet resultSet, ResultSetMetaData resultSetMetaData, int i, Map<Integer,Integer> typeCache)	Gets type of column from result-set.
static String	CellContentConverter.getSmallLob(Object lob, DBMS targetConfiguration, Integer maxBlobLength, Integer maxClobLength)	Gets SQL expression for a C/BLOB for small LOBS.

Constructors in net.sf.jailer.util with parameters of type DBMS

Modifier	Constructor	Description
	CellContentConverter(ResultSetMetaData resultSetMetaData, Session session, DBMS targetConfiguration)	Constructor.