Java Doc for SetOpResultSet.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.SetOpResultSet

SetOpResultSet
class SetOpResultSet extends NoPutResultSetImpl implements CursorResultSet(Code)
Takes the result set produced by an ordered UNION ALL of two tagged result sets and produces the INTERSECT or EXCEPT of the two input result sets. This also projects out the tag, the last column of the input rows.



Constructor Summary
 SetOpResultSet(NoPutResultSet leftSource, NoPutResultSet rightSource, Activation activation, int resultSetNumber, long optimizerEstimatedRowCount, double optimizerEstimatedCost, int opType, boolean all, int intermediateOrderByColumnsSavedObject, int intermediateOrderByDirectionSavedObject)
    

Method Summary
public  voidclose()
     If the result set has been opened, close the currently open source.
public  voidfinish()
    
public  ExecRowgetCurrentRow()
    
public  NoPutResultSetgetLeftSourceInput()
    
public  ExecRowgetNextRowCore()
    
public  intgetOpType()
    
public  intgetResultSetNumber()
    
public  NoPutResultSetgetRightSourceInput()
    
public  RowLocationgetRowLocation()
    
public  intgetRowsReturned()
    
public  intgetRowsSeenLeft()
    
public  intgetRowsSeenRight()
    
public  longgetTimeSpent(int type)
     Return the total amount of time spent in this ResultSet
Parameters:
  type - CURRENT_RESULTSET_ONLY - time spent only in this ResultSetENTIRE_RESULTSET_TREE - time spent in this ResultSet and below.
public  voidopenCore()
     open the first source.


Constructor Detail
SetOpResultSet
SetOpResultSet(NoPutResultSet leftSource, NoPutResultSet rightSource, Activation activation, int resultSetNumber, long optimizerEstimatedRowCount, double optimizerEstimatedCost, int opType, boolean all, int intermediateOrderByColumnsSavedObject, int intermediateOrderByDirectionSavedObject)(Code)




Method Detail
close
public void close() throws StandardException(Code)
If the result set has been opened, close the currently open source.
exception:
  StandardException - thrown on error



finish
public void finish() throws StandardException(Code)



getCurrentRow
public ExecRow getCurrentRow()(Code)



getLeftSourceInput
public NoPutResultSet getLeftSourceInput()(Code)
Return the left source input of this SetOpResultSet the left source input of this SetOpResultSet
See Also:   org.apache.derby.iapi.sql.execute.NoPutResultSet



getNextRowCore
public ExecRow getNextRowCore() throws StandardException(Code)
the next row of the intersect or except, null if there is none
exception:
  StandardException - thrown on failure



getOpType
public int getOpType()(Code)
Return the set operation of this SetOpResultSet the set operation of this ResultSet, the value is either IntersectOrExceptNode.INTERSECT_OP for Intersect operation or IntersectOrExceptNode.EXCEPT_OP for Except operation
See Also:   org.apache.derby.impl.sql.compile.IntersectOrExceptNode



getResultSetNumber
public int getResultSetNumber()(Code)
Return the result set number the result set number



getRightSourceInput
public NoPutResultSet getRightSourceInput()(Code)
Return the right source input of this SetOpResultSet the right source input of this SetOpResultSet
See Also:   org.apache.derby.iapi.sql.execute.NoPutResultSet



getRowLocation
public RowLocation getRowLocation() throws StandardException(Code)

See Also:   CursorResultSet the row location of the current cursor row.
exception:
  StandardException - thrown on failure



getRowsReturned
public int getRowsReturned()(Code)
Return the number of rows returned from the result set the number of rows returned from the result set



getRowsSeenLeft
public int getRowsSeenLeft()(Code)
Return the number of rows seen on the left source input the number of rows seen on the left source input



getRowsSeenRight
public int getRowsSeenRight()(Code)
Return the number of rows seen on the right source input the number of rows seen on the right source input



getTimeSpent
public long getTimeSpent(int type)(Code)
Return the total amount of time spent in this ResultSet
Parameters:
  type - CURRENT_RESULTSET_ONLY - time spent only in this ResultSetENTIRE_RESULTSET_TREE - time spent in this ResultSet and below. long The total amount of time spent (in milliseconds).



openCore
public void openCore() throws StandardException(Code)
open the first source.
exception:
  StandardException - thrown on failure



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)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.