oracle.jdbc

Interface OracleTranslatingConnection

All Known Implementing Classes:

BabelfishConnection

public interface OracleTranslatingConnection

Declares convenience methods to get non translating Statements, PreparedStatements or CallableStatements from a SQL Translation enabled connection. All the methods defined here are counterparts to similar methods defined in java.sql.Connection, with an additional boolean flag. If the flag translation is true then the resulting Statement will have SQL Translation enabled just like you would get from a Translation enabled Connection. Else if the flag is false then the resulting Statement will not have translation enabled. Only a translation enabled connection can be handled with a reference to this interface.

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static class	OracleTranslatingConnection.SqlTranslationVersion Enumeration of various Translation versions of a query.

Method Summary

Modifier and Type	Method and Description
java.sql.Statement	createStatement(boolean translation)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, boolean translation)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability, boolean translation)
java.util.Map<OracleTranslatingConnection.SqlTranslationVersion,java.lang.String>	getSqlTranslationVersions(java.lang.String sql, boolean suppressExceptions) Returns a map of all the translation versions of the query during SQL Translation.
java.sql.CallableStatement	prepareCall(java.lang.String sql, boolean translation)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, boolean translation)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability, boolean translation)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, boolean translation)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int[] columnIndexes, boolean translation)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int autoGeneratedKeys, boolean translation)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, boolean translation)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability, boolean translation)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, java.lang.String[] columnNames, boolean translation)

Method Detail

createStatement

java.sql.Statement createStatement(boolean translation)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

createStatement

java.sql.Statement createStatement(int resultSetType,
                                   int resultSetConcurrency,
                                   boolean translation)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

createStatement

java.sql.Statement createStatement(int resultSetType,
                                   int resultSetConcurrency,
                                   int resultSetHoldability,
                                   boolean translation)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                            boolean translation)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                            int autoGeneratedKeys,
                                            boolean translation)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                            int[] columnIndexes,
                                            boolean translation)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                            java.lang.String[] columnNames,
                                            boolean translation)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                            int resultSetType,
                                            int resultSetConcurrency,
                                            boolean translation)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                            int resultSetType,
                                            int resultSetConcurrency,
                                            int resultSetHoldability,
                                            boolean translation)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareCall

java.sql.CallableStatement prepareCall(java.lang.String sql,
                                       boolean translation)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareCall

java.sql.CallableStatement prepareCall(java.lang.String sql,
                                       int resultSetType,
                                       int resultSetConcurrency,
                                       boolean translation)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareCall

java.sql.CallableStatement prepareCall(java.lang.String sql,
                                       int resultSetType,
                                       int resultSetConcurrency,
                                       int resultSetHoldability,
                                       boolean translation)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getSqlTranslationVersions

java.util.Map<OracleTranslatingConnection.SqlTranslationVersion,java.lang.String> getSqlTranslationVersions(java.lang.String sql,
                                                                                                            boolean suppressExceptions)
                                                                                                     throws java.sql.SQLException

Returns a map of all the translation versions of the query during SQL Translation. See SqlTranslationVersion enum for more details about returning versions.

Parameters:

sql - vendor specific sql to be translated

suppressExceptions - suppresses any exception raised during query translation and returns whatever is available. Useful to get JDBC_MARKER_CONVERTED version when the translation is throwing error.

Returns:

Map with all the translation versions of a query. In case of an Exception and if suppressExceptions is true then the TRANSLATED version in the map is null.

Throws:

java.sql.SQLException - If there is a problem in query translation provided suppressExceptions is false.

See Also:

OracleTranslatingConnection.SqlTranslationVersion