ERXSQLHelper.MicrosoftSQLHelper Class Reference

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

Collaboration diagram for ERXSQLHelper.MicrosoftSQLHelper:

[legend]

List of all members.

Public Member Functions
String	externalTypeForJDBCType (JDBCAdaptor adaptor, int type)
String	limitExpressionForSQL (EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end)
Protected Member Functions
Pattern	commentPattern ()

---

Member Function Documentation

Pattern commentPattern

(

)

[protected]

Returns a pattern than matches lines that start with "--".

Returns:

regex pattern that indicates this line is an SQL comment

Reimplemented from ERXSQLHelper.

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 limitExpressionForSQL	(	EOSQLExpression	expression,
		EOFetchSpecification	fetchSpecification,
		String	sql,
		long	start,
		long	end
	)

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