Package org.frankframework.dbms

Class SqlTranslator

java.lang.Object

org.frankframework.dbms.SqlTranslator

All Implemented Interfaces:

ISqlTranslator

public class SqlTranslator
extends Object
implements ISqlTranslator

Sql syntax translator to translate queries for different database management systems (e.g. Oracle to MsSql or PostgreSql to MySql)

Constructor Summary

Constructors

Constructor	Description
SqlTranslator(String source, String target)

Method Summary

Modifier and Type	Method	Description
boolean	canConvert(String from, String to)
protected Pattern	toPattern(String str)	Compiles a pattern with necessary flags.
String	translate(String original)	Translates the given query to the target language.

Methods inherited from class java.lang.Object

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

Constructor Details

SqlTranslator

public SqlTranslator(String source,
 String target)
              throws DbmsException

Throws:

DbmsException

Method Details

canConvert

public boolean canConvert(String from,
 String to)

Specified by:

canConvert in interface ISqlTranslator

translate

public String translate(String original)

Translates the given query to the target language. Uses the translation rules set by this and the target translators.

Specified by:

translate in interface ISqlTranslator

Parameters:

original - Original query to be translated.

Returns:

Translated query.

toPattern

protected Pattern toPattern(String str)

Compiles a pattern with necessary flags.

Parameters:

str - String to be compiled.

Returns:

Output pattern.