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

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL 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 .JoinResultSet

org.apache.derby.impl.sql.execute .NestedLoopJoinResultSet

org.apache.derby.impl.sql.execute .NestedLoopLeftOuterJoinResultSet

All known Subclasses:   org.apache.derby.impl.sql.execute .HashLeftOuterJoinResultSet,
NestedLoopLeftOuterJoinResultSet
class NestedLoopLeftOuterJoinResultSet extends NestedLoopJoinResultSet (Code)
Takes 2 NoPutResultSets and a join filter and returns the join's rows satisfying the filter as a result set plus the rows from the left joined with a null row from the right when there is no matching row in the right result set.

Field Summary
public int emptyRightRowsReturned

protected GeneratedMethod emptyRowFun


Constructor Summary
NestedLoopLeftOuterJoinResultSet(NoPutResultSet leftResultSet, int leftNumCols, NoPutResultSet rightResultSet, int rightNumCols, Activation activation, GeneratedMethod restriction, int resultSetNumber, GeneratedMethod emptyRowFun, boolean wasRightOuterJoin, boolean oneRowRightSide, boolean notExistsRightSide, double optimizerEstimatedRowCount, double optimizerEstimatedCost, String userSuppliedOptimizerOverrides)


Method Summary
void clearScanState()
     Clear any private state that changes during scans.
protected void getMergedRow(ExecRow leftRow, ExecRow rightRow)

public ExecRow getNextRowCore()
     Return the requested values computed from the next row (if any) for which the restriction evaluates to true.

Field Detail
emptyRightRowsReturned
public int emptyRightRowsReturned(Code)

emptyRowFun
protected GeneratedMethod emptyRowFun(Code)

Constructor Detail
NestedLoopLeftOuterJoinResultSet
NestedLoopLeftOuterJoinResultSet(NoPutResultSet leftResultSet, int leftNumCols, NoPutResultSet rightResultSet, int rightNumCols, Activation activation, GeneratedMethod restriction, int resultSetNumber, GeneratedMethod emptyRowFun, boolean wasRightOuterJoin, boolean oneRowRightSide, boolean notExistsRightSide, double optimizerEstimatedRowCount, double optimizerEstimatedCost, String userSuppliedOptimizerOverrides)(Code)

Method Detail
clearScanState
void clearScanState()(Code)
Clear any private state that changes during scans. This includes things like the last row seen, etc. THis does not include immutable things that are typically set up in the constructor.
This method is called on open()/close() and reopen()
WARNING: this should be implemented in every sub class and it should always call super.clearScanState().

getMergedRow
protected void getMergedRow(ExecRow leftRow, ExecRow rightRow) throws StandardException(Code)

getNextRowCore
public ExecRow getNextRowCore() throws StandardException(Code)
Return the requested values computed from the next row (if any) for which the restriction evaluates to true.
restriction parameters are evaluated for each row.
exception:
  StandardException - Thrown on error
exception:
  StandardException - ResultSetNotOpen thrown if closed the next row in the join result

Methods inherited from org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet
void clearScanState()(Code)(Java Doc)
public void close() throws StandardException(Code)(Java Doc)
public ExecRow getNextRowCore() throws StandardException(Code)(Java Doc)
public long getTimeSpent(int type)(Code)(Java Doc)

Fields inherited from org.apache.derby.impl.sql.execute.JoinResultSet
protected boolean isRightOpen(Code)(Java Doc)
protected int leftNumCols(Code)(Java Doc)
public NoPutResultSet leftResultSet(Code)(Java Doc)
protected ExecRow leftRow(Code)(Java Doc)
protected ExecRow mergedRow(Code)(Java Doc)
public boolean notExistsRightSide(Code)(Java Doc)
public boolean oneRowRightSide(Code)(Java Doc)
protected GeneratedMethod restriction(Code)(Java Doc)
public long restrictionTime(Code)(Java Doc)
protected int rightNumCols(Code)(Java Doc)
public NoPutResultSet rightResultSet(Code)(Java Doc)
protected ExecRow rightRow(Code)(Java Doc)
public int rowsReturned(Code)(Java Doc)
public int rowsSeenLeft(Code)(Java Doc)
public int rowsSeenRight(Code)(Java Doc)
String userSuppliedOptimizerOverrides(Code)(Java Doc)

Methods inherited from org.apache.derby.impl.sql.execute.JoinResultSet
void clearScanState()(Code)(Java Doc)
public void close() throws StandardException(Code)(Java Doc)
protected void closeRight() throws StandardException(Code)(Java Doc)
public void finish() throws StandardException(Code)(Java Doc)
public ExecRow getCurrentRow()(Code)(Java Doc)
public RowLocation getRowLocation()(Code)(Java Doc)
public void openCore() throws StandardException(Code)(Java Doc)
protected void openRight() throws StandardException(Code)(Java Doc)
public void reopenCore() 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)

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.