java.lang.Object
- org.apache.camel.component.sql.SqlConstants

public final class SqlConstants
extends Object

SQL Constants.

Field Summary

Fields
Modifier and Type	Field	Description
`static String`	`SQL_GENERATED_COLUMNS`	`String[]` or `int[]` input header - optional Set it to specify the expected generated columns, see:
`static String`	`SQL_GENERATED_KEYS_DATA`	`List>` output header containing the generated keys retrieved
`static String`	`SQL_GENERATED_KEYS_ROW_COUNT`	int output header giving the number of rows of generated keys
`static String`	`SQL_PARAMETERS`	The SQL parameters when using the option useMessageBodyForSql
`static String`	`SQL_QUERY`
`static String`	`SQL_RETRIEVE_GENERATED_KEYS`	Boolean input header.
`static String`	`SQL_ROW_COUNT`
`static String`	`SQL_UPDATE_COUNT`

Method Summary
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

SQL_QUERY

@Metadata(label="producer",
          description="Query to execute. This query takes precedence over the\nquery specified in the endpoint URI. Note that query parameters in the\nheader _are_ represented by a `?` instead of a `pass:[#]` symbol",
          javaType="String")
public static final String SQL_QUERY

See Also:: Constant Field Values

SQL_UPDATE_COUNT

@Metadata(label="producer",
          description="The number of rows updated for `update` operations, returned as an\n`Integer` object. This header is not provided when using\noutputType=StreamList.",
          javaType="Integer")
public static final String SQL_UPDATE_COUNT

See Also:: Constant Field Values

SQL_ROW_COUNT

@Metadata(label="producer",
          description="The number of rows returned for `select` operations, returned as an\n`Integer` object. This header is not provided when using\noutputType=StreamList.",
          javaType="Integer")
public static final String SQL_ROW_COUNT

See Also:: Constant Field Values

SQL_RETRIEVE_GENERATED_KEYS

@Metadata(label="producer",
          description="Set its value to true to retrieve generated keys",
          javaType="Boolean",
          defaultValue="false")
public static final String SQL_RETRIEVE_GENERATED_KEYS

Boolean input header. Set its value to true to retrieve generated keys, default is false

See Also:: Constant Field Values

SQL_GENERATED_COLUMNS
```
@Metadata(label="producer",
          description="Set it to specify the expected generated columns",
          javaType="String[] or int[]")
public static final String SQL_GENERATED_COLUMNS
```
String[] or int[] input header - optional Set it to specify the expected generated columns, see:

See Also:

java.sql.Statement.execute(java.lang.String, int[]), java.sql.Statement.execute(java.lang.String, java.lang.String[]), Constant Field Values

SQL_GENERATED_KEYS_ROW_COUNT

@Metadata(label="producer",
          description="The number of rows in the header that contains generated keys.",
          javaType="Integer")
public static final String SQL_GENERATED_KEYS_ROW_COUNT

int output header giving the number of rows of generated keys

See Also:: Constant Field Values

SQL_GENERATED_KEYS_DATA

@Metadata(label="producer",
          description="Rows that contains the generated keys (a list of maps of keys).",
          javaType="List<Map<String, Object>>")
public static final String SQL_GENERATED_KEYS_DATA

List> output header containing the generated keys retrieved

See Also:: Constant Field Values

SQL_PARAMETERS
```
@Metadata(label="producer",
          javaType="Iterator")
public static final String SQL_PARAMETERS
```
The SQL parameters when using the option useMessageBodyForSql

See Also:

Constant Field Values

Class SqlConstants

Field Summary

Method Summary

Methods inherited from class java.lang.Object