[exo-jcr-commits] exo-jcr SVN: r627 - jcr/branches/1.12.0-OPT/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/db.

Author: tolusha Date: 2009-11-13 04:53:11 -0500 (Fri, 13 Nov 2009) New Revision: 627 Modified: jcr/branches/1.12.0-OPT/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/db/SingleDbJDBCConnection.java Log: EXOJCR-221: fix SQL statement Modified: jcr/branches/1.12.0-OPT/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/db/SingleDbJDBCConnection.java =================================================================== --- jcr/branches/1.12.0-OPT/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/db/SingleDbJDBCConnection.java 2009-11-13 09:49:57 UTC (rev 626) +++ jcr/branches/1.12.0-OPT/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/db/SingleDbJDBCConnection.java 2009-11-13 09:53:11 UTC (rev 627) @@ -74,7 +74,7 @@ protected PreparedStatement findValueByPropertyIdOrderNumber; protected PreparedStatement findNodesByParentId; - + protected PreparedStatement findNodesCountByParentId; protected PreparedStatement findPropertiesByParentId; @@ -195,8 +195,9 @@ FIND_NODES_BY_PARENTID = "select * from JCR_SITEM" + " where I_CLASS=1 and CONTAINER_NAME=? and PARENT_ID=?" + " order by N_ORDER_NUM"; - FIND_NODES_COUNT_BY_PARENTID = "select count(ID) from JCR_MITEM" + " where I_CLASS=1 and CONTAINER_NAME=? and PARENT_ID=?"; - + FIND_NODES_COUNT_BY_PARENTID = + "select count(ID) from JCR_SITEM" + " where I_CLASS=1 and CONTAINER_NAME=? and PARENT_ID=?"; + FIND_PROPERTIES_BY_PARENTID = "select * from JCR_SITEM" + " where I_CLASS=2 and CONTAINER_NAME=? and PARENT_ID=?" + " order by ID"; @@ -338,7 +339,7 @@ findNodesByParentId.setString(2, parentCid); return findNodesByParentId.executeQuery(); } - + /** * {@inheritDoc} */ @@ -353,7 +354,7 @@ findNodesCountByParentId.setString(1, containerName); findNodesCountByParentId.setString(2, parentCid); return findNodesCountByParentId.executeQuery(); - } + } /** * {@inheritDoc}