Name

adams.flow.transformer.BulkSampleDataDbWriter

Synopsis

Writes sample data to the database and outputs whether the operation was successful.

Additional information

Flow input/output:
- input: adams.data.sampledata.SampleData[], adams.data.spectrum.Spectrum[]
- output: java.lang.Boolean

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	BulkSampleDataDbWriter

  
  
• 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

  
  
• dataTypes
  

  The data types to import.

  command-line	-data-type <S|N|B|U> [-data-type ...]
  default

  
  
• skipFields
  

  If enabled, the supplied regular expression is used for identifying fields to skip (name + data type, e.g., 'blah[N]').

  command-line	-skip-fields <boolean>
  default	false

  
  
• skipFieldsRegExp
  

  The regular expression for identifying fields to skip (if enabled).

  command-line	-skip-fields-regexp <adams.core.base.BaseRegExp>
  default	(Parent ID|Sample ID|Sample Type|Format|Insert Timestamp|Instrument|Source).*
  more	https://docs.oracle.com/javase/tutorial/essential/regex/
  	https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html

  
  
• batchSize
  

  The batch size to use for the bulk operation.

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

  
  
• autoCommit
  

  If disabled, auto-commit gets turned off for the bulk update, which may impact other transactions; use with caution.

  command-line	-auto-commit <boolean>
  default	true

  
  
• newConnection
  

  If enabled, a new database connection is opened (and then closed) just for this operation; use this when turning off auto-commit.

  command-line	-new-connection <boolean>
  default	false