• last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
LDEV-3319: automatically perform 'patches' table upgrade if invalid primary key found.

There is a difference in 'patches' table structure in legacy autopatch and autopatch-1.4.2 version. In new version, primary key is compound and built from 'system_name' and 'patch_level' columns. There was however no validation and upgrade process present to alter primary key. Introduce such mechanism with this commit. If 'patches' table is present, but connection metadata reports single column primary key - 'alter table' query is executed (for MySQL: ALTER TABLE patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);)

JUnit tests of autopatch component were updated.

  1. … 1 more file in changeset.
LDEV-3319: catch and ignore SQLException thrown when isClosed() condition is checked on Statement. Exemplary stacktrace below.

2014-10-10 20:21:35,092 ERROR [com.tacitknowledge.util.migration.jdbc.util.SqlUtil] (MSC service thread 1-6) Error closing Statement: java.sql.SQLException: The statement is closed.

at org.jboss.jca.adapters.jdbc.WrappedStatement.checkState(WrappedStatement.java:1324)

at org.jboss.jca.adapters.jdbc.WrappedStatement.getUnderlyingStatement(WrappedStatement.java:1239)

at org.jboss.jca.adapters.jdbc.WrappedStatement.getWrappedObject(WrappedStatement.java:1255)

at org.jboss.jca.adapters.jdbc.WrappedStatement.isClosed(WrappedStatement.java:1159)

at com.tacitknowledge.util.migration.jdbc.util.SqlUtil.close(SqlUtil.java:89)

LDEV-3319: Record changes made by jliew (http://code.lamsfoundation.org/fisheye/browse/otherlams/autopatch) on top of autopatch-1.4.2-lams version.

  1. … 2 more files in changeset.
file DelimitedFileLoader.java was initially added on branch lams2_head_wildfly.

file JdbcMigrationContext.java was initially added on branch lams2_head_wildfly.

file sybase.properties was initially added on branch lams2_head_wildfly.

file sqlserver.properties was initially added on branch lams2_head_wildfly.

file postgres.properties was initially added on branch lams2_head_wildfly.

file oracle.properties was initially added on branch lams2_head_wildfly.

file mysql.properties was initially added on branch lams2_head_wildfly.

file hsqldb.properties was initially added on branch lams2_head_wildfly.

file FlatXmlDataSetTaskSource.java was initially added on branch lams2_head_wildfly.

file FlatXmlDataSetMigrationTask.java was initially added on branch lams2_head_wildfly.

file FileLoadingUtility.java was initially added on branch lams2_head_wildfly.

file ExcelFileLoader.java was initially added on branch lams2_head_wildfly.

file DistributedMigrationTableUnlock.java was initially added on branch lams2_head_wildfly.

file DistributedMigrationInformation.java was initially added on branch lams2_head_wildfly.

file WebAppMigrationLauncher.java was initially added on branch lams2_head_wildfly.

file WebAppJNDIMigrationLauncher.java was initially added on branch lams2_head_wildfly.

file StandaloneMigrationLauncher.java was initially added on branch lams2_head_wildfly.

file SqlScriptMigrationTaskSource.java was initially added on branch lams2_head_wildfly.

file SqlScriptMigrationTask.java was initially added on branch lams2_head_wildfly.

file SqlLoadMigrationTask.java was initially added on branch lams2_head_wildfly.

file PatchTable.java was initially added on branch lams2_head_wildfly.

    • -0
    • +0
    ./java/com/tacitknowledge/util/migration/jdbc/PatchTable.java
file MigrationTableUnlock.java was initially added on branch lams2_head_wildfly.

file MigrationInformation.java was initially added on branch lams2_head_wildfly.

file JdbcMigrationLauncherFactoryLoader.java was initially added on branch lams2_head_wildfly.

file JdbcMigrationLauncherFactory.java was initially added on branch lams2_head_wildfly.

file JdbcMigrationLauncher.java was initially added on branch lams2_head_wildfly.

file DistributedStandaloneMigrationLauncher.java was initially added on branch lams2_head_wildfly.