Part II: Add the JDBC TableView Template

  1. Select Filethen selectNew then selectOther.
  2. Expand SAS AppDev Studio.
  3. Select Add Template Content to Project, and click Next.
  4. Expand SAS Java Web Application and SAS Web Application Examples.
  5. Select JDBC TableView Servlet (uses SAS WIP), and click Next.
  6. Click Next to accept the Template Configuration Parameters.
  7. Accept the BI Server Profile by clicking Next. The BI Server that you plan to develop for should already be selected.
  8. Enter the user name and password for the selected server.
    JDBC Connection Properties
  9. Click Test Connection.
    If you do not receive the message “Connection test succeeded,” ensure that the BI Server Profile is correct and the BI Server is running on the expected port.
    In the future, when you want to provide a path to your data, click Driver Properties and define the librefs property.
  10. Click Next.
  11. For the Query, enter select * from sashelp.class.
  12. Click Submit Query to test the query and display the resulting column names.
    Query Results
  13. Click Next.
  14. Accept the Servlet Class Parameters by clicking Next.
    JDBC Servlet Class Parameters
  15. Click Finish to accept the Servlet Deployment Descriptor Parameters and add the JDBC TableView Servlet template to the project.
    JDBC Servlet Deployment Descriptor Parameters
    The JSP and Java files for the servlet are opened. Close both files.
Copyright © SAS Institute Inc. All rights reserved.