Queries

• Select
  • Search condition
    • Query using basic classes or domain classes
    • Query using arbitrary type
    • Mapping to the IN clause
  • Single record search
  • Multiple record search
  • Stream search
    • Passing a Stream to Function
    • Returning a Stream
  • Collector search
  • Search options
    • Paging
    • Pessimistic concurrency control
    • Count
  • Ensure the existence of search results
  • Ensure the mapping of search results
  • Query timeout
  • Fetch size
  • Max row count
  • The naming convention for the keys of the Map
  • Output format of SQL logs
• Insert
  • Return value
  • Insert by auto generated SQL
    • Identifier
    • Version numbers
    • Properties of @Insert
  • Insert by SQL file
  • Unique constraint violation
  • Query timeout
  • SQL log output format
• Update
  • Return value
  • Update by auto generated SQL
    • Version number and optimistic concurrency control in auto generated SQL
    • Control updating target property
  • Update by SQL file
    • Case of using comment that generating update column list
    • Case of not using comment that generating update column list
  • Unique constraint violation
  • Query timeout
  • SQL log output format
• Delete
  • Return value
  • Delete by auto generated SQL
    • Version number and optimistic concurrency control in auto generated SQL
  • Delete by SQL file
    • Version number and optimistic concurrency control in SQL File
  • Query timeout
  • SQL log output format
• Batch insert
  • Return value
  • Batch insert by auto generated SQL
    • Identifier
    • Version number
    • Properties of @BatchInsert
  • Batch insert by SQL file
  • Unique constraint violation
  • Query timeout
  • Batch size
  • SQL log output format
• Batch update
  • Return value
  • Batch update by auto generated SQL
    • Version number and optimistic concurrency control in auto generated SQL
    • Update target property
  • Batch update by SQL file
    • Case of using comment that generating update column list
    • Case of not using comment that generating update column list
  • Unique constraint violation
  • Query timeout
  • Batch size
  • SQL log output format
• Batch delete
  • Return value
  • Batch delete by auto generated SQL
    • Version number and optimistic concurrency control in auto generated SQL
  • Batch delete by SQL file
    • Version number and optimistic concurrency control in SQL file
  • Query timeout
  • Batch size
  • SQL log output format
• Multi-row insert
  • Return type
  • Parameter type
  • Automatically generated values
    • Identifier
    • Version number
  • Properties of @MultiInsert
    • exclude
    • include
    • duplicateKeyType
    • duplicateKeys
  • Unique constraint violation
  • Query timeout
  • SQL log output format
• Stored function
  • Return type
  • Function name
  • Parameters
    • IN parameter
    • INOUT parameter
    • OUT parameter
    • Cursor or result set
• Stored procedure
  • Return Type
  • Procedure name
  • Parameters
    • IN parameter
    • INOUT parameter
    • OUT parameter
    • Cursor or result set
• Factories
  • Creating Array instances
  • Creating Blob instances
  • Creating Clob instances
  • Creating NClob instances
  • Creating SQLXML instances
• Script
  • Script representation
    • Scripts in files
    • Scripts in annotation
  • Delimiter
  • Stopping on error
  • Example
• SQL processor
  • Return type
  • Parameter
  • Example