• 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. … 7 more files 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. … 3 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 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 DistributedJdbcMigrationLauncherFactory.java was initially added on branch lams2_head_wildfly.

file DistributedJdbcMigrationLauncher.java was initially added on branch lams2_head_wildfly.

file DistributedAutoPatchService.java was initially added on branch lams2_head_wildfly.

file DatabaseType.java was initially added on branch lams2_head_wildfly.

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

file AutoPatchSupport.java was initially added on branch lams2_head_wildfly.

    • -0
    • +0
    ./com/tacitknowledge/util/migration/jdbc/AutoPatchSupport.java
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
    ./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.