Portlet Factory, Version 6.1.2


 

About tracking database events

The SQL Statement builder can fire this database-related event in the model.

Create Event

This event provides a way for your model to manipulate a prepared statement before it is handed off to other builders in the model for execution.

When the builder is configured to fire events, it will create and register in the model an event named SqlStatementBuilderEvent. This name then becomes available as an option for the Event Name input of an Event Handler builder. When the builder fires this event at run-time, it passes three parameters that can be used by an event handler action to manipulate the JDBC prepared statement just created and prepared for execution. Those parameters are:

BuilderName

This string parameter will contain the name of the SQL Statement builder that fired the create event. Since all Statement builders in a model use the SqlStatementBuilderEvent event name, this input allows you to discriminate among all of the Statement builders when handling events.

eventType

This string parameter indicates what type of event was fired. Only one value is currently available, and that is "Create".

statement

An object parameter that is the actual JDBC prepared statement (or callable statement for stored procedure calls) that was created and prepared for execution by the builder.

Parent topic: SQL Statement builder


Library | Support |