HP 5991-5565 manual Http//YOURHOSTNAME8080/oracleTest.jsp, Oracle Database Test

Page 35

1.Create a JSP file named $CATALINA_HOME/webapps/ROOT/oracleTest.jsp and insert the following lines:

<%@page contentType="text/html" import="java.io.*,java.sql.*, javax.sql.*,javax.naming.*"%>

<html>

<head>

<title>Tomcat->Oracle Test </title>

<link rel="stylesheet" href="style_master.css" type="text/css"> <meta http-equiv="cache-control" content="no-cache"></head>

<body>

<%

InitialContext ctx = new InitialContext(); DatabaseMetaData dm = null;

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/oracleDB"); Connection conn = null;

Statement stmt = null; try {

conn = ds.getConnection(); dm =conn.getMetaData(); out.println("Connected to-> database version" +dm.getDatabaseProductVersion());

}catch (Exception sqlex) { out.println(sqlex.getMessage()); }finally{

conn.close();

}

%>

</body>

</html>

2.If the Tomcat Web server is not running, start it by entering the following command:

# $CATALINA_HOME/bin/startup.sh

3.Verify that the Oracle test page is displayed (Figure 13 ) by opening a browser and navigating to the following website:

http://<YOUR_HOSTNAME>:8080/oracleTest.jsp

Figure 13 Oracle Database Test

Installing, Configuring, and Managing Web Server Middleware Stack Components 35

Image 35

Contents HP Open Source Middleware Stacks Blueprint Copyright 2007 Hewlett-Packard Development Company, L.P Table of Contents Monitor Tomcat with OpenView Tomcat SPI Oracle Database Test Webalizer Usage ReportPage List of Tables Page Intended Audience HP ServicesIntroduction Executive SummaryFeedback@fc.hp.com Typographic ConventionsHP Encourages Your Comments UserInputWeb Server Stack Architecture HP Open Source Web Server Middleware StackWeb Server Stack Architecture Required Packages and Installation Recommendations Installing and Verifying the Linux DistributionInstalling the Linux Distribution YaST Software Selection and System Tasks Verifying the Linux Distribution Installation# /etc/init.d/apache2 start Configuring the Basic Apache Http ServerInstalling and Configuring Sun JDK on an HP Proliant System TomcatFor the alljava.csh file, add the following lines # ln -s /usr/java/jdk1.5.010 /usr/local/jdkFor the alljava.sh file, add the following lines # /usr/local/apache-tomcat/bin/startup.sh Installing and Configuring Tomcat# java -version Following messages appear# /usr/local/apache-tomcat/bin/shutdown.sh Advanced Apache Http Server FeaturesUsing the Apache Http Server Benchmarking Tool If necessary, stop Tomcat by entering the following commandRestart the Apache Http Server for the changes take effect You can correct the error by entering the followingApache Http Server Status and Information Apachemodules definition should now look like the followingApache Server Information web page opens, as shown in Figure Apache Server Status web page opens, as shown in Figure# webalizer Apache Http Server Log# /etc/init.d/apache2 restart Create the following file Using Virtual Host SupportFor detailed information, see the Webalizer website at On the second server, create the following Html file Using Apache Http Server URL RedirectionConfigure virtual hosting by creating a file named Add the following lines to the preceding file Using Apache Http Server Proxy FeaturesEdit the following configuration file Add the following line to the preceding fileCreate the following Html file Error Responses and RedirectsPopulate the preceding file with the following lines Using Per-User Web DirectoriesIntegrating the Web Server Stack Components Configuring the Apache and Tomcat ConnectorHttp//YOURHOSTNAME/jsp-examples Restart Apache by entering the following commandIf there are any errors, check the following log files Insert the following line below the DocumentRoot lineCreate the following test file Integrating the Apache Web Server and PHPIntegrating the Apache Web Server and Perl # rpm -q php5 apache2-modphp5Web page displays the following text Connecting Tomcat to a DatabaseIntegrating the Apache Web Server and Python # tar zxf mysql-connector-java-version.tar.gz Connecting Tomcat and MySQL# /etc/init.d/mysql start # mysqladmin -u root -p create osmsdb# $CATALINAHOME/bin/startup.sh # ps -efgrep mysqldTest page opens as shown in Figure Connecting Tomcat and OracleIf needed, start Tomcat by entering the following command Http//YOURHOSTNAME8080/mysqltest.jspCreating an Oracle Data Source Obtaining and Installing the Oracle Jdbc DriverConfiguring the Oracle Server Testing the Oracle Database ConnectivityOracle Database Test Http//YOURHOSTNAME8080/oracleTest.jsp# mysql -u root -p Password Connecting Tomcat to MySQL or Oracle Using HibernateInstalling Hibernate, Tomcat, and JDK Configuring a Database Driver in TomcatFor an Oracle database server Creating a Simple Application in Tomcat# sqlplus osmsusr/osmspass@osmsdbora For a MySQL database serverAsm.jar asm-attrs.jar antlr-2.7.6rc1.jar File HibernateSessionFactory.class is generated This directory, create a Hibernate Pojo file named Preceding command creates a class file namedHttp//YOURHOSTNAME8080/SimpleDemo/hibernate.jsp Verifying the Simple Application OperationRestart Apache by entering the following Secure the Web Server StackEnabling Https Support in the Apache Http Server Create the following test Html file Apache Http Server AuthorizationApache default document root is Verify that the certificate is displayed as in FigureIf the login fails, the following message appears Protecting Apache Http Server Authorization with Symas CDSConfiguring Apache Http Server Services Html Head Protecting Tomcat Authorization with Symas CDSHtml Head # $CATALINA/bin/shutdown.sh # $CATALINA/bin/startup.sh Monitor Tomcat with OpenView Tomcat SPITomcat SPI Components Software Prerequisites and Reference GuidesPolicies ToolsComplete these steps Complete these steps # /sbin/SuSEfirewall2 stop Appendix B Frequently Asked QuestionsAppendix C Vendor Information Reference Appendix D Hibernate Test Application Source Code Following are the contents of the hibernate.jsp filePage Appendix D Hibernate Test Application Source Code