WebLogic Server 8.1 API Reference

weblogic.jdbc.extensions
Interface WLConnection

public interface WLConnection

Contains methods to interact with the Statement Cache

Author:

Copyright © 2002 BEA Systems, Inc. All Rights Reserved.

Method Summary

void	clearCallableStatement(java.lang.String sql) Clear a callable statement from the Statement Cache
void	clearCallableStatement(java.lang.String sql, int resType, int resConcurrency) Clear a callable statement from the Statement Cache
void	clearPreparedStatement(java.lang.String sql) Clear a prepared statement from the Statement Cache
void	clearPreparedStatement(java.lang.String sql, int resType, int resConcurrency) Clear a prepared statement from the Statement Cache
void	clearStatementCache() Clears the statement cache.
java.sql.Connection	getVendorConnection() Returns vendor connection

Method Detail

clearStatementCache

public void clearStatementCache()
                         throws java.sql.SQLException

Clears the statement cache.

Throws:

java.sql.SQLException - - if a database access error occurs

getVendorConnection

public java.sql.Connection getVendorConnection()
                                        throws java.sql.SQLException

Returns vendor connection

Returns:

java.sql.Connection

Throws:

java.sql.SQLException - - if a database access error occurs

clearCallableStatement

public void clearCallableStatement(java.lang.String sql)
                            throws java.sql.SQLException

Clear a callable statement from the Statement Cache

Parameters:

sql - - an SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.

Throws:

java.sql.SQLException - - if a database access error occurs

clearCallableStatement

public void clearCallableStatement(java.lang.String sql,
                                   int resType,
                                   int resConcurrency)
                            throws java.sql.SQLException

Clear a callable statement from the Statement Cache

Parameters:

sql - - an SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.

resSetType - - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resSetConcurrency - - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

Throws:

java.sql.SQLException - - if a database access error occurs

clearPreparedStatement

public void clearPreparedStatement(java.lang.String sql)
                            throws java.sql.SQLException

Clear a prepared statement from the Statement Cache

Parameters:

sql - - an SQL statement that may contain one or more '?' IN parameter placeholders

Throws:

java.sql.SQLException - - if a database access error occurs

clearPreparedStatement

public void clearPreparedStatement(java.lang.String sql,
                                   int resType,
                                   int resConcurrency)
                            throws java.sql.SQLException

Clear a prepared statement from the Statement Cache

Parameters:

sql - - an SQL statement that may contain one or more '?' IN parameter placeholders

resSetType - - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resSetConcurrency - - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

Throws:

java.sql.SQLException - - if a database access error occurs