Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/DatabaseType.java
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/Attic/DatabaseType.java,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/DatabaseType.java	12 Oct 2014 13:55:02 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/DatabaseType.java	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -29,6 +29,7 @@
  * required keys are:
  * <ul>
  * <li>patches.create - DDL that creates the patches table</li>
+ * <li>patches.upgrade - DDL that upgrades the patches table from legacy versions of autopatch</li>
  * <li>level.create - SQL that inserts a new patch level record for the system</li>
  * <li>level.read - SQL that selects the current patch level of the system</li>
  * <li>level.update - SQL that updates the current patch level of the system</li>
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/PatchTable.java
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/Attic/PatchTable.java,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/PatchTable.java	12 Oct 2014 13:55:02 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/PatchTable.java	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -15,20 +15,22 @@
 
 package com.tacitknowledge.util.migration.jdbc;
 
-import com.tacitknowledge.util.migration.MigrationException;
-import com.tacitknowledge.util.migration.PatchInfoStore;
-import com.tacitknowledge.util.migration.jdbc.util.SqlUtil;
-import org.apache.commons.logging.Log;
-import org.apache.commons.logging.LogFactory;
-
 import java.sql.Connection;
+import java.sql.DatabaseMetaData;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.util.HashSet;
 import java.util.Set;
 
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
 
