[exo-jcr-commits] exo-jcr SVN: r5040 - jcr/branches/1.14.1-GA-CP01/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db.
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();
}