Package liquibase.database.jvm

Examples of liquibase.database.jvm.JdbcConnection

170
171
172
173
174
175
176
177
178
179
180
        export.execute(true, true, false, false);

        Database hibernateDatabase = new HibernateSpringDatabase();
        hibernateDatabase.setDefaultSchemaName("PUBLIC");
        hibernateDatabase.setDefaultCatalogName("TESTDB");
        hibernateDatabase.setConnection(new JdbcConnection(new HibernateConnection("hibernate:spring:" + PACKAGES + "?dialect="
                + HSQLDialect.class.getName()
                + "&hibernate.enhanced_id=" + (enhancedId ? "true" : "false"))));

        Liquibase liquibase = new Liquibase((String) null, new ClassLoaderResourceAccessor(), database);
        DiffResult diffResult = liquibase.diff(hibernateDatabase, database, compareControl);
View Full Code Here
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
        Liquibase liquibase = new Liquibase((String) null, new ClassLoaderResourceAccessor(), database);

        Database hibernateDatabase = new HibernateSpringDatabase();
        hibernateDatabase.setDefaultSchemaName("PUBLIC");
        hibernateDatabase.setDefaultCatalogName("TESTDB");
        hibernateDatabase.setConnection(new JdbcConnection(new HibernateConnection("hibernate:spring:" + PACKAGES + "?dialect="
                + HSQLDialect.class.getName()
                + "&hibernate.enhanced_id=" + (enhancedId ? "true" : "false"))));

        DiffResult diffResult = liquibase.diff(hibernateDatabase, database, compareControl);

        assertTrue(diffResult.getMissingObjects().size() > 0);

        File outFile = File.createTempFile("lb-test", ".xml");
        OutputStream outChangeLog = new FileOutputStream(outFile);
        String changeLogString = toChangeLog(diffResult);
        outChangeLog.write(changeLogString.getBytes("UTF-8"));
        outChangeLog.close();

        log.info("Changelog:\n" + changeLogString);

        liquibase = new Liquibase(outFile.toString(), new FileSystemResourceAccessor(), database);
        StringWriter stringWriter = new StringWriter();
        liquibase.update((String) null, stringWriter);
        log.info(stringWriter.toString());
        liquibase.update((String) null);

        long currentTimeMillis = System.currentTimeMillis();
        Connection connection2 = DriverManager.getConnection("jdbc:hsqldb:mem:TESTDB2" + currentTimeMillis, "SA", "");
        Database database2 = new HsqlDatabase();
        database2.setConnection(new JdbcConnection(connection2));

        Configuration cfg = createSpringPackageScanningConfiguration(enhancedId);
        cfg.setProperty("hibernate.connection.url", "jdbc:hsqldb:mem:TESTDB2" + currentTimeMillis);

        SchemaUpdate update = new SchemaUpdate(cfg);
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
    Connection connection = null;
        Database database = null;
    String name = "unknown";
    try {
      connection = getDataSource().getConnection();
      database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(connection));
      name = database.getDatabaseProductName();
    } catch (SQLException e) {
      throw new DatabaseException(e);
    } finally {
            if (database != null) {
View Full Code Here
370
371
372
373
374
375
376
377
378
379
380
   * @param c
   * @return a Database implementation retrieved from the {@link DatabaseFactory}.
   * @throws DatabaseException
   */
  protected Database createDatabase(Connection c) throws DatabaseException {
    Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(c));
    if (StringUtils.trimToNull(this.defaultSchema) != null) {
      database.setDefaultSchemaName(this.defaultSchema);
    }
    return database;
  }
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
     * @param c
     * @return a Database implementation retrieved from the {@link liquibase.database.DatabaseFactory}.
     * @throws DatabaseException
     */
    protected Database createDatabase(Connection c) throws DatabaseException {
        Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(c));
        if (config.getDefaultSchema() != null) {
            database.setDefaultSchemaName(config.getDefaultSchema());
        }
        return database;
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
        assertEquals("myschema", database.getDefaultSchemaName());
    }
   
    private Database getADatabaseWithCollation( final String collation ) throws DatabaseException, SQLException {
    Database database = getDatabase();
    JdbcConnection connection = createMock(JdbcConnection.class);
    expect(connection.getConnectionUserName()).andReturn("user").anyTimes();
    expect(connection.getURL()).andReturn("URL").anyTimes();
    expect(connection.getAutoCommit()).andReturn(getDatabase().getAutoCommitMode()).anyTimes();

    Connection sqlConnection = createMock(Connection.class);
    Statement statement = createMock(Statement.class);
    ResultSet resultSet = createMock(ResultSet.class);
    ResultSetMetaData metadata = createMock(ResultSetMetaData.class);

    expect(connection.getUnderlyingConnection()).andReturn(sqlConnection).anyTimes();
    expect( sqlConnection.createStatement()).andReturn(statement);
    expect( statement.executeQuery("SELECT CONVERT(varchar(100), SERVERPROPERTY('COLLATION'))")).andReturn(resultSet);
    expect( resultSet.next() ).andReturn(true);
    expect( resultSet.getMetaData() ).andReturn(metadata);
    expect( metadata.getColumnCount() ).andReturn(1);
    expect( resultSet.getString(1)).andReturn(collation);
    expect( resultSet.next() ).andReturn(false);

    connection.attached(database);
    replay(connection, sqlConnection, statement, resultSet, metadata);
    database.setConnection(connection);
    return database;
    }
View Full Code Here
45
46
47
48
49
50
51
52
53
54
    }


    @Test
    public void testSpringPackageScanningMustHaveItemClassMapping() throws DatabaseException {
        conn = new JdbcConnection(new HibernateConnection("hibernate:spring:com.example.ejb3.auction?dialect=" + HSQLDialect.class.getName()));
        db.setConnection(conn);
        assertNotNull(db.getConfiguration().getClassMapping(Bid.class.getName()));
        assertNotNull(db.getConfiguration().getClassMapping(BuyNow.class.getName()));
    }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    private static final String TEST_DATABASES_PROPERTY = "test.databases";
    private ResourceAccessor resourceAccessor;

    private DatabaseConnection openConnection(final String url) throws Exception {
        if (connectionsAttempted.containsKey(url)) {
            JdbcConnection connection = (JdbcConnection) connectionsByUrl.get(url);
            if (connection == null) {
                return null;
            } else if (connection.getUnderlyingConnection().isClosed()){
                connectionsByUrl.put(url, openDatabaseConnection(url));
            }
            return connectionsByUrl.get(url);
        }
        connectionsAttempted.put(url, Boolean.TRUE);
View Full Code Here
173
174
175
176
177
178
179
        }
        if (connection == null) {
            throw new DatabaseException("Connection could not be created to " + url + " with driver " + driver.getClass().getName() + ".  Possibly the wrong driver for the given database URL");
        }

        return new JdbcConnection(connection);
    }
View Full Code Here
TOP

Related Classes of liquibase.database.jvm.JdbcConnection

  • ch.inftec.ju.testing.db.DbSchemaUtil
  • ch.inftec.ju.testing.db.LiquibaseDbUnitChange
  • com.aceevo.ursus.db.liquibase.LiquibaseServiceImpl
  • com.commafeed.backend.service.StartupService
  • com.hascode.tutorial.setup.InitializerBean
  • io.dropwizard.migrations.CloseableLiquibase
  • liquibase.database.core.MSSQLDatabaseTest
  • liquibase.database.DatabaseFactory
  • liquibase.ext.hibernate.database.HibernateClassicDatabaseTest
  • liquibase.ext.hibernate.database.HibernateSpringDatabaseTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.