Database representation properties
- Database: Select a database from your workspace.
- Database table: Enter the name of the database table to use in this structure.
- Primary key columns: Select the column(s) that form the primary key for this table.
-
Primary key generation: Select how the primary key should
be generated for this table:
- None: Does not generate anything for the primary key. The value is expected to be mapped.
- Native: Automatically select the primary key generation most appropriate for the database.
- Identity: Supports identity columns in DB2, MySQL, MS SQL Server, Sybase and HypersonicSQL. Used for identity columns whose type is long, short or int.
- Increment: Generate a sequential number by incrementing a local value before an item is inserted. This is not suitable for an multi-user (including multi-threaded) environment where more than one process/thread may be inserting into the same table at a time.
- Sequence: Uses a sequence in DB2, PostgreSQL, or Oracle.
- Generation sequence name: Specify the sequence name to be used in the case where Primary key generation is either Sequence or Native (and the native implementation uses Sequence). If not specified, hibernate_sequence is used.
- Character encoding: Specify the character encoding for the data to be processed. For more information, see Character encoding.
- Trim whitespace on input?: Select this check box to automatically remove any leading or trailing whitespace from the input data for all elements. The non-leading or trailing whitespace is not affected.
- Pad to minimum length on output?: Select this check box to pad the output to the minimum size with either spaces (character) or zeros (binary).
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!