ERXSQLHelper.H2SQLHelper Class Reference

Inherits er::extensions::jdbc::ERXSQLHelper.

Collaboration diagram for ERXSQLHelper.H2SQLHelper:

[legend]

List of all members.

Public Member Functions
String	limitExpressionForSQL (EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end)
String	sqlForCreateIndex (String indexName, String tableName, ColumnIndex...columnIndexes)
String	sqlForCreateUniqueIndex (String indexName, String tableName, ColumnIndex...columnIndexes)
String	sqlForRegularExpressionQuery (String key, String value)
int	varcharLargeColumnWidth ()
int	varcharLargeJDBCType ()
Protected Member Functions
String	sqlForGetNextValFromSequencedNamed (String sequenceName)

---

Member Function Documentation

String limitExpressionForSQL	(	EOSQLExpression	expression,
		EOFetchSpecification	fetchSpecification,
		String	sql,
		long	start,
		long	end
	)

Reimplemented from ERXSQLHelper.

String sqlForCreateIndex	(	String	indexName,
		String	tableName,
		ColumnIndex...	columnIndexes
	)

Returns the SQL expression for creating an index on the given set of columns

Parameters:

	indexName	the name of the index to create
	tableName	the name of the containing table
	columnIndexes	the list of columns to index on

Returns:

a SQL expression

Reimplemented from ERXSQLHelper.

String sqlForCreateUniqueIndex	(	String	indexName,
		String	tableName,
		ColumnIndex...	columnIndexes
	)

Returns the SQL expression for creating a unique index on the given set of columns

Parameters:

	indexName	the name of the index to create
	tableName	the name of the containing table
	columnIndexes	the list of columns to index on

Returns:

a SQL expression

Reimplemented from ERXSQLHelper.

String sqlForGetNextValFromSequencedNamed

(

String

sequenceName

)

[protected]

See also:

er.extensions.jdbc.ERXSQLHelper.sqlForGetNextValFromSequencedNamed(java.lang.String)

Reimplemented from ERXSQLHelper.

String sqlForRegularExpressionQuery	(	String	key,
		String	value
	)

Returns the SQL expression for a regular expression query.

Parameters:

	key
	value

Returns:

the regex SQL

Reimplemented from ERXSQLHelper.

int varcharLargeColumnWidth

(

)

Returns the width that should be used for a varcharLarge column in migrations.

Returns:

the width that should be used for a varcharLarge column in migrations

Reimplemented from ERXSQLHelper.

int varcharLargeJDBCType

(

)

Returns the JDBCType that should be used for a varcharLarge column in migrations.

Returns:

the JDBCType that should be used for a varcharLarge column in migrations

Reimplemented from ERXSQLHelper.

---

The documentation for this class was generated from the following file:

• /opt/source/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java