Fisheye on lams/3rdParty_sources/tacitknowledge/autopatch/src

lams (lams2_head_wildfly): LDEV-3319: automatically perform 'patches' table upgrade if invalid primary key found....

marek — Sun, 12 Oct 2014 19:10:29 +0200

marek committed lams2_head_wildfly:marek:20141012171029 on branch lams2_head_wildfly in lams

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.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/DatabaseType.java	(-0, +1)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/PatchTable.java	(-6, +43)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/java/.../util/migration/jdbc/util/SqlUtil.java	(-45, +61)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/hsqldb.properties	(-0, +4)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/mysql.properties	(-0, +4)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/oracle.properties	(-0, +4)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/postgres.properties	(-0, +4)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/sqlserver.properties	(-0, +4)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/sybase.properties	(-1, +5)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../util/migration/jdbc/PatchTableTest.java	(-0, +86)	\| History	\| Source	\| Diff

lams (lams2_head_wildfly): LDEV-3319: catch and ignore SQLException thrown when isClosed() condition is checked on Statement. Exemplary stacktrace ...

marek — Sun, 12 Oct 2014 17:19:45 +0200

marek committed lams2_head_wildfly:marek:20141012151945 on branch lams2_head_wildfly in lams

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)

· /3rdParty_sources/tacitknowledge/autopatch/src/main/java/.../util/migration/jdbc/util/SqlUtil.java

(-0, +6)

| History

| Source

| Diff

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

marek — Sun, 12 Oct 2014 16:41:40 +0200

marek committed lams2_head_wildfly:marek:20141012144140 on branch lams2_head_wildfly in lams

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

· /3rdParty_sources/tacitknowledge/autopatch/src/.../util/migration/jdbc/JdbcMigrationLauncherFactory.java	(-1, +1)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/mysql.properties	(-2, +2)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../util/migration/jdbc/DatabaseTypeTest.java	(-1, +1)	\| History	\| Source	\| Diff
· /3rdParty_sources/tacitknowledge/autopatch/src/.../migration/jdbc/WebAppServletContextFactoryTest.java	(-3, +3)	\| History	\| Source	\| Diff

lams (MAIN): file TestMigrationTaskRollback1.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:05 +0200

marek committed MAIN:marek:20141012135505:3 on branch MAIN in lams

file TestMigrationTaskRollback1.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/.../rollback/migrationtasks/TestMigrationTaskRollback1.java

(-0, +0)

| History

| Source

lams (MAIN): file MockBuilder.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:05 +0200

marek committed MAIN:marek:20141012135505:2 on branch MAIN in lams

file MockBuilder.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../util/migration/builders/MockBuilder.java

(-0, +0)

| History

| Source

lams (MAIN): file patch00003-rollback_patch03.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:9 on branch MAIN in lams

file patch00003-rollback_patch03.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/.../batch2/patch00003-rollback_patch03.sql

(-0, +0)

| History

| Source

lams (MAIN): file patch00002_patch02.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:8 on branch MAIN in lams

file patch00002_patch02.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../migration/inttest-tasks/core/patch00002_patch02.sql	(-0, +0)	\| History	\| Source
· /3rdParty_sources/tacitknowledge/autopatch/src/.../missingpatchstrategy/batch2/patch00002_patch02.sql	(-0, +0)	\| History	\| Source

lams (MAIN): file patch00002-rollback_patch02.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:7 on branch MAIN in lams

file patch00002-rollback_patch02.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/.../batch2/patch00002-rollback_patch02.sql

(-0, +0)

| History

| Source

lams (MAIN): file WhinyMigrationListener.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:6 on branch MAIN in lams

file WhinyMigrationListener.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../util/migration/listeners/WhinyMigrationListener.java

(-0, +0)

| History

| Source

lams (MAIN): file TestListener2.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:20 on branch MAIN in lams

file TestListener2.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../util/migration/test/listeners/TestListener2.java

(-0, +0)

| History

| Source

lams (MAIN): file TestListener1.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:19 on branch MAIN in lams

file TestListener1.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../util/migration/test/listeners/TestListener1.java

(-0, +0)

| History

| Source

lams (MAIN): file TestPostMigrationTask2.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:18 on branch MAIN in lams

file TestPostMigrationTask2.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../migration/tasks/post/TestPostMigrationTask2.java

(-0, +0)

| History

| Source

lams (MAIN): file TestPostMigrationTask1.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:17 on branch MAIN in lams

