ERXSQLHelper.DerbySQLHelper Class Reference

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

Collaboration diagram for ERXSQLHelper.DerbySQLHelper:

List of all members.

Public Member Functions

String externalTypeForJDBCType (JDBCAdaptor adaptor, int jdbcType)

String migrationTableName ()

boolean shouldExecute (String sql)

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

int varcharLargeColumnWidth ()

int varcharLargeJDBCType ()

Member Function Documentation

String externalTypeForJDBCType	(	JDBCAdaptor	adaptor,
		int	jdbcType
	)

JDBCAdaptor.externalTypeForJDBCType just returns the first type it finds instead of trying to find a best match. This can still fail, mind you, but it should be much better than the EOF default impl.

Parameters:

	adaptor	the adaptor to retrieve an external type for
	jdbcType	the JDBC type number

Returns:: a guess at the external type name to use

Reimplemented from ERXSQLHelper.

String migrationTableName ( )

Returns the name of the table to use for database migrations.

Returns:: the name of the table to use for database migrations

Reimplemented from ERXSQLHelper.

boolean shouldExecute ( String sql )

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.

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


Public Member Functions
String	externalTypeForJDBCType (JDBCAdaptor adaptor, int jdbcType)
String	migrationTableName ()
boolean	shouldExecute (String sql)
String	sqlForCreateUniqueIndex (String indexName, String tableName, ColumnIndex...columnIndexes)
int	varcharLargeColumnWidth ()
int	varcharLargeJDBCType ()