+import com.tacitknowledge.util.migration.MigrationException;
+import com.tacitknowledge.util.migration.PatchInfoStore;
+import com.tacitknowledge.util.migration.jdbc.util.SqlUtil;
+
+
 /**
  * Manages interactions with the "patches" table.  The patches table stores
  * the current patch level for a given system, as well as a system-scoped lock
@@ -94,6 +96,7 @@
         Connection conn = null;
         PreparedStatement stmt = null;
         ResultSet rs = null;
+        
         try
         {
             conn = context.getConnection();
@@ -103,6 +106,40 @@
             rs = stmt.executeQuery();
             log.debug("'patches' table already exists.");
             tableExistenceValidated = true;
+            
+            
+            ResultSet alterRs = null;
+            PreparedStatement alterStmt = null;
+            try {
+            	//if we are at this point - we are sure, that patches table exists. It is possible however, that 
+                //table primary key is invalid (as it has changed from legacy versions).
+                DatabaseMetaData databaseMetaData = conn.getMetaData();
+                String patchesTableName = getSql("patches.tablename");
+                alterRs = databaseMetaData.getPrimaryKeys(
+                	    null, null, patchesTableName);
+
+                Set<String> compoundKeyColumns = new HashSet<String>();
+    			while (alterRs.next()) {
+    				String columnName = alterRs.getString(4);
+    				compoundKeyColumns.add(columnName);
+    			}
+                if (compoundKeyColumns.size() != 2) {
+                	log.info("Legacy structure of 'patches' table found. Alter 'patches' table to use compound primary key.");
+                	alterStmt = conn.prepareStatement(getSql("patches.upgrade"));
+                    if (log.isDebugEnabled())
+                    {
+                        log.debug("Altering patches table with SQL '" + getSql("patches.upgrade") + "'");
+                    }
+                	alterStmt.execute();
+                	context.commit();
+                }
+            } catch (SQLException e) {
+            	log.error("SQLException thrown during patches table upgrade.", e);
+            } finally {
+            	SqlUtil.close(null, alterStmt, alterRs);
+            }
+            
+            
         }
         catch (SQLException e)
         {
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/util/SqlUtil.java
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/util/Attic/SqlUtil.java,v
diff -u -r1.1.2.2 -r1.1.2.3
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/util/SqlUtil.java	12 Oct 2014 15:19:45 -0000	1.1.2.2
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/java/com/tacitknowledge/util/migration/jdbc/util/SqlUtil.java	12 Oct 2014 17:10:29 -0000	1.1.2.3
@@ -15,13 +15,18 @@
 
 package com.tacitknowledge.util.migration.jdbc.util;
 
-import org.apache.commons.logging.Log;
-import org.apache.commons.logging.LogFactory;
+import java.sql.Connection;
+import java.sql.Driver;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
 import java.sql.SQLException;
-
-import java.sql.*;
+import java.sql.Statement;
 import java.util.Properties;
+import java.util.Set;
 
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
+
 /**
  * Utility class for dealing with JDBC.
  *
@@ -42,48 +47,43 @@
         // Hidden
     }
 
-    /**
-     * Ensures the given connection, statement, and result are properly closed.
-     *
-     * @param conn the connection to close; may be <code>null</code>
-     * @param stmt the statement to close; may be <code>null</code>
-     * @param rs   the result set to close; may be <code>null</code>
-     */
-    public static void close(Connection conn, Statement stmt, ResultSet rs)
-    {
-        if (rs != null)
+    
+    private static void closeResultSet(ResultSet rs) {
+    	 if (rs != null)
+         {
+             try
+             {
+                 boolean rsIsOpen = true;
+                 try
+                 {
+                     rsIsOpen = !rs.isClosed();
+                 }
+                 catch (AbstractMethodError e)
+                 {
+                     log.debug("AbstractMethodError closing ResultSet.  ResultSet might be a DelegatingResultSet with a badly implemented (i.e. missing) delegation to isClosed().", e);
+                 }
+                 if (rsIsOpen)
+                 {
+                     log.debug("Closing ResultSet: " + rs.toString());
+                     rs.close();
+                 }
+                 else
+                 {
+                     log.debug("ResultSet (" + rs.toString() + ") already closed.");
+                 }
+             }
+             catch (SQLException e)
+             {
+                 log.error("Error closing ResultSet", e);
+             }
+         }
+    }
+    
+    private static void closeStatement(Statement stmt) {
+    	if (stmt != null)
         {
             try
             {
-                boolean rsIsOpen = true;
-                try
-                {
-                    rsIsOpen = !rs.isClosed();
-                }
-                catch (AbstractMethodError e)
-                {
-                    log.debug("AbstractMethodError closing ResultSet.  ResultSet might be a DelegatingResultSet with a badly implemented (i.e. missing) delegation to isClosed().", e);
-                }
-                if (rsIsOpen)
-                {
-                    log.debug("Closing ResultSet: " + rs.toString());
-                    rs.close();
-                }
-                else
-                {
-                    log.debug("ResultSet (" + rs.toString() + ") already closed.");
-                }
-            }
-            catch (SQLException e)
-            {
-                log.error("Error closing ResultSet", e);
-            }
-        }
-
-        if (stmt != null)
-        {
-            try
-            {
                 boolean stmtIsOpen = true;
                 try
                 {
@@ -113,8 +113,10 @@
                 log.error("Error closing Statement", e);
             }
         }
-
-        if (conn != null)
+    }
+    
+    private static void closeConnection(Connection conn) {
+    	if (conn != null)
         {
             try
             {
@@ -143,6 +145,20 @@
             }
         }
     }
+    
+    /**
+     * Ensures the given connection, statement, and result are properly closed.
+     *
+     * @param conn the connection to close; may be <code>null</code>
+     * @param stmt the statement to close; may be <code>null</code>
+     * @param rs   the result set to close; may be <code>null</code>
+     */
+    public static void close(Connection conn, Statement stmt, ResultSet rs)
+    {
+		closeResultSet(rs);
+		closeStatement(stmt);
+		closeConnection(conn);
+	}
 
     /**
      * Established and returns a connection based on the specified parameters.
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/hsqldb.properties
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/Attic/hsqldb.properties,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/hsqldb.properties	12 Oct 2014 13:55:03 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/hsqldb.properties	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -7,6 +7,10 @@
      , patch_in_progress CHAR(1) default 'F' NOT NULL \
      , PRIMARY KEY (system_name, patch_level))
 
+# Alter patches table to use composite primary key.
+patches.upgrade=ALTER TABLE patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);
+patches.tablename=patches
+
 # Validates that a record exists for a given system
 level.create=INSERT INTO patches (system_name, patch_level) VALUES ( ?, 0)
 level.table.exists=SELECT patch_level FROM patches WHERE system_name = ?
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/mysql.properties
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/Attic/mysql.properties,v
diff -u -r1.1.2.2 -r1.1.2.3
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/mysql.properties	12 Oct 2014 14:41:40 -0000	1.1.2.2
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/mysql.properties	12 Oct 2014 17:10:29 -0000	1.1.2.3
@@ -7,6 +7,10 @@
      , patch_in_progress CHAR(1) NOT NULL default 'F' \
      , PRIMARY KEY(system_name, patch_level))
 
+# Alter patches table to use composite primary key.
+patches.upgrade=ALTER TABLE patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);
+patches.tablename=patches
+
 # Validates that a record exists for a given system
 level.create=INSERT INTO patches (system_name, patch_level) VALUES ( ?, 0 )
 level.table.exists=SELECT patch_level FROM patches WHERE system_name = ?
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/oracle.properties
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/Attic/oracle.properties,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/oracle.properties	12 Oct 2014 13:55:03 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/oracle.properties	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -7,6 +7,10 @@
      , patch_in_progress CHAR(1) DEFAULT 'F' NOT NULL\
      , CONSTRAINT tk_patches_pk PRIMARY KEY (system_name, patch_level) )
 
+# Alter patches table to use composite primary key. This query is not validated to work in oracle DBMS
+patches.upgrade=ALTER TABLE tk_patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);
+patches.tablename=tk_patches
+
 # Validates that a record exists for a given system
 level.create=INSERT INTO tk_patches (system_name, patch_level) VALUES ( ?, 0 )
 level.table.exists=SELECT patch_level FROM tk_patches WHERE system_name = ?
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/postgres.properties
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/Attic/postgres.properties,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/postgres.properties	12 Oct 2014 13:55:03 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/postgres.properties	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -7,6 +7,10 @@
      , patch_in_progress CHAR(1) NOT NULL DEFAULT ('F') \
      , PRIMARY KEY (system_name, patch_level))
 
+# Alter patches table to use composite primary key. This query is not validated to work in postgres DBMS
+patches.upgrade=ALTER TABLE patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);
+patches.tablename=patches
+
 # Validates that a record exists for a given system
 level.create=INSERT INTO patches (system_name, patch_level) VALUES ( ?, 0 )
 level.table.exists=SELECT patch_level FROM patches WHERE system_name = ?
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/sqlserver.properties
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/Attic/sqlserver.properties,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/sqlserver.properties	12 Oct 2014 13:55:03 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/sqlserver.properties	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -7,6 +7,10 @@
      , patch_in_progress CHAR(1) default 'F' NOT NULL \
      , PRIMARY KEY(system_name, patch_level))
 
+# Alter patches table to use composite primary key. This query is not validated to work in sqlserver DBMS
+patches.upgrade=ALTER TABLE patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);
+patches.tablename=patches
+
 # Validates that a record exists for a given system
 level.create=INSERT INTO patches (system_name, patch_level) VALUES ( ?, 0)
 level.table.exists=SELECT patch_level FROM patches WHERE system_name = ?
Index: 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/sybase.properties
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/Attic/sybase.properties,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/sybase.properties	12 Oct 2014 13:55:03 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/main/resources/com/tacitknowledge/util/migration/jdbc/sybase.properties	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -6,7 +6,11 @@
                 patch_date DATETIME DEFAULT getdate() NOT NULL,\
                 patch_in_progress CHAR(1) DEFAULT 'F' NOT NULL,\
                 primary key clustered (system_name, patch_level))
-                
+         
+# Alter patches table to use composite primary key. This query is not validated to work in sybase DBMS
+patches.upgrade=ALTER TABLE patches DROP PRIMARY KEY, ADD PRIMARY KEY(system_name, patch_level);
+patches.tablename=patches
+       
 # Validates that a record exists for a given system
 level.create=INSERT INTO patches (system_name, patch_level) VALUES ( ?, 0 )
 level.table.exists=SELECT patch_level FROM patches WHERE system_name = ?
Index: 3rdParty_sources/tacitknowledge/autopatch/src/test/java/com/tacitknowledge/util/migration/jdbc/PatchTableTest.java
===================================================================
RCS file: /usr/local/cvsroot/3rdParty_sources/tacitknowledge/autopatch/src/test/java/com/tacitknowledge/util/migration/jdbc/Attic/PatchTableTest.java,v
diff -u -r1.1.2.1 -r1.1.2.2
--- 3rdParty_sources/tacitknowledge/autopatch/src/test/java/com/tacitknowledge/util/migration/jdbc/PatchTableTest.java	12 Oct 2014 13:54:59 -0000	1.1.2.1
+++ 3rdParty_sources/tacitknowledge/autopatch/src/test/java/com/tacitknowledge/util/migration/jdbc/PatchTableTest.java	12 Oct 2014 17:10:29 -0000	1.1.2.2
@@ -24,6 +24,7 @@
 import com.mockrunner.jdbc.JDBCTestCaseAdapter;
 import com.mockrunner.jdbc.PreparedStatementResultSetHandler;
 import com.mockrunner.mock.jdbc.MockConnection;
+import com.mockrunner.mock.jdbc.MockDatabaseMetaData;
 import com.mockrunner.mock.jdbc.MockResultSet;
 import com.tacitknowledge.util.migration.MigrationException;
 import com.tacitknowledge.util.migration.jdbc.util.ConnectionWrapperDataSource;
@@ -160,6 +161,12 @@
         // Test-specific setup
         handler = conn.getPreparedStatementResultSetHandler();
         MockResultSet rs = handler.createResultSet();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
         handler.prepareGlobalResultSet(rs);
         rs.addRow(new Integer[] {new Integer(13)});
         
@@ -168,10 +175,38 @@
         commonVerifications();
         verifyNotCommitted();
         verifyPreparedStatementParameter(0, 1, "milestone");
+        verifyPreparedStatementNotPresent(table.getSql("patches.upgrade"));
         verifyPreparedStatementNotPresent(table.getSql("patches.create"));
     }
     
     /**
+     * Validates that the system recognizes an existing patches table.
+     * 
+     * @throws Exception if an unexpected error occurs
+     */
+    public void testVerifyAndUpgradePatchesTable() throws Exception
+    {
+        // Test-specific setup
+        handler = conn.getPreparedStatementResultSetHandler();
+        MockResultSet rs = handler.createResultSet();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mdmd.setPrimaryKeys(mrs);
+        handler.prepareGlobalResultSet(rs);
+        rs.addRow(new Integer[] {new Integer(13)});
+        
+        table.createPatchStoreIfNeeded();
+        
+        commonVerifications();
+        verifyCommitted();
+        verifyPreparedStatementParameter(0, 1, "milestone");
+        verifyPreparedStatementPresent(table.getSql("patches.upgrade"));
+        verifyPreparedStatementNotPresent(table.getSql("patches.create"));
+    }
+    
+    /**
      * Validates that <code>getPatchLevel</code> works on an existing system.
      * 
      * @throws Exception if an unexpected error occurs
@@ -180,6 +215,13 @@
     {
         // Test-specific setup
         handler = conn.getPreparedStatementResultSetHandler();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         MockResultSet rs = handler.createResultSet();
         rs.addRow(new Integer[]{new Integer(13)});
         handler.prepareGlobalResultSet(rs);
@@ -190,6 +232,7 @@
         commonVerifications();
         verifyNotCommitted();
         verifyPreparedStatementParameter(1, 1, "milestone");
+        verifyPreparedStatementNotPresent(table.getSql("patches.upgrade"));
         verifyPreparedStatementNotPresent(table.getSql("level.create"));
     }
 
@@ -222,6 +265,13 @@
     public void testUpdatePatchLevel() throws Exception
     {
         handler = conn.getPreparedStatementResultSetHandler();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         MockResultSet rs = handler.createResultSet();
         rs.addRow(new Integer[]{new Integer(12)});
         handler.prepareResultSet(table.getSql("level.read"), rs, new String[]{"milestone"});
@@ -244,6 +294,13 @@
         // Test-specific setup
         // Return a non-empty set in response to the patch lock query
         handler = conn.getPreparedStatementResultSetHandler();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         MockResultSet rs = handler.createResultSet();
         rs.addRow(new String[]{"F"});
         handler.prepareResultSet(table.getSql("lock.read"), rs, new String[]{"milestone", "milestone"});
@@ -263,6 +320,13 @@
         // Test-specific setup
         // Return a non-empty set in response to the patch lock query
         handler = conn.getPreparedStatementResultSetHandler();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         MockResultSet rs = handler.createResultSet();
         rs.addRow(new String[]{"T"});
         handler.prepareResultSet(table.getSql("lock.read"), rs, new String[]{"milestone", "milestone"});
@@ -283,6 +347,13 @@
         // Test-specific setup
         // Return a non-empty set in response to the patch lock query
         handler = conn.getPreparedStatementResultSetHandler();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         handler.prepareUpdateCount(table.getSql("lock.obtain"), 0, new String[] {"milestone", "milestone"});
         
         try
@@ -312,6 +383,13 @@
         // Test-specific setup
         // Return an empty set in response to the patch lock query
         handler = conn.getPreparedStatementResultSetHandler();
+        
+        MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         MockResultSet rs = handler.createResultSet();
         handler.prepareUpdateCount(table.getSql("lock.obtain"), 1, new String[] {"milestone", "milestone"});
         
@@ -384,7 +462,15 @@
     }
 
     public void testPatchRetrievesSetWithPatchesApplied () throws SQLException, MigrationException {
+        
         handler = conn.getPreparedStatementResultSetHandler();
+        
+    	MockDatabaseMetaData mdmd = (MockDatabaseMetaData) conn.getMetaData();
+        MockResultSet mrs = handler.createResultSet();
+        mrs.addRow(new String[]{"", "", "", "system_name"});
+        mrs.addRow(new String[]{"", "", "", "patch_level"});
+        mdmd.setPrimaryKeys(mrs);
+        
         MockResultSet rs = handler.createResultSet();
         rs.addColumn("patch_level", new Object[]{1, 2});
         handler.prepareGlobalResultSet(rs);