[Registry-dev] svn commit r16517 - trunk/registry/modules/core/src/main/java/org/wso2/registry/jdbc/dao

[svn at wso2.org]

Author: keith
Date: Mon May  5 02:13:06 2008
New Revision: 16517

Log:

Removing R the handle to the resourse as its causing problems in derdy-10.1.1.0


Modified:
   trunk/registry/modules/core/src/main/java/org/wso2/registry/jdbc/dao/ResourceDAO.java

Modified: trunk/registry/modules/core/src/main/java/org/wso2/registry/jdbc/dao/ResourceDAO.java
==============================================================================
--- trunk/registry/modules/core/src/main/java/org/wso2/registry/jdbc/dao/ResourceDAO.java	(original)
+++ trunk/registry/modules/core/src/main/java/org/wso2/registry/jdbc/dao/ResourceDAO.java	Mon May  5 02:13:06 2008
@@ -798,8 +798,8 @@
         Connection conn = Transaction.getConnection();
 
         try {
-            String sql = "UPDATE RESOURCE R SET R.EQUIVALENT_VERSION=? " +
-                    "WHERE R.RID=(SELECT D.PARENT_RID FROM DEPENDENCY D WHERE D.CHILD_RID=?)";
+            String sql = "UPDATE RESOURCE SET EQUIVALENT_VERSION=? " +
+                    "WHERE RID=(SELECT D.PARENT_RID FROM DEPENDENCY D WHERE D.CHILD_RID=?)";
 
             PreparedStatement ps = conn.prepareStatement(sql);
             ps.setInt(1, equivalentVersion);