Name

adams.flow.source.SpreadSheetDbReader

Synopsis

Returns a spreadsheet object generated from an SQL query.
To optimize memory consumption, you can return the result of the query in chunks of a specified size.

Additional information

Flow input/output:
- output: adams.data.spreadsheet.SpreadSheet

Options

• loggingLevel
  

  The logging level for outputting errors and debugging output.

  command-line	-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST>
  default	WARNING
  min-user-mode	Expert

  
  
• name
  

  The name of the actor.

  command-line	-name <java.lang.String>
  default	SpreadSheetDbReader

  
  
• annotations
  

  The annotations to attach to this actor.

  command-line	-annotation <adams.core.base.BaseAnnotation>
  default

  
  
• skip
  

  If set to true, transformation is skipped and the input token is just forwarded as it is.

  command-line	-skip <boolean>
  default	false

  
  
• stopFlowOnError
  

  If set to true, the flow execution at this level gets stopped in case this actor encounters an error; the error gets propagated; useful for critical actors.

  command-line	-stop-flow-on-error <boolean>
  default	false
  min-user-mode	Expert

  
  
• silent
  

  If enabled, then no errors are output in the console; Note: the enclosing actor handler must have this enabled as well.

  command-line	-silent <boolean>
  default	false
  min-user-mode	Expert

  
  
• typeMapper
  

  The type mapper to use for mapping spreadsheet and SQL types.

  command-line	-type-mapper <adams.data.spreadsheet.sql.AbstractTypeMapper>
  default	adams.data.spreadsheet.sql.DefaultTypeMapper

  
  
• query
  

  The SQL query to use for generating the spreadsheet.

  command-line	-query <adams.db.SQLStatement>
  default	select * from blah

  
  
• dataRowType
  

  The type of row to use for the data.

  command-line	-data-row-type <adams.data.spreadsheet.DataRow>
  default	adams.data.spreadsheet.DenseDataRow

  
  
• chunkSize
  

  The maximum number of rows per chunk; using -1 will read put all data into a single spreadsheet object.

  command-line	-chunk-size <int>
  default	-1
  minimum	-1