Package org.apache.camel.component.sql

Class SqlConstants

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 final String	SQL_DATA_SOURCE
static final String	SQL_GENERATED_COLUMNS	String[] or int[] input header - optional Set it to specify the expected generated columns, see:
static final String	SQL_GENERATED_KEYS_DATA	Listinvalid input: '<'Mapinvalid input: '<'String, Object>> output header containing the generated keys retrieved
static final String	SQL_GENERATED_KEYS_ROW_COUNT	int output header giving the number of rows of generated keys
static final String	SQL_PARAMETERS	The SQL parameters when using the option useMessageBodyForSql
static final String	SQL_QUERY
static final String	SQL_RETRIEVE_GENERATED_KEYS	Boolean input header.
static final String	SQL_ROW_COUNT
static final 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 Details

SQL_QUERY

@Metadata(label="producer",
          description="Query to execute. This query takes precedence over the query specified in the endpoint URI. Note that query parameters in the header 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 `Integer` object. This header is not provided when using outputType=StreamList.",
          javaType="Integer",
          important=true)
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 `Integer` object. This header is not provided when using outputType=StreamList.",
          javaType="Integer",
          important=true)
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

Listinvalid input: '<'Mapinvalid input: '<'String, Object>> 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

SQL_DATA_SOURCE

@Metadata(label="producer",
          description="To use a specific DataSource to operate on another database than the pre configured DataSource on the component",
          javaType="javax.sql.DataSource")
public static final String SQL_DATA_SOURCE

See Also:

• Constant Field Values