org.teiid.connector.jdbc
Class JDBCPropertyNames

java.lang.Object
  org.teiid.connector.jdbc.JDBCPropertyNames

public class JDBCPropertyNames
extends java.lang.Object

Field Summary

static java.lang.String	CONNECTION_SOURCE_CLASS
static java.lang.String	CONNECTION_TEST_QUERY
static java.lang.String	DATABASE_TIME_ZONE This is the property name of the ConnectorService property that defines the time zone of the source database.
static java.lang.String	EXT_CAPABILITY_CLASS This property is used to specify the implementation of com.metamatrix.data.ConnectorCapabilities.
static java.lang.String	EXT_TRANSLATOR_CLASS This property is used to specify the implementation of com.metamatrix.connector.jdbc.extension.Translator
static java.lang.String	FETCH_SIZE This property can be used to specify the fetch size used from the connector to its underlying source.
static java.lang.String	IS_VALID_TIMEOUT
static java.lang.String	PASSWORD
static java.lang.String	SET_CRITERIA_BATCH_SIZE This is the property name of the ConnectorService property that defines the size of a SetCriteria (IN criteria) before the criteria is broken into multiple queries and the results are aggregated.
static java.lang.String	TRANSACTION_ISOLATION_LEVEL This is the property name used to set the transaction isolation level on a connector's data source.
static java.lang.String	TRIM_STRINGS This is the property name of the ConnectorService property that defines whether or not String type values in Criteria statements in SQL queries to the data source should have spaces trimmed from them.
static java.lang.String	URL
static java.lang.String	USE_BIND_VARIABLES This property can be used to indicate that prepared statements should be used.
static java.lang.String	USE_COMMENTS_SOURCE_QUERY This property is used to turn on/off the use of the default comments like connection id and requestid in the source SQL query.
static java.lang.String	USERNAME

Constructor Summary

JDBCPropertyNames()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CONNECTION_SOURCE_CLASS

public static final java.lang.String CONNECTION_SOURCE_CLASS

See Also:

Constant Field Values

URL

public static final java.lang.String URL

See Also:

Constant Field Values

USERNAME

public static final java.lang.String USERNAME

See Also:

Constant Field Values

PASSWORD

public static final java.lang.String PASSWORD

See Also:

Constant Field Values

TRIM_STRINGS

public static final java.lang.String TRIM_STRINGS

This is the property name of the ConnectorService property that defines whether or not String type values in Criteria statements in SQL queries to the data source should have spaces trimmed from them.

See Also:

Constant Field Values

SET_CRITERIA_BATCH_SIZE

public static final java.lang.String SET_CRITERIA_BATCH_SIZE

This is the property name of the ConnectorService property that defines the size of a SetCriteria (IN criteria) before the criteria is broken into multiple queries and the results are aggregated. 0 indicates that set criteria should never be broken. The default value should be 0.

See Also:

Constant Field Values

TRANSACTION_ISOLATION_LEVEL

public static final java.lang.String TRANSACTION_ISOLATION_LEVEL

This is the property name used to set the transaction isolation level on a connector's data source. The value string must be the the same as one of the names of the values of the transaction isolation levels defined in java.sql.Connection.

See Also:

Connection.setTransactionIsolation(int), Constant Field Values

DATABASE_TIME_ZONE

public static final java.lang.String DATABASE_TIME_ZONE

This is the property name of the ConnectorService property that defines the time zone of the source database. This property should only be used in cases where the source database is in a different time zone than the ConnectorService VM and the database/driver is not already handling time zones correctly.

See Also:

Constant Field Values

EXT_CAPABILITY_CLASS

public static final java.lang.String EXT_CAPABILITY_CLASS

This property is used to specify the implementation of com.metamatrix.data.ConnectorCapabilities.

See Also:

Constant Field Values

EXT_TRANSLATOR_CLASS

public static final java.lang.String EXT_TRANSLATOR_CLASS

This property is used to specify the implementation of com.metamatrix.connector.jdbc.extension.Translator

See Also:

Constant Field Values

FETCH_SIZE

public static final java.lang.String FETCH_SIZE

This property can be used to specify the fetch size used from the connector to its underlying source.

See Also:

Constant Field Values

USE_BIND_VARIABLES

public static final java.lang.String USE_BIND_VARIABLES

This property can be used to indicate that prepared statements should be used. This means Literals will be substituted for bind variables.

Since:

5.0.1

See Also:

Constant Field Values

USE_COMMENTS_SOURCE_QUERY

public static final java.lang.String USE_COMMENTS_SOURCE_QUERY

This property is used to turn on/off the use of the default comments like connection id and requestid in the source SQL query.

See Also:

Constant Field Values

CONNECTION_TEST_QUERY

public static final java.lang.String CONNECTION_TEST_QUERY

See Also:

Constant Field Values

IS_VALID_TIMEOUT

public static final java.lang.String IS_VALID_TIMEOUT

See Also:

Constant Field Values

Constructor Detail

JDBCPropertyNames

public JDBCPropertyNames()