private Database createDatabase( ManagedDataSource dataSource, Namespace namespace ) throws SQLException, LiquibaseException { final DatabaseConnection conn = new JdbcConnection(dataSource.getConnection()); final Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(conn); final String catalogName = namespace.getString("catalog"); final String schemaName = namespace.getString("schema"); if (database.supportsCatalogs() && catalogName != null) { database.setDefaultCatalogName(catalogName); database.setOutputDefaultCatalog(true); } if (database.supportsSchemas() && schemaName != null) { database.setDefaultSchemaName(schemaName); database.setOutputDefaultSchema(true); } return database; }
database.setDefaultCatalogName(catalogName); database.setOutputDefaultCatalog(true);
database.setDefaultCatalogName(databaseCatalog); database.setLiquibaseCatalogName(databaseCatalog);
database.setDefaultCatalogName(databaseCatalog); database.setLiquibaseCatalogName(databaseCatalog);
database.setDefaultCatalogName(databaseCatalog); database.setLiquibaseCatalogName(databaseCatalog);
database.setDefaultCatalogName(formEngineConfiguration.getDatabaseCatalog()); database.setLiquibaseCatalogName(formEngineConfiguration.getDatabaseCatalog());
private Database createDatabase( ManagedDataSource dataSource, Namespace namespace ) throws SQLException, LiquibaseException { final DatabaseConnection conn = new JdbcConnection(dataSource.getConnection()); final Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(conn); final String catalogName = namespace.getString("catalog"); final String schemaName = namespace.getString("schema"); if (database.supportsCatalogs() && catalogName != null) { database.setDefaultCatalogName(catalogName); database.setOutputDefaultCatalog(true); } if (database.supportsSchemas() && schemaName != null) { database.setDefaultSchemaName(schemaName); database.setOutputDefaultSchema(true); } return database; }
public static void main(String[] args) { try { FormEngine formEngine = FormEngines.getDefaultFormEngine(); DataSource dataSource = formEngine.getFormEngineConfiguration().getDataSource(); DatabaseConnection connection = new JdbcConnection(dataSource.getConnection()); Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(connection); database.setDatabaseChangeLogTableName(FormEngineConfiguration.LIQUIBASE_CHANGELOG_PREFIX + database.getDatabaseChangeLogTableName()); database.setDatabaseChangeLogLockTableName(FormEngineConfiguration.LIQUIBASE_CHANGELOG_PREFIX + database.getDatabaseChangeLogLockTableName()); if (StringUtils.isNotEmpty(formEngine.getFormEngineConfiguration().getDatabaseSchema())) { database.setDefaultSchemaName(formEngine.getFormEngineConfiguration().getDatabaseSchema()); database.setLiquibaseSchemaName(formEngine.getFormEngineConfiguration().getDatabaseSchema()); } if (StringUtils.isNotEmpty(formEngine.getFormEngineConfiguration().getDatabaseCatalog())) { database.setDefaultCatalogName(formEngine.getFormEngineConfiguration().getDatabaseCatalog()); database.setLiquibaseCatalogName(formEngine.getFormEngineConfiguration().getDatabaseCatalog()); } Liquibase liquibase = new Liquibase("org/flowable/form/db/liquibase/flowable-form-db-changelog.xml", new ClassLoaderResourceAccessor(), database); liquibase.dropAll(); liquibase.getDatabase().close(); } catch (Exception e) { e.printStackTrace(); } } }
public static void main(String[] args) { try { ContentEngine contentEngine = ContentEngines.getDefaultContentEngine(); DataSource dataSource = contentEngine.getContentEngineConfiguration().getDataSource(); DatabaseConnection connection = new JdbcConnection(dataSource.getConnection()); Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(connection); database.setDatabaseChangeLogTableName(ContentEngineConfiguration.LIQUIBASE_CHANGELOG_PREFIX + database.getDatabaseChangeLogTableName()); database.setDatabaseChangeLogLockTableName(ContentEngineConfiguration.LIQUIBASE_CHANGELOG_PREFIX + database.getDatabaseChangeLogLockTableName()); if (StringUtils.isNotEmpty(contentEngine.getContentEngineConfiguration().getDatabaseSchema())) { database.setDefaultSchemaName(contentEngine.getContentEngineConfiguration().getDatabaseSchema()); database.setLiquibaseSchemaName(contentEngine.getContentEngineConfiguration().getDatabaseSchema()); } if (StringUtils.isNotEmpty(contentEngine.getContentEngineConfiguration().getDatabaseCatalog())) { database.setDefaultCatalogName(contentEngine.getContentEngineConfiguration().getDatabaseCatalog()); database.setLiquibaseCatalogName(contentEngine.getContentEngineConfiguration().getDatabaseCatalog()); } Liquibase liquibase = new Liquibase("org/flowable/content/db/liquibase/flowable-content-db-changelog.xml", new ClassLoaderResourceAccessor(), database); liquibase.dropAll(); liquibase.getDatabase().close(); } catch (Exception e) { e.printStackTrace(); } } }
public static void main(String[] args) { try { DmnEngine dmnEngine = DmnEngines.getDefaultDmnEngine(); DataSource dataSource = dmnEngine.getDmnEngineConfiguration().getDataSource(); DatabaseConnection connection = new JdbcConnection(dataSource.getConnection()); Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(connection); database.setDatabaseChangeLogTableName(DmnEngineConfiguration.LIQUIBASE_CHANGELOG_PREFIX + database.getDatabaseChangeLogTableName()); database.setDatabaseChangeLogLockTableName(DmnEngineConfiguration.LIQUIBASE_CHANGELOG_PREFIX + database.getDatabaseChangeLogLockTableName()); if (StringUtils.isNotEmpty(dmnEngine.getDmnEngineConfiguration().getDatabaseSchema())) { database.setDefaultSchemaName(dmnEngine.getDmnEngineConfiguration().getDatabaseSchema()); database.setLiquibaseSchemaName(dmnEngine.getDmnEngineConfiguration().getDatabaseSchema()); } if (StringUtils.isNotEmpty(dmnEngine.getDmnEngineConfiguration().getDatabaseCatalog())) { database.setDefaultCatalogName(dmnEngine.getDmnEngineConfiguration().getDatabaseCatalog()); database.setLiquibaseCatalogName(dmnEngine.getDmnEngineConfiguration().getDatabaseCatalog()); } Liquibase liquibase = new Liquibase("org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml", new ClassLoaderResourceAccessor(), database); liquibase.dropAll(); liquibase.getDatabase().close(); } catch (Exception e) { e.printStackTrace(); } } }
private void applyLiquibaseChangelog( SQLDialect dialect ) throws SQLException, LiquibaseException { Liquibase liquibase = liquibaseService.newConnectedLiquibase(); Database db = liquibase.getDatabase(); db.setObjectQuotingStrategy( ObjectQuotingStrategy.QUOTE_ALL_OBJECTS ); try { if( !dialect.equals( SQLDialect.SQLITE ) ) { if( db.supportsSchemas() ) { db.setDefaultSchemaName( schema.getName() ); db.setLiquibaseSchemaName( schema.getName() ); } if( db.supportsCatalogs() ) { db.setDefaultCatalogName( schema.getName() ); db.setLiquibaseCatalogName( schema.getName() ); } } liquibase.getChangeLogParameters().set( TABLE_NAME_LIQUIBASE_PARAMETER, table.getName() ); liquibase.update( new Contexts() ); } finally { db.close(); } }