Author: tolusha Date: 2012-01-19 06:28:20 -0500 (Thu, 19 Jan 2012) New Revision: 5483 Modified: jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2ConnectionFactory.java jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2MultiDbJDBCConnection.java jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2SingleDbJDBCConnection.java Log: EXOJCR-1724: Use lastNodeId parameter in RDBMS reindexing for DB2 database Modified: jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2ConnectionFactory.java =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2ConnectionFactory.java 2012-01-19 10:22:14 UTC (rev 5482) +++ jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2ConnectionFactory.java 2012-01-19 11:28:20 UTC (rev 5483) @@ -133,7 +133,7 @@ @Override public boolean isIDNeededForPaging() { - return false; + return true; } /** Modified: jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2MultiDbJDBCConnection.java =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2MultiDbJDBCConnection.java 2012-01-19 10:22:14 UTC (rev 5482) +++ jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2MultiDbJDBCConnection.java 2012-01-19 11:28:20 UTC (rev 5483) @@ -92,7 +92,7 @@ findNodesAndProperties.clearParameters(); } - findNodesAndProperties.setString(1, lastNodeId); + findNodesAndProperties.setString(1, getInternalId(lastNodeId)); findNodesAndProperties.setInt(2, offset); findNodesAndProperties.setInt(3, limit); Modified: jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2SingleDbJDBCConnection.java =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2SingleDbJDBCConnection.java 2012-01-19 10:22:14 UTC (rev 5482) +++ jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/storage/jdbc/optimisation/db/DB2SingleDbJDBCConnection.java 2012-01-19 11:28:20 UTC (rev 5483) @@ -93,7 +93,7 @@ } findNodesAndProperties.setString(1, containerName); - findNodesAndProperties.setString(2, lastNodeId); + findNodesAndProperties.setString(2, getInternalId(lastNodeId)); findNodesAndProperties.setInt(3, offset); findNodesAndProperties.setInt(4, limit); findNodesAndProperties.setString(5, containerName);