Creating a Custom Action Handler for XSQL

An action handler in an XSQL page is a Java class that gets invoked to perform a specific task. There are prebuilt action handlers for various tasks such as setting cookies, applying style sheets, performing queries against databases, etc. However, if you choose to perform some operation which is not provided by the built-in action handlers, then you can write what is called a custom action handler. A custom action handler is a Java class that can be invoked from an XSQL page just as easily as a predefined action handler.

The procedure for creating an action handler is to:

Add the XSQL configuration file to your project.
In the XSQL configuration file, register the new action handler by specifying the element name and handler class.
In the XSQL file, add the new element and its attributes.
In the XSQL file, add connection information to the <page> tag.
Add a Java file to the project.
In the Java file, create a class that extends the XSQLActionHandlerImpl class.

The XSQL action handlers for BC4J are packaged as part of the JBO HTML library in JDeveloper, which includes the relevant: <JdevHome>/BC4J/lib/bc4jhtml.jar archive in the build.