HP 5991-5565 manual Appendix D Hibernate Test Application Source Code

Page 57

{HibernateSessionFactory.closeSession(); } %>

<body><div align="center"><font size="7">OSMS Hibernate Test Page</font> <%initSession();%>

</div><h2>1.Retrieve data from table USERS via hibernate<br> <%showData(out,queryAll());%>

<h2>2.Insert firstname 'Smith',lastname 'Barney' into table USERS and show the query result via hibernate<br>

<%Long userId=insert();%> <%showData(out,queryAll());%>

<h2>3.Update lastname of the record which inserted in step 2 to 'root' and retrieve it via hibernate<br>

<%update(userId);%>

<%showData(out,queryAll());%>

<h2>4.Delete the test data then query again via hibernate<br> <%delete(userId);%>

<%showData(out,queryAll());%>

<%clean();%>

</body>

</html>

Appendix D: Hibernate Test Application Source Code 57

Image 57

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 Introduction HP ServicesExecutive Summary Intended AudienceHP Encourages Your Comments Typographic ConventionsUserInput Feedback@fc.hp.comWeb Server Stack Architecture HP Open Source Web Server Middleware StackWeb Server Stack Architecture Installing and Verifying the Linux Distribution Installing the Linux DistributionRequired Packages and Installation Recommendations YaST Software Selection and System Tasks Verifying the Linux Distribution InstallationInstalling and Configuring Sun JDK on an HP Proliant System Configuring the Basic Apache Http ServerTomcat # /etc/init.d/apache2 start# ln -s /usr/java/jdk1.5.010 /usr/local/jdk For the alljava.sh file, add the following linesFor the alljava.csh file, add the following lines # java -version Installing and Configuring TomcatFollowing messages appear # /usr/local/apache-tomcat/bin/startup.shUsing the Apache Http Server Benchmarking Tool Advanced Apache Http Server FeaturesIf necessary, stop Tomcat by entering the following command # /usr/local/apache-tomcat/bin/shutdown.shApache Http Server Status and Information You can correct the error by entering the followingApachemodules definition should now look like the following Restart the Apache Http Server for the changes take effectApache Server Information web page opens, as shown in Figure Apache Server Status web page opens, as shown in FigureApache Http Server Log # /etc/init.d/apache2 restart# webalizer Using Virtual Host Support For detailed information, see the Webalizer website atCreate the following file Using Apache Http Server URL Redirection Configure virtual hosting by creating a file namedOn the second server, create the following Html file Edit the following configuration file Using Apache Http Server Proxy FeaturesAdd the following line to the preceding file Add the following lines 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 ConnectorIf there are any errors, check the following log files Restart Apache by entering the following commandInsert the following line below the DocumentRoot line Http//YOURHOSTNAME/jsp-examplesIntegrating the Apache Web Server and Perl Integrating the Apache Web Server and PHP# rpm -q php5 apache2-modphp5 Create the following test fileConnecting Tomcat to a Database Integrating the Apache Web Server and PythonWeb page displays the following text # tar zxf mysql-connector-java-version.tar.gz Connecting Tomcat and MySQL# $CATALINAHOME/bin/startup.sh # mysqladmin -u root -p create osmsdb# ps -efgrep mysqld # /etc/init.d/mysql startIf needed, start Tomcat by entering the following command Connecting Tomcat and OracleHttp//YOURHOSTNAME8080/mysqltest.jsp Test page opens as shown in FigureConfiguring the Oracle Server Obtaining and Installing the Oracle Jdbc DriverTesting the Oracle Database Connectivity Creating an Oracle Data SourceOracle Database Test Http//YOURHOSTNAME8080/oracleTest.jspInstalling Hibernate, Tomcat, and JDK Connecting Tomcat to MySQL or Oracle Using HibernateConfiguring a Database Driver in Tomcat # mysql -u root -p Password# sqlplus osmsusr/osmspass@osmsdbora Creating a Simple Application in TomcatFor a MySQL database server For an Oracle 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 OperationSecure the Web Server Stack Enabling Https Support in the Apache Http ServerRestart Apache by entering the following Apache default document root is Apache Http Server AuthorizationVerify that the certificate is displayed as in Figure Create the following test Html fileIf 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