nl.nn.adapterframework.jdbc.dbms

Class SqlTranslator

java.lang.Object

nl.nn.adapterframework.jdbc.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 and Description
SqlTranslator(String source, String target)

Method Summary

Modifier and Type	Method and 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 Detail

SqlTranslator

public SqlTranslator(String source,
                     String target)
              throws JdbcException

Throws:

JdbcException

Method Detail

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.