file TestPostMigrationTask1.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../migration/tasks/post/TestPostMigrationTask1.java

(-0, +0)

| History

| Source

lams (MAIN): file BaseTestMigrationTask.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:16 on branch MAIN in lams

file BaseTestMigrationTask.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/test/.../util/migration/tasks/BaseTestMigrationTask.java

(-0, +0)

| History

| Source

lams (MAIN): file patch00004_insert_into_race_3.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:15 on branch MAIN in lams

file patch00004_insert_into_race_3.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../inttest-tasks/race/patch00004_insert_into_race_3.sql

(-0, +0)

| History

| Source

lams (MAIN): file patch00003_insert_into_race_2.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:14 on branch MAIN in lams

file patch00003_insert_into_race_2.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../inttest-tasks/race/patch00003_insert_into_race_2.sql

(-0, +0)

| History

| Source

lams (MAIN): file patch00002_insert_into_race.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:13 on branch MAIN in lams

file patch00002_insert_into_race.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../inttest-tasks/race/patch00002_insert_into_race.sql

(-0, +0)

| History

| Source

lams (MAIN): file patch00001_create_race_table.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:12 on branch MAIN in lams

file patch00001_create_race_table.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../inttest-tasks/race/patch00001_create_race_table.sql

(-0, +0)

| History

| Source

lams (MAIN): file patch00001_patch01.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:11 on branch MAIN in lams

file patch00001_patch01.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../missingpatchstrategy/batch1/patch00001_patch01.sql	(-0, +0)	\| History	\| Source
· /3rdParty_sources/tacitknowledge/autopatch/src/.../migration/inttest-tasks/order/patch00001_patch01.sql	(-0, +0)	\| History	\| Source

lams (MAIN): file patch00003_patch03.sql was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:04 +0200

marek committed MAIN:marek:20141012135504:10 on branch MAIN in lams

file patch00003_patch03.sql was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../missingpatchstrategy/batch2/patch00003_patch03.sql	(-0, +0)	\| History	\| Source
· /3rdParty_sources/tacitknowledge/autopatch/src/.../migration/inttest-tasks/order/patch00003_patch03.sql	(-0, +0)	\| History	\| Source

lams (MAIN): file TestMigrationTaskInstantiationException.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:20 on branch MAIN in lams

file TestMigrationTaskInstantiationException.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/.../instantiation/TestMigrationTaskInstantiationException.java

(-0, +0)

| History

| Source

lams (MAIN): file sybase.properties was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:19 on branch MAIN in lams

file sybase.properties was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/sybase.properties

(-0, +0)

| History

| Source

lams (MAIN): file sqlserver.properties was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:18 on branch MAIN in lams

file sqlserver.properties was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/sqlserver.properties

(-0, +0)

| History

| Source

lams (MAIN): file postgres.properties was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:17 on branch MAIN in lams

file postgres.properties was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/postgres.properties

(-0, +0)

| History

| Source

lams (MAIN): file oracle.properties was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:16 on branch MAIN in lams

file oracle.properties was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/oracle.properties

(-0, +0)

| History

| Source

lams (MAIN): file mysql.properties was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:15 on branch MAIN in lams

file mysql.properties was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/mysql.properties

(-0, +0)

| History

| Source

lams (MAIN): file hsqldb.properties was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:14 on branch MAIN in lams

file hsqldb.properties was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../util/migration/jdbc/hsqldb.properties

(-0, +0)

| History

| Source

lams (MAIN): file FlatXmlDataSetTaskSource.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:13 on branch MAIN in lams

file FlatXmlDataSetTaskSource.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../migration/jdbc/loader/FlatXmlDataSetTaskSource.java

(-0, +0)

| History

| Source

lams (MAIN): file FlatXmlDataSetMigrationTask.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:12 on branch MAIN in lams

file FlatXmlDataSetMigrationTask.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/.../migration/jdbc/loader/FlatXmlDataSetMigrationTask.java

(-0, +0)

| History

| Source

lams (MAIN): file FileLoadingUtility.java was initially added on branch lams2_head_wildfly.

marek — Sun, 12 Oct 2014 15:55:03 +0200

marek committed MAIN:marek:20141012135503:11 on branch MAIN in lams

file FileLoadingUtility.java was initially added on branch lams2_head_wildfly.

· /3rdParty_sources/tacitknowledge/autopatch/src/main/.../migration/jdbc/loader/FileLoadingUtility.java

(-0, +0)

| History

| Source