Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Java Server Pages (JSP)

Java Server Pages (JSP) are an extension of the Servlet framework, which allows Java to be used as a scripting language within HTML files, like ASP and PHP. When the files containing the Java scripting are requested from the webserver they are compiled as servlets which actually produce the content. This article assumes the default installation of the HTTP server has taken place and the HTTP server is running.

Webserver Configuration

First we create a directory on the Oracle server to hold the JSP files.

  ORACLE_HOME\Apache\Apache\htdocs\TSH

Save PSP Files

Next we place the JSP files, with the appropriate modifications, in the new directory.

Since this code contains HTML it may look normal when displayed by the browser, but the JSP code will not be executed. Either view the source or save the source to a file to read the code.

Test It

Once the files are saved to the filesystem they can be requested from the webserver and tested by opening a browser and requesting the following address, where "yourServer" is the name of the Oracle server.

http://yourServer:7778/TSH/dept_insert_req.jsp

Enter some values into the form and press the submit button. The resulting page should show a successful completion message or an error message. In addition the contents of the DEPT table are displayed as an HTML table.

For more informationn see:

Hope this helps. Regards Tim...

Back to the Top.