Java Doc for BulkTableScanResultSet.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.TableScanResultSet
            org.apache.derby.impl.sql.execute.BulkTableScanResultSet

BulkTableScanResultSet
class BulkTableScanResultSet extends TableScanResultSet implements CursorResultSet(Code)
Read a base table or index in bulk. Most of the work for this method is inherited from TableScanResultSet. This class overrides getNextRowCore (and extends re/openCore) to use a row array and fetch rows from the Store in bulk (using fetchNextGroup).

Since it retrieves rows in bulk, locking is not as is usual -- locks may have already been released on rows as they are returned to the user. Hence, this ResultSet is not suitable for a query running Isolation Level 1, cursor stability.

Note that this code is only accessable from an optimizer override. If it makes sense to have the optimizer select bulk reads, then this should probably be rolled into TableScanResultSet.
author:
   jamie




Constructor Summary
 BulkTableScanResultSet(long conglomId, StaticCompiledOpenConglomInfo scoci, Activation activation, GeneratedMethod resultRowAllocator, int resultSetNumber, GeneratedMethod startKeyGetter, int startSearchOperator, GeneratedMethod stopKeyGetter, int stopSearchOperator, boolean sameStartStopPosition, Qualifier[][] qualifiers, String tableName, String userSuppliedOptimizerOverrides, String indexName, boolean isConstraint, boolean forUpdate, int colRefItem, int indexColItem, int lockMode, boolean tableLocked, int isolationLevel, int rowsPerRead, boolean oneRowScan, double optimizerEstimatedRowCount, double optimizerEstimatedCost)
     Constructor.

Method Summary
protected  booleancanGetInstantaneousLocks()
     Can we get instantaneous locks when getting share row locks at READ COMMITTED.
public  voidclose()
     If the result set has been opened, close the open scan.
public  ExecRowgetNextRowCore()
     Return the next row (if any) from the scan (if open).
public  voidopenCore()
     Open up the result set.
protected  voidopenScanController(TransactionController tc)
    
public  voidreopenCore()
     Reopen the result set.
public  booleanrequiresRelocking()
    


Constructor Detail
BulkTableScanResultSet
BulkTableScanResultSet(long conglomId, StaticCompiledOpenConglomInfo scoci, Activation activation, GeneratedMethod resultRowAllocator, int resultSetNumber, GeneratedMethod startKeyGetter, int startSearchOperator, GeneratedMethod stopKeyGetter, int stopSearchOperator, boolean sameStartStopPosition, Qualifier[][] qualifiers, String tableName, String userSuppliedOptimizerOverrides, String indexName, boolean isConstraint, boolean forUpdate, int colRefItem, int indexColItem, int lockMode, boolean tableLocked, int isolationLevel, int rowsPerRead, boolean oneRowScan, double optimizerEstimatedRowCount, double optimizerEstimatedCost) throws StandardException(Code)
Constructor. Just save off the rowsPerRead argument and pass everything else down to TableScanResultSet
See Also:   org.apache.derby.iapi.sql.execute.ResultSetFactory.getBulkTableScanResultSet
exception:
  StandardException - thrown on failure to open




Method Detail
canGetInstantaneousLocks
protected boolean canGetInstantaneousLocks()(Code)
Can we get instantaneous locks when getting share row locks at READ COMMITTED.



close
public void close() throws StandardException(Code)
If the result set has been opened, close the open scan. Delegate most of the work to TableScanResultSet.
exception:
  StandardException - on error



getNextRowCore
public ExecRow getNextRowCore() throws StandardException(Code)
Return the next row (if any) from the scan (if open). Reload the rowArray as necessary.
exception:
  StandardException - thrown on failure to get next row



openCore
public void openCore() throws StandardException(Code)
Open up the result set. Delegate most work to TableScanResultSet.openCore(). Create a new array with rows for use in fetchNextGroup().
exception:
  StandardException - thrown on failure to open



openScanController
protected void openScanController(TransactionController tc) throws StandardException(Code)
Open the scan controller
Parameters:
  tc - transaction controller will open one if null
