org.javasimon.jdbc4

Class RegexBasedSqlNormalizer

java.lang.Object

org.javasimon.jdbc4.RegexBasedSqlNormalizer

All Implemented Interfaces:

SqlNormalizer

public final class RegexBasedSqlNormalizer
extends Object
implements SqlNormalizer

SqlNormalizer takes SQL statement and replaces parameters with question marks. It is important to realize, that normalizer IS NOT SQL analyzer. It makes as simple replacement as possible (with my coding skill ;-)) to still truly represent the original statement. Normalized statement is merely used to recognize the original one and also to merge the same statements with various arguments. Its primary purpose is to limit count of distinct per-statement Simons. It doesn't suppose to be perfect or proof to all dialects.

Usage is simple, you create normalizer with SQL statement and then you can ask the object for normalizedSql and type via respective getters.

Since:

2.4

Author:

Radovan Sninsky, Richard "Virgo" Richter

Method Summary

Modifier and Type	Method and Description
String	getNormalizedSql() Returns the normalized SQL.
String	getSql() Returns the original SQL.
String	getType() Returns SQL type which is typically first word of the SQL (insert, select, etc).
String	toString() Returns human readable string describing this SQL normalizer.

Methods inherited from class java.lang.Object

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

Method Detail

getSql

public String getSql()

Returns the original SQL.

Specified by:

getSql in interface SqlNormalizer

Returns:

original SQL

getNormalizedSql

public String getNormalizedSql()

Returns the normalized SQL.

Specified by:

getNormalizedSql in interface SqlNormalizer

Returns:

normalized SQL

getType

public String getType()

Returns SQL type which is typically first word of the SQL (insert, select, etc). Returns batch for batches.

Specified by:

getType in interface SqlNormalizer

Returns:

SQL statement type or "batch"

toString

public String toString()

Returns human readable string describing this SQL normalizer.

Overrides:

toString in class Object

Returns:

original SQL, normalized SQL, SQL type