1. Home
  2. Docs
  3. Chapter 30. Project Options
  4. 3. ORM
  5. General

General

Option Name Description
Quote SQL Identifier
  • Yes – Add quotes to SQL identifier to prevent potential violation when executing SQL
  • No – Do not add quotes to SQL identifier
  • Auto – (default) Quote only reserved words
Synchronize Name
  • Yes – Auto update model element name when synchronize class diagram and ERD
  • No – Do not update model element name when synchronize class diagram and ERD
  • Prompt – (default) Prompt to update model element name when synchronize class diagram and ERD
Mapping File Column Order
  • ERD – (default) Generate columns in mapping file in same order as ERD
  • Index – Generate index columns first in mapping file
Wrapping Servlet Request
  • On – Automatically lock persistable object when get by HttpSession.getAttribute()
  • Off – (default) Do not lock object automatically
Getter/Setter Visibility
  • Public – (default) Generate public getter/setter
  • Follow attribute -Getter/setter visibility follow attribute’s visibility
Decimal Precision and Scale – Use default (default true) Automatically determine the most suitable precision and scale when synchronize from attribute to column as decimal.
Decimal Precision and Scale – Precision Specify the precision when synchronize from attribute to column as decimal.
Decimal Precision and Scale – Scale Specify the scale when synchronize from attribute to column as decimal.
ID Generator
  • assigned – allow the application to assign an identifier to the object before save() is called.
  • guid – uses a database-generated GUID string on MS SQL Server and MySQL.
  • hilo – uses a hi/lo algorithm to efficiently generate identifiers of type longshort or int, given a table and column as a source of hi values. The hi/lo algorithm generates identifiers that are unique only for a particular database.
  • identity – supports identity columns in DB2, MySQL, MS SQL Server, Sybase and HypersonicSQL. The returned identifier is of type longshort or int.
  • increment – generates identifiers of type longshort or int that are unique only when no other process is inserting data into the same table. Do not use in a cluster.
  • native – (default) picks identitysequence or hilo depending upon the capabilities of the underlying database.
  • seqhilo – uses a hi/lo algorithm to efficiently generate identifiers of type longshort or int, given a named database sequence.
  • sequence – uses a sequence in DB2, PostgreSQL, Oracle. The returned identifier is of type longshort or int
ERD numeric to class type
  • Automatic – (default) Automatically select attribute type when synchronize from column numeric type
  • Integer – Synchronize column numeric type to attribute as integer type
  • Float – Synchronize column numeric type to attribute as float type
  • Double – Synchronize column numeric type to attribute as double type
  • Big Decimal – Synchronize column numeric type to attribute as big decimal type
SQL Statement Case
  • Upper Case – (default) Generate upper case keyword in SQL
  • Lower case – Generate lower case keyword in SQL
Generate diagram from ORM wizards (default true) Generate diagram when finish ORM wizards.
Export comment to database (default true) Generate documentation to table/column.
Formatted SQL (default false) Generate pretty formatted SQL.