exception:
  StandardException - thrown on failure to open



reopenCore
public void reopenCore() throws StandardException(Code)
Reopen the result set. Delegate most work to TableScanResultSet.reopenCore(). Reuse the array of rows.
exception:
  StandardException - thrown on failure to open



requiresRelocking
public boolean requiresRelocking()(Code)

See Also:   NoPutResultSet.requiresRelocking



Fields inherited from org.apache.derby.impl.sql.execute.TableScanResultSet
protected FormatableBitSet accessedCols(Code)(Java Doc)
protected ExecRow candidate(Code)(Java Doc)
public boolean coarserLock(Code)(Java Doc)
protected boolean compareToLastKey(Code)(Java Doc)
protected long conglomId(Code)(Java Doc)
protected boolean currentRowPrescanned(Code)(Java Doc)
protected DynamicCompiledOpenConglomInfo dcoci(Code)(Java Doc)
protected boolean firstScan(Code)(Java Doc)
public boolean forUpdate(Code)(Java Doc)
protected TemporaryRowHolder futureForUpdateRows(Code)(Java Doc)
protected TemporaryRowHolderResultSet futureRowResultSet(Code)(Java Doc)
protected int[] indexCols(Code)(Java Doc)
public String indexName(Code)(Java Doc)
public boolean isConstraint(Code)(Java Doc)
protected boolean isKeyed(Code)(Java Doc)
public int isolationLevel(Code)(Java Doc)
protected ExecRow lastCursorKey(Code)(Java Doc)
public int lockMode(Code)(Java Doc)
public boolean oneRowScan(Code)(Java Doc)
protected Hashtable past2FutureTbl(Code)(Java Doc)
public Qualifier[][] qualifiers(Code)(Java Doc)
protected GeneratedMethod resultRowAllocator(Code)(Java Doc)
public int rowsPerRead(Code)(Java Doc)
protected long rowsThisScan(Code)(Java Doc)
protected boolean runTimeStatisticsOn(Code)(Java Doc)
protected ScanController scanController(Code)(Java Doc)
protected boolean scanControllerOpened(Code)(Java Doc)
protected StaticCompiledOpenConglomInfo scoci(Code)(Java Doc)
protected boolean skipFutureRowHolder(Code)(Java Doc)
protected boolean sourceDrained(Code)(Java Doc)
protected GeneratedMethod startKeyGetter(Code)(Java Doc)
protected ExecIndexRow startPosition(Code)(Java Doc)
public String startPositionString(Code)(Java Doc)
protected int startSearchOperator(Code)(Java Doc)
protected GeneratedMethod stopKeyGetter(Code)(Java Doc)
protected ExecIndexRow stopPosition(Code)(Java Doc)
public String stopPositionString(Code)(Java Doc)
protected int stopSearchOperator(Code)(Java Doc)
public String tableName(Code)(Java Doc)
public String userSuppliedOptimizerOverrides(Code)(Java Doc)

Methods inherited from org.apache.derby.impl.sql.execute.TableScanResultSet
protected boolean canGetInstantaneousLocks()(Code)(Java Doc)
public Object clone()(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 RowLocation getRowLocation() throws StandardException(Code)(Java Doc)
public int getScanIsolationLevel()(Code)(Java Doc)
public Properties getScanProperties()(Code)(Java Doc)
public long getTimeSpent(int type)(Code)(Java Doc)
public boolean isForUpdate()(Code)(Java Doc)
public void openCore() throws StandardException(Code)(Java Doc)
protected void openScanController(TransactionController tc) throws StandardException(Code)(Java Doc)
public void positionScanAtRowLocation(RowLocation rl) throws StandardException(Code)(Java Doc)
public String printStartPosition()(Code)(Java Doc)
public String printStopPosition()(Code)(Java Doc)
public void reopenCore() throws StandardException(Code)(Java Doc)
public boolean requiresRelocking()(Code)(Java Doc)
final protected void setRowCountIfPossible(long rowsThisScan) 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
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.