Name

adams.flow.sink.SpreadSheetDbWriter

Synopsis

Transfers a SpreadSheet object into a database.

Additional information

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

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	SpreadSheetDbWriter

  
  
• 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

  
  
• table
  

  The table to write the data to (gets automatically created).

  command-line	-table <java.lang.String>
  default	blah

  
  
• columnNameConversion
  

  How to convert the column headers into SQL table column names.

  command-line	-column-name-conversion <AS_IS|LOWER_CASE|UPPER_CASE>
  default	UPPER_CASE

  
  
• maxStringLength
  

  The maximum length for strings to enforce; can be used as @MAX in the 'stringColumnsSQL' property.

  command-line	-max-string-length <int>
  default	50
  minimum	1

  
  
• stringColumnSQL
  

  The SQL type to use for STRING columns in the CREATE statement; you can use the @MAX placeholder to tie the type to the 'naxStringLength' property; see also: http://en.wikipedia.org/wiki/SQL

  command-line	-string-column-sql <java.lang.String>
  default	VARCHAR(@MAX)

  
  
• batchSize
  

  The size of the batch when inserting the data; can help improve speed of data import.

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