Author: tolusha Date: 2011-10-17 04:57:05 -0400 (Mon, 17 Oct 2011) New Revision: 5040 Modified: jcr/branches/1.14.1-GA-CP01/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/SingleDbJDBCConnection.java Log: EXOJCR-1587: patch from EXOJCR-1586 Modified: jcr/branches/1.14.1-GA-CP01/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/SingleDbJDBCConnection.java =================================================================== --- jcr/branches/1.14.1-GA-CP01/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/SingleDbJDBCConnection.java 2011-10-17 06:30:54 UTC (rev 5039) +++ jcr/branches/1.14.1-GA-CP01/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/SingleDbJDBCConnection.java 2011-10-17 08:57:05 UTC (rev 5040) @@ -209,7 +209,7 @@ + " where P.I_CLASS=2 and P.CONTAINER_NAME=? and V.PROPERTY_ID=P.ID order by J.ID"; FIND_PROPERTY_BY_ID = - "select I.P_TYPE, V.STORAGE_DESC from JCR_SITEM I, JCR_SVALUE V where I.CONTAINER_NAME=? and I.ID = ? and V.PROPERTY_ID = I.ID"; + "select I.P_TYPE, V.STORAGE_DESC from JCR_SITEM I, JCR_SVALUE V where I.ID = ? and V.PROPERTY_ID = I.ID"; DELETE_VALUE_BY_ORDER_NUM = "delete from JCR_SVALUE where PROPERTY_ID=? and ORDER_NUM >= ?"; UPDATE_VALUE = "update JCR_SVALUE set DATA=?, STORAGE_DESC=? where PROPERTY_ID=? and ORDER_NUM=?"; @@ -823,8 +823,7 @@ else findPropertyById.clearParameters(); - findPropertyById.setString(1, containerName); - findPropertyById.setString(2, id); + findPropertyById.setString(1, id); return findPropertyById.executeQuery(); }