General Options

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 long, short 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 long, short or int.
  • increment - generates identifiers of type long, short 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 identity, sequence or hilo depending upon the capabilities of the underlying database.
  • seqhilo - uses a hi/lo algorithm to efficiently generate identifiers of type long, short or int, given a named database sequence.
  • sequence - uses a sequence in DB2, PostgreSQL, Oracle. The returned identifier is of type long, short 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.
General Options details

Related Resources

The following resources may help you to learn more about the topic discussed in this page.

 
Chapter 3. ORM Table of Contents 2. Synchronization
 

Technical Support

Have technical issues or suggestions? Please contact Visual Paradigm Support Team.

Sales Support

Have questions related to registration, licensing or payment? Feel free to contact Visual Paradigm Sales Team.

Discussion Forum

Share your suggestions of opinions at VP Discussion Forum.