Invoke the Text Wizard to create and run a Text Search JSP application

Completed the Preinstallation Tasks module

Completed the Installing the Oracle9i Database module

Documentation: Oracle Text Application Developer's Guide

Open JDeveloper.

Select File > New. Click the Projects category and select Workspace. Then click OK.

Change the directory and file name as textsearch. Make sure Add a New Empty Project is checked and click OK.

Enter the project directory and file name as textsearch and click OK.

Once the project is created, you will see it in the System Navigator.

You can now invoke the Text Wizard to create the application. Right-click on the textsearch.jpr project and select Invoke Text Wizard. Note: you can also select it from the Tools pulldown window.

When the Welcome window appears, click Next.

Enter the Application name as TextSearchApp and click Next.

You will need to create a new connection to your PO database user. Click New.

At the Connection Wizard welcome window, click Next.

Enter the connection name po_JDBC and click Next.

Enter the username and password po and click the Deploy Password checkbox and click Next.

Enter your hostname and make sure the SID is correct and click Next.

Click Test Connection to make sure it is successful and click Finish.

All the connection information that you just created will be inserted into the Text Wizard connection window. Click Next.

You will search the document column from the PO_PRODUCTS table. select PO_PRODUCTS for the Table Name and DOCUMENT(CLOB) for the Column name and click Next.

On the Search page, you want to list the PRODUCT_NAME(VARCHAR2) and the DESCRIPTION(VARCHAR2). Select each column and click > to move them from the Available Columns to the Select Columns and click Next.

Select all the Text Document Services checkboxes and click Next.

Make sure the Document Format is set to html and the Source Type is jsp and click Next.

At the Summary window, click Finish.

The JSP Application code will be created. You can review the code in JDEveloper.

Before you create the index, you will want to verify that you have the data loaded in the database. Open a DOS prompt and change directory to your textsearch directory and execute the following commands:

sqlplus po/po@orcl.world
select count(*) from po_products;

You should have 6 records. If you do not have 6, you need to make sure that you install and load the PO schema in the prerequisites section of this lesson. Follow the readme instructions to install.

Now you can create the index by executing the following command:

@TextSearchApp_createIndex

Edit the ojsp.conf in notepad. This file is typically found in the <ORACLE_HOME>\Apache\jsp\conf directory. Add the following alias:

Alias /textsearch/ "<9iDS_ORACLE_HOME>\jdev\mywork\textsearch\textsearch/"

Save and close the file.

You will need to stop and start your HTTP server for these changes to take effect.

Open your browser and run the following URL:

http://<hostname>:<httpport>/textsearch/TextSearchApp.jsp

Enter Oracle in the Search for field and click Search.

You will see the list of documents that contain the word Oracle.

To see the actual document, click on the HTML link. Click back to return to the previous page.

To see where the word was actually found, click the Highlight link. You will see the word that was searched in red and a hyperlink is created. You could have documents available in the database that could be retrieved when a user clicked on the link. Click back to return to the list of documents.

To see a list of the themes in the document, click the Theme link. Click back to return to the list of documents.

To see a quick summary of what is contained in the document, click the Gist link.

Right-click on your textsearch.jws workspace and select New Project.

Select the Projects category and the Empty Project item and click OK.

change the directory name to catsearch and the file name to catsearch.jpr and click OK.

You will see your new project in the navigator.

Right-click on your catsearch.jpr application that you just created and select Invoke CatSearch Wizard...

At the CatSearch Wizard Welcome window, click Next.

Change the Application Name to catsearchApp and click Next.

Click Next to use the same connection your created before.

select the PO_PRODUCTS table and the PRODUCT_NAME(VARCHAR2) column and click Next.

You will want to search for a product that has a particular price. Select the PRICE(NUMBER) and click > to move it to the Selected Column area and click Next.

You can set the way the results will be displayed. Click Next to accept the defaults.

You will now create the application. Click Finish.

Review the code that was generated and save your workspace.

Open a DOS prompt and change directory to your catsearch directory and execute the following commands:

sqlplus po/po@orcl.world
@CatSearchApp_createIndex

Edit the ojsp.conf in notepad. This file is typically found in the <ORACLE_HOME>\Apache\jsp\conf directory. Add the following alias:

Alias /catsearch/ "<9iDS_ORACLE_HOME>\jdev\mywork\textsearch\catsearch/"

Save and close the file.

You will need to stop and start your HTTP server for these changes to take effect.

Open your browser and run the following URL:

http://<hostname>:<httpport>/catsearch/catSearchApp.jsp

Enter Oracle in the Search for field and < in the PRICE is drop down and 3000 in the value field and click Search.

You will see that you get two records that match this criteria.

Invoke the Text Wizard to create and run a Text Search JSP application