Using Allaire JRun 3.x

Allaire's JRun is a J2EE application server. JRun applications can be written in Java and JSP, but to simplify development JRun's Tag Libraries may be used. To test your SQL, create a simple page that you can execute by calling it from your Web browser. Perform the following steps:

1.
JRun uses JDBC to interact with databases, so a JDBC Data Source must be present before proceeding. The JRun Management Console provides a Web-based interface to define JDBC Data Sources.
2.
Create a new JSP page (with a JSP extension) using JRun Studio, HomeSite, or any other text editor.
3.
Include the JRun tag libraries using the <%@ taglib %> directive.
4.
Use the JRun <sql> and </sql> tags to create a query block. Name it using the id

Get Sams Teach Yourself SQL in 10 Minutes, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.