javax.sql

Interface StatementEventListener

Contents
  • All Superinterfaces:
    EventListener

    public interface StatementEventListener
extends EventListener
    An object that registers to be notified of events that occur on PreparedStatements that are in the Statement pool.

    The JDBC 3.0 specification added the maxStatements ConnectionPooledDataSource property to provide a standard mechanism for enabling the pooling of PreparedStatements and to specify the size of the statement pool. However, there was no way for a driver to notify an external statement pool when a PreparedStatement becomes invalid. For some databases, a statement becomes invalid if a DDL operation is performed that affects the table. For example an application may create a temporary table to do some work on the table and then destroy it. It may later recreate the same table when it is needed again. Some databases will invalidate any prepared statements that reference the temporary table when the table is dropped.

    Similar to the methods defined in the ConnectionEventListener interface, the driver will call the StatementEventListener.statementErrorOccurred method prior to throwing any exceptions when it detects a statement is invalid. The driver will also call the StatementEventListener.statementClosed method when a PreparedStatement is closed.

    Methods which allow a component to register a StatementEventListener with a PooledConnection have been added to the PooledConnection interface.

    Since:
    1.6

    • Method Detail

      • statementClosed

        void statementClosed(StatementEvent event)
        The driver calls this method on all StatementEventListeners registered on the connection when it detects that a PreparedStatement is closed.
        Parameters:
        event - an event object describing the source of the event and that the PreparedStatement was closed.
        Since:
        1.6

      • statementErrorOccurred

        void statementErrorOccurred(StatementEvent event)
        The driver calls this method on all StatementEventListeners registered on the connection when it detects that a PreparedStatement is invalid. The driver calls this method just before it throws the SQLException, contained in the given event, to the application.

        Parameters:
        event - an event object describing the source of the event, the statement that is invalid and the exception the driver is about to throw. The source of the event is the PooledConnection which the invalid PreparedStatement is associated with.

        Since:
        1.6

Document created the 11/06/2005, last modified the 04/03/2020
Source of the printed document:https://www.gaudry.be/en/java-api-rf-javax/sql/statementeventlistener.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

  1. View the html document Language of the document:fr Manuel PHP : https://docs.oracle.com

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut