/** * PUBLIC: * Set the fetchSize setting that this query will set on the JDBC Statement * NB - a value of zero means that no call to statement.setFetchSize() will be made. */ public void setFetchSize(int fetchSize) { if ( isPrepared() && this.getCall()!=null) { getCall().setResultSetFetchSize(fetchSize); } this.fetchSize = fetchSize; }
/** * PUBLIC: * Set the fetchSize setting that this query will set on the JDBC Statement * NB - a value of zero means that no call to statement.setFetchSize() will be made. */ public void setFetchSize(int fetchSize) { if ( isPrepared() && this.getCall()!=null) { getCall().setResultSetFetchSize(fetchSize); } this.fetchSize = fetchSize; }
/** * Pre-build configure the SQL call. */ public void prepareCursorSelectAllRows() throws QueryException { getCall().returnCursor(); ContainerPolicy cp; DatabaseQuery query = getQuery(); if (query.isReadAllQuery()) { cp = ((ReadAllQuery)query).getContainerPolicy(); } else { cp = ((DataReadQuery)query).getContainerPolicy(); } if (cp.isScrollableCursorPolicy()) { ScrollableCursorPolicy scp = (ScrollableCursorPolicy)cp; DatabaseCall call = getDatabaseCall(); call.setIsResultSetScrollable(true); call.setResultSetType(scp.getResultSetType()); call.setResultSetConcurrency(scp.getResultSetConcurrency()); // Only set the fetch size to be the page size, if the fetch size was not set on the query. if (((ReadQuery)getQuery()).getFetchSize() == 0) { call.setResultSetFetchSize(scp.getPageSize()); } } if (getQuery().isReportQuery()){ prepareReportQueryItems(); } prepareCall(); }
call.setResultSetFetchSize(readQuery.getFetchSize()); call.setResultSetFetchSize(((ReadQuery)query).getFetchSize());
/** * Pre-build configure the SQL call. */ public void prepareCursorSelectAllRows() throws QueryException { getCall().returnCursor(); ContainerPolicy cp; DatabaseQuery query = getQuery(); if (query.isReadAllQuery()) { cp = ((ReadAllQuery)query).getContainerPolicy(); } else { cp = ((DataReadQuery)query).getContainerPolicy(); } if (cp.isScrollableCursorPolicy()) { ScrollableCursorPolicy scp = (ScrollableCursorPolicy)cp; DatabaseCall call = getDatabaseCall(); call.setIsResultSetScrollable(true); call.setResultSetType(scp.getResultSetType()); call.setResultSetConcurrency(scp.getResultSetConcurrency()); // Only set the fetch size to be the page size, if the fetch size was not set on the query. if (((ReadQuery)getQuery()).getFetchSize() == 0) { call.setResultSetFetchSize(scp.getPageSize()); } } if (getQuery().isReportQuery()){ prepareReportQueryItems(); } prepareCall(); }
/** * Pre-build configure the SQL call. */ public void prepareCursorSelectAllRows() throws QueryException { getCall().returnCursor(); ContainerPolicy cp; DatabaseQuery query = getQuery(); if (query.isReadAllQuery()) { cp = ((ReadAllQuery)query).getContainerPolicy(); } else { cp = ((DataReadQuery)query).getContainerPolicy(); } if (cp.isScrollableCursorPolicy()) { ScrollableCursorPolicy scp = (ScrollableCursorPolicy)cp; DatabaseCall call = getDatabaseCall(); call.setIsResultSetScrollable(true); call.setResultSetType(scp.getResultSetType()); call.setResultSetConcurrency(scp.getResultSetConcurrency()); // Only set the fetch size to be the page size, if the fetch size was not set on the query. if (((ReadQuery)getQuery()).getFetchSize() == 0) { call.setResultSetFetchSize(scp.getPageSize()); } } if (getQuery().isReportQuery()){ prepareReportQueryItems(); } prepareCall(); }
call.setMaxRows(readQuery.getMaxRows()); call.setResultSetFetchSize(readQuery.getFetchSize());
call.setMaxRows(readQuery.getMaxRows()); call.setResultSetFetchSize(readQuery.getFetchSize());