Database (JDBC) [experimental]

This is a reference documentation of the Database (JDBC) [experimental] writer in hale studio. Usually you will not need this reference, as in hale studio the configuration of I/O providers is done via the respective wizards for import and export. Where this reference can come in handy is if you want launch a transformation via the command line.

Configuration parameters

Following are the specific configuration parameters for this writer.

• User name (required)

  The user name for the connection to the database.

  Setting name	jdbc.user

• Password (required)

  The password for the connection to the database.

  Setting name	jdbc.password

• Direct passthrough

  States if instances should be directly passed to the database instead of attempting to assure an order that will avoid any constraint violations for foreign keys.

  Setting name	unordered
  Default value	false
  	By default instances are sorted before inserting them.

The following configuration parameters are shared for all I/O providers.

• Content type

  During import the content type is tried to be auto-detected, for export this is not possible, but I/O providers may have a default content type associated. If an I/O provider only supports one content type, it's usually not necessary to set this parameter. In any case you can override the content type to use/assume using a content type identifier (see the list of supported content types at the bottom of the page).

  Setting name	contentType
  Example value	eu.esdihumboldt.hale.io.jdbc

• Character encoding

  Specifying a character encoding is important especially for the import, so data is interpreted correctly. Not every I/O provider may respect this setting though (e.g. if the encoding is given by the data source).
  Specify a character encoding by its name as recognised by Java.

  Setting name	charset
  Example value	UTF-8

Supported content types

• JDBC (eu.esdihumboldt.hale.io.jdbc)