Show Table of Contents
Chapter 4. Extending the JDBC Translator
4.1. Extensions
New custom Translators can be created by extending the JDBC Translator. This is one of the most common use-cases for custom Translator development and is often done to add support for JDBC drivers and database versions.
To design a JDBC Translator for any relational database management system (RDBMS) that is not already supported by Red Hat JBoss Data Virtualization, extend the
org.teiid.translator.jdbc.JDBCExecutionFactory class in the translator-jdbc module. There are three types of methods that you can override from the base class to define the behavior of the Translator.
Table 4.1. Extensions
|
Extension
|
Purpose
|
|---|---|
|
Capabilities
|
Specify the SQL syntax and functions the source supports.
|
|
SQL Translation
|
Customize what SQL syntax is used, how source-specific functions are supported, how procedures are executed.
|
|
Results Translation
|
Customize how results are retrieved from JDBC and translated.
|
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.