Java Doc for DistinctScalarAggregateResultSet.java in  » Database-DBMS » db-derby-10.2 » org » apache » derby » impl » sql » execute » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.impl.sql.execute   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl       org.apache.derby.impl.sql.execute.NoPutResultSetImpl          org.apache.derby.impl.sql.execute.GenericAggregateResultSet             org.apache.derby.impl.sql.execute.ScalarAggregateResultSet                org.apache.derby.impl.sql.execute.DistinctScalarAggregateResultSet DistinctScalarAggregateResultSet class DistinctScalarAggregateResultSet extends ScalarAggregateResultSet (Code) This ResultSet evaluates scalar aggregates where 1 (or more, in the future) of the aggregates are distinct. It will scan the entire source result set and calculate the scalar aggregates when scanning the source during the first call to next(). author:    jerry (broken out from SortResultSet) Constructor Summary   DistinctScalarAggregateResultSet(NoPutResultSet s, boolean isInSortedOrder, int aggregateItem, int orderingItem, Activation a, GeneratedMethod ra, int maxRowSize, int resultSetNumber, boolean singleInputRow, double optimizerEstimatedRowCount, double optimizerEstimatedCost)      Constructor Parameters:   s - input result set Parameters:   isInSortedOrder - true if the source results are in sorted order Parameters:   aggregateItem - indicates the number of theSavedObject off of the PreparedStatement that holds theAggregatorInfoList used by this routine. Method Summary public  void close()      If the result set has been opened, close the open scan. protected  void closeSource()      Close the source of whatever we have been scanning. public  ExecRow getNextRowCore()      Return the next row. public  ExecIndexRow getRowFromResultSet(boolean doClone)      Get a row from the sorter. public  void openCore()      Open the scan. public  void reopenCore()      reopen a scan on the table. Constructor Detail DistinctScalarAggregateResultSet DistinctScalarAggregateResultSet(NoPutResultSet s, boolean isInSortedOrder, int aggregateItem, int orderingItem, Activation a, GeneratedMethod ra, int maxRowSize, int resultSetNumber, boolean singleInputRow, double optimizerEstimatedRowCount, double optimizerEstimatedCost) throws StandardException(Code) Constructor Parameters:   s - input result set Parameters:   isInSortedOrder - true if the source results are in sorted order Parameters:   aggregateItem - indicates the number of theSavedObject off of the PreparedStatement that holds theAggregatorInfoList used by this routine. Parameters:   a - activation Parameters:   ra - generated method to build an emptyoutput row Parameters:   resultSetNumber - The resultSetNumber for this result set exception:   StandardException - Thrown on error Method Detail close public void close() throws StandardException(Code) If the result set has been opened, close the open scan. closeSource protected void closeSource() throws StandardException(Code) Close the source of whatever we have been scanning. exception:   StandardException - thrown on error getNextRowCore public ExecRow getNextRowCore() throws StandardException(Code) Return the next row. If it is a scalar aggregate scan exception:   StandardException - thrown on failure. exception:   StandardException - ResultSetNotOpen thrown if not yet open. the next row in the result getRowFromResultSet public ExecIndexRow getRowFromResultSet(boolean doClone) throws StandardException(Code) Get a row from the sorter. Side effects: sets currentRow. exception:   StandardException - Thrown on error openCore public void openCore() throws StandardException(Code) Open the scan. Load the sorter and prepare to get rows from it. exception:   StandardException - thrown if cursor finished. reopenCore public void reopenCore() throws StandardException(Code) reopen a scan on the table. scan parameters are evaluated at each open, so there is probably some way of altering their values... exception:   StandardException - thrown if cursor finished. Fields inherited from org.apache.derby.impl.sql.execute.ScalarAggregateResultSet protected int countOfRows(Code)(Java Doc) protected boolean isInSortedOrder(Code)(Java Doc) public int rowsInput(Code)(Java Doc) public boolean singleInputRow(Code)(Java Doc) protected ExecIndexRow sortTemplateRow(Code)(Java Doc) protected ExecIndexRow sourceExecIndexRow(Code)(Java Doc) Methods inherited from org.apache.derby.impl.sql.execute.ScalarAggregateResultSet protected void accumulateScalarAggregation(ExecRow inputRow, ExecRow accumulateRow, boolean hasDistinctAggregates) throws StandardException(Code)(Java Doc) public void close() throws StandardException(Code)(Java Doc) public ExecRow getCurrentRow() throws StandardException(Code)(Java Doc) public ExecRow getNextRowCore() throws StandardException(Code)(Java Doc) public ExecIndexRow getRowFromResultSet(boolean doClone) throws StandardException(Code)(Java Doc) public RowLocation getRowLocation() throws StandardException(Code)(Java Doc) public long getTimeSpent(int type)(Code)(Java Doc) public void openCore() throws StandardException(Code)(Java Doc) public void reopenCore() throws StandardException(Code)(Java Doc) Fields inherited from org.apache.derby.impl.sql.execute.GenericAggregateResultSet protected AggregatorInfoList aggInfoList(Code)(Java Doc) protected GenericAggregator[] aggregates(Code)(Java Doc) protected NoPutResultSet originalSource(Code)(Java Doc) protected GeneratedMethod rowAllocator(Code)(Java Doc) public NoPutResultSet source(Code)(Java Doc) Methods inherited from org.apache.derby.impl.sql.execute.GenericAggregateResultSet public void finish() throws StandardException(Code)(Java Doc) final protected ExecIndexRow finishAggregation(ExecIndexRow row) throws StandardException(Code)(Java Doc) final protected GenericAggregator[] getSortAggregators(AggregatorInfoList list, boolean eliminateDistincts, LanguageConnectionContext lcc, NoPutResultSet inputResultSet) throws StandardException(Code)(Java Doc) Fields inherited from org.apache.derby.impl.sql.execute.NoPutResultSetImpl GeneratedMethod checkGM(Code)(Java Doc) protected int[] checkNullCols(Code)(Java Doc) protected ExecRow clonedExecRow(Code)(Java Doc) protected int cncLen(Code)(Java Doc) long heapConglomerate(Code)(Java Doc) protected String indent(Code)(Java Doc) final public int resultSetNumber(Code)(Java Doc) protected int sourceDepth(Code)(Java Doc) protected String subIndent(Code)(Java Doc) protected TargetResultSet targetResultSet(Code)(Java Doc) Methods inherited from org.apache.derby.impl.sql.execute.NoPutResultSetImpl final public void clearCurrentRow()(Code)(Java Doc) protected void clearOrderableCache(Qualifier[][] qualifiers) throws StandardException(Code)(Java Doc) public void close() throws StandardException(Code)(Java Doc) public void closeRowSource()(Code)(Java Doc) public String getCursorName()(Code)(Java Doc) public DataValueDescriptor[] getNextRowFromRowSource() throws StandardException(Code)(Java Doc) public ResultDescription getResultDescription()(Code)(Java Doc) public FormatableBitSet getValidColumns()(Code)(Java Doc) public boolean isForUpdate()(Code)(Java Doc) public void markRowAsDeleted() throws StandardException(Code)(Java Doc) public boolean needsRowLocation()(Code)(Java Doc) public boolean needsToClone()(Code)(Java Doc) public void positionScanAtRowLocation(RowLocation rl) throws StandardException(Code)(Java Doc) public static String printQualifiers(Qualifier[][] qualifiers)(Code)(Java Doc) public int resultSetNumber()(Code)(Java Doc) public void rowLocation(RowLocation rl) throws StandardException(Code)(Java Doc) protected void setCheckConstraints(GeneratedMethod checkGM)(Code)(Java Doc) final public void setCurrentRow(ExecRow row)(Code)(Java Doc) protected void setHeapConglomerate(long heapConglomerate)(Code)(Java Doc) public void setNeedsRowLocation(boolean needsRowLocation)(Code)(Java Doc) public void setTargetResultSet(TargetResultSet trs)(Code)(Java Doc) protected boolean skipRow(ExecRow row) throws StandardException(Code)(Java Doc) protected boolean skipScan(ExecIndexRow startPosition, ExecIndexRow stopPosition) throws StandardException(Code)(Java Doc) public void updateRow(ExecRow row) throws StandardException(Code)(Java Doc) Fields inherited from org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl protected Activation activation(Code)(Java Doc) public long beginTime(Code)(Java Doc) public long closeTime(Code)(Java Doc) ExecRow compactRow(Code)(Java Doc) public long constructorTime(Code)(Java Doc) protected ExecRow currentRow(Code)(Java Doc) protected long endExecutionTime(Code)(Java Doc) protected boolean finished(Code)(Java Doc) protected boolean isOpen(Code)(Java Doc) protected boolean isTopResultSet(Code)(Java Doc) protected LanguageConnectionContext lcc(Code)(Java Doc) public long nextTime(Code)(Java Doc) public int numOpens(Code)(Java Doc) public long openTime(Code)(Java Doc) public double optimizerEstimatedCost(Code)(Java Doc) public double optimizerEstimatedRowCount(Code)(Java Doc) ResultDescription resultDescription(Code)(Java Doc) public int rowsFiltered(Code)(Java Doc) public int rowsSeen(Code)(Java Doc) protected long startExecutionTime(Code)(Java Doc) public NoPutResultSet[] subqueryTrackingArray(Code)(Java Doc) Methods inherited from org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl final protected void addWarning(SQLWarning w)(Code)(Java Doc) protected void attachStatementContext() throws StandardException(Code)(Java Doc) public void checkCancellationFlag() throws StandardException(Code)(Java Doc) public boolean checkRowPosition(int isType) throws StandardException(Code)(Java Doc) public void cleanUp() throws StandardException(Code)(Java Doc) final protected String dumpTimeStats(String indent, String subIndent)(Code)(Java Doc) public void finish() throws StandardException(Code)(Java Doc) final protected void finishAndRTS() throws StandardException(Code)(Java Doc) public ExecRow getAbsoluteRow(int row) throws StandardException(Code)(Java Doc) final public Activation getActivation()(Code)(Java Doc) public ResultSet getAutoGeneratedKeysResultset()(Code)(Java Doc) public Timestamp getBeginExecutionTimestamp()(Code)(Java Doc) protected ExecRow getCompactRow(ExecRow candidate, FormatableBitSet accessedCols, FormatableBitSet otherCols, boolean isKeyed) throws StandardException(Code)(Java Doc) final protected long getCurrentTimeMillis()(Code)(Java Doc) final protected long getElapsedMillis(long beginTime)(Code)(Java Doc) public Timestamp getEndExecutionTimestamp()(Code)(Java Doc) public double getEstimatedRowCount()(Code)(Java Doc) public long getExecuteTime()(Code)(Java Doc) final ExecutionFactory getExecutionFactory()(Code)(Java Doc) public ExecRow getFirstRow() throws StandardException(Code)(Java Doc) final protected LanguageConnectionContext getLanguageConnectionContext()(Code)(Java Doc) public ExecRow getLastRow() throws StandardException(Code)(Java Doc) final public ExecRow getNextRow() throws StandardException(Code)(Java Doc) abstract public ExecRow getNextRowCore() throws StandardException(Code)(Java Doc) public int getPointOfAttachment()(Code)(Java Doc) public ExecRow getPreviousRow() throws StandardException(Code)(Java Doc) public ExecRow getRelativeRow(int row) throws StandardException(Code)(Java Doc) public ResultDescription getResultDescription()(Code)(Java Doc) public int getRowNumber()(Code)(Java Doc) public int getScanIsolationLevel()(Code)(Java Doc) final public NoPutResultSet[] getSubqueryTrackingArray(int numSubqueries)(Code)(Java Doc) final TransactionController getTransactionController()(Code)(Java Doc) final public SQLWarning getWarnings()(Code)(Java Doc) public boolean isClosed()(Code)(Java Doc) public boolean isForUpdate()(Code)(Java Doc) public void markAsTopResultSet()(Code)(Java Doc) final public int modifiedRowCount()(Code)(Java Doc) final public void open() throws StandardException(Code)(Java Doc) abstract public void openCore() throws StandardException(Code)(Java Doc) public void reopenCore() throws StandardException(Code)(Java Doc) public boolean requiresRelocking()(Code)(Java Doc) public int resultSetNumber()(Code)(Java Doc) public boolean returnsRows()(Code)(Java Doc) public ExecRow setAfterLastRow() throws StandardException(Code)(Java Doc) public ExecRow setBeforeFirstRow() throws StandardException(Code)(Java Doc) protected ExecRow setCompactRow(ExecRow candidateRow, ExecRow compactRow)(Code)(Java Doc) final protected void setCompatRow(ExecRow compactRow, Object[] sourceRow)(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)