ContextQMD
Back to Shardingsphere

Sql Translator.En

docs/document/content/user-manual/shardingsphere-jdbc/java-api/rules/sql-translator.en.md

5.5.31.2 KB
Original Source

+++ title = "SQL Translator" weight = 9 +++

Background

By using SQL translator in the form of Java API, you can easily integrate into various systems and flexibly customize user requirements.

Parameters

Class: org.apache.shardingsphere.sqltranslator.config.SQLTranslatorRuleConfiguration

Attributes:

nameDataTypeDescription
typeStringSQL translator type
useOriginalSQLWhenTranslatingFailed (?)booleanWhether use original SQL when translating failed

Procedure

  1. Set SQL translator type.
  2. Set useOriginalSQLWhenTranslatingFailed to decide whether use original SQL when translating failed.

Sample

java
SQLTranslatorRuleConfiguration ruleConfig = new SQLTranslatorRuleConfiguration("Native", new Properties(), false);
String translatedSQL = new SQLTranslatorRule(ruleConfig).translate();