User Guide : Map Connectors : Source and Target Map Connectors : Derby
 
Share this page                  
Derby
This is an add-on connector and is not included in the default installation of Actian DataConnect Studio IDE. The connector is available at esd.actian.com.
This connector allows users to retrieve, insert, update, and delete data from Derby 10.4.2.0.
Derby Versions Supported
This connector supports the Derby 10.
Properties
You can set the following source (S) and target (T) properties.
Property
S/T
Description
Batch Response
T
Destination of the batch response file.
Batch Size
S
Optional. Number of source records the connector caches before processing them in a map. Default is zero.
Additional Properties
ST
Optional. This string is appended to the connection string when establishing a connection to Derby. Specify one property or several properties separated by semi-colons.
Example: create=true
The entire list of properties can be found here:http://db.apache.org/derby/docs/10.4/ref/rrefattrib24612.html
Show System Tables
S
If True, all system tables are displayed in the table list. If False (the default), system tables are not displayed.
Show Views
ST
If True (the default), all views are displayed in the table list. If False, views are not displayed.
Ignore Null Fields
T
If True (the default), fields that haven't been mapped are ignored. If False, unmapped fields are in target operations and null values are inserted or updated.
Transaction Isolation
T
Sets the transaction isolation level. Options are Read Uncommitted, Read Committed (the default), Repeatable Read, and Serializable.
Scrollability of Results
S
Scrolling behavior, one of the following:
• Forward Only (the default)
• Scrollable - Insensitive to changes.
• Scrollable - Sensitive to changes.
Operations and Entity Support
The Derby connector supports Create, Read, Update, and Delete operations on all entities.
Data Types
All Derby data types are supported. For a complete list, see http://db.apache.org/derby/docs/10.4/ref/crefsqlj31068.html.
The following table shows the mapping of Map Designer data types to Derby data types.
Map Designer Data Type
Derby Data Type
Boolean
SMALLINT
Byte
BLOB
Bytes
BLOB
Char
CHAR
Date
DATE
Datetime
TIMESTAMP
Decimal
DECIMAL
Double
DOUBLE
Float
FLOAT
Int
INTEGER
Long
BIGINT
Short
SMALLINT
String
CHAR
Time
TIME
Additional Information
Creating an Index
When creating an index on a column "c" in a table "t," the following naming convention is used for the name of the new index: "IDX_c_t".
Creating a Table
When creating a table, the length of the field can only be specified for the following types in Map Designer: Byte, Bytes, String, Char, and Decimal. The default length for Char is 1.