The type of the SQL statement.

Configuration Options

Related Options

• annotations: The additional annotations to be placed on generated methods.
• catchAndRethrow: Catch exceptions during SQL execution and re-throw them as RuntimeExceptions
• createConnection: Controls whether the generated code should create/open connection itself or use a given connection.
• description: The description for the SQL statement
• executeBatch: Generate methods that are executed as batch
• executeBatchPrefix: The method prefix to use for generated methods that execute in a batch.
• executeBatchSuffix: The method suffix to use for generated methods that execute in a batch.
• executeOnce: Generate methods that are executed once with the given parameters
• executeOncePrefix: The method prefix to use for generated methods that execute once.
• executeOnceSuffix: The method suffix to use for generated methods that execute once.
• name: The name of the SQL statement
• parameters: The parameters of the SQL statement.
• repository: The fully qualified name of the target repository class.
• resultRowConverter: The alias or fully-qualified name of the converter to use
• returningMode: The returning mode of the SQL statement.
• throwOnMultipleResults: Throw an exception in case a statement using ReturningMode.SINGLE produces more than 1 result.
• vendor: The vendor name of the database the SQL statement is intended for
• writesReturnUpdateCount: Writing method which are using ReturningMode.NONE return the number of affected rows instead.

Front Matter

In order to configure this option, place the following code in the front matter of your SQL statement:

-- type: configValue
SELECT  something
FROM    your_database_schema
WHERE   some_column = :some_value