All Packages This Package Previous Next
DynamicProfiles are assumed to implement the "getStatement" method to returning appropriate RTStatement instances. In particular, the the statement type of the statement being created is CALLABLE, then "getStatement" returns an instance of a RTCallableStatement.
Note: In general, ConnectedProfiles are not expected to support dynamic operations. However, there are some cases that require the ability to dynamically create statement objects based on sql text caluculated at runtime. For example, in the case of positioned update or delete, the JDBC specification mandates that the name of the cursor be part of the sql operation text, but the name of the cursor cannot be discovered until runtime.
public abstract RTStatement prepareStatement(String sql) throws SQLException
public abstract RTCallableStatement prepareCall(String sql) throws SQLException
Note: Since the statement returned has been dynamically created, there is no way for the implementation of this method to know what the expected bind-types of the statement are. Therefore, it is the responsibility of the client to register any out parameters on the statement returned via calls to registerOutParameter on the returned statement.
All Packages This Package Previous Next