Doma
latest
Getting started
Configuration
Basic classes
Domain classes
Embeddable classes
Entity classes
Dao interfaces
Queries
Search
Insert
Update
Delete
Batch insert
Batch update
Batch delete
Stored function
Stored procedure
Factories
Script
SQL processor
Query builders
Criteria API
SQL templates
Expression language
Transaction
Building an application
Annotation processing
Lombok support
Kotlin support
SLF4J support
JPMS support
Frequently Asked Questions
Doma
Docs
»
Queries
Edit on GitHub
Queries
¶
Search
Query condition
Query that is used basic type or domain class
Query that is used arbitrary type
Mapping to IN clauses by using Iterable.
Single record search
Multiple record search
Stream search
Pass to the Function
Return the return value
Collect search
Using search option search
Paging
Pessimistic concurrency control
Aggregate
Ensure of search result
Ensure of mapping search result
Query timeout
Fetch size
Max row count
Naming rule of map’s key
SQL log output format
Insert
Return value
Insert by auto generated SQL
Identifier
Version numbers
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
Insert target property
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
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
Read the Docs
v: latest
Versions
latest
stable
2.54.1
2.54.0
2.53.3
2.53.2
2.53.1
2.53.0
2.52.0
2.51.1
2.51.0
2.50.0
2.49.0
2.48.0
2.47.1
2.47.0
2.46.2
2.46.1
2.46.0
2.45.0
2.44.3
2.44.2
2.44.1
2.44.0
2.43.0
2.42.0
2.41.0
2.40.0
2.39.0
2.38.0
2.37.0
2.36.0
2.35.0
2.34.0
2.33.0
2.32.0
2.31.0
2.30.0
2.29.0
2.28.0
2.27.1
2.27.0
2.26.0
2.25.1
2.25.0
2.24.0
2.23.0
2.22.0
2.21.0
2.20.0
2.19.3
2.19.2
2.19.1
2.19.0
2.18.0
2.17.0
2.16.1
2.16.0
2.15.0
2.14.0
2.13.0
2.12.1
2.12.0
2.11.0
2.10.0
2.9.0
2.8.0
2.7.0
2.6.2
2.6.1
2.6.0
2.5.1
2.5.0
2.4.1
2.4.0
2.3.1
2.3.0
2.2.0
2.1.0
2.0.1
2.0.0
Downloads
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.