Manuals / Brands / Computer Equipment / Network Card / HP / Computer Equipment / Network Card

HP 5991-5565 Obtaining and Installing the Oracle JDBC Driver, Creating an Oracle Data Source, Configuring the Oracle Server, Testing the Oracle Database Connectivity, SQL

1 57

Download 57 pages, 1.18 Mb

layer for web applications. A JDBC connector for Oracle is needed to integrate an external Oracle Database server with the Tomcat Web server. This section describes the steps for connecting the Tomcat Web server to an Oracle database.

Obtaining and Installing the Oracle JDBC Driver

Perform the following steps from the Tomcat Web server:

1.Download the JDBC driver for Oracle 10g Release 2 from the Oracle website at: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

NOTE: For the Oracle JDBC driver with JDK 1.4 and 1.5, use the ojdbc14.jar file.

2.Copy the JDBC driver to the Tomcat environment by entering the following command:

# cp ojdbc14.jar $CATALINA_HOME/common/lib

Creating an Oracle Data Source

To create a data source binding for the Oracle JDBC driver data source, perform the following on the Tomcat Web server:

Create a file named $CATALINA_HOME/conf/context.xml and insert the following lines:

<Context>

…

<Resource name="jdbc/oracleDB" type="javax.sql.DataSource" password="<DB_PASSWORD>"

driverClassName="oracle.jdbc.driver.OracleDriver" maxIdle="2" maxWait="5000" username="<DB_USERNAME>"

url="jdbc:oracle:thin:@ <IP_OR_NAME_OF_ORACLE_SERVER>:1521:<ORACLE_SID>" maxActive="4"/> </Context>

For example:

<Resource name="jdbc/oracleDB" type="javax.sql.DataSource" password="osmspass"

driverClassName="oracle.jdbc.driver.OracleDriver" maxIdle="2" maxWait="5000" username="osmsusr" url="jdbc:oracle:thin:@192.168.1.100:1521:OSMSDB" maxActive="4"/>

Configuring the Oracle Server

Perform the following steps on the Oracle Database server:

1.Verify that the Oracle server and the listener are running by entering the following command:

#lsnrctl status

2.Create a database user and grant the proper privileges, which should be the same as the user in the $CATALINA_HOME/conf/context.xml file, by entering the following commands:

#sqlplus / as sysdba

SQL> create user osmsusr identified by osmspass;

SQL> grant connect,resource to osmsusr;

Testing the Oracle Database Connectivity

Test the connectivity between the Tomcat server and the Oracle database by performing the following steps on the Tomcat Web server:

34

Contents

Page Page Table of Contents Using the Error Log to Diagnose the Apache HTTP Server Configuring the Apache and Tomcat Connector Connecting Tomcat to MySQL or Oracle Using Hibernate Apache HTTP Server Authorization Restarting the Apache HTTP Server Tomcat SPI Components Page Page Page Page Introduction Executive Summary Intended Audience Scope and Purpose HP Services Typographic Conventions HP Encourages Your Comments HP Open Source Web Server Middleware Stack Web Server Stack Architecture Figure 1 Web Server Stack Architecture Table 1 Software Test Configuration Installing and Verifying the Linux Distribution Installing the Linux Distribution Required Packages and Installation Recommendations Verifying the Linux Distribution Installation Installing, Configuring, and Managing Web Server Middleware Stack Components Configuring the Basic Apache HTTP Server Installing and Configuring Sun JDK on an HP Proliant System Download the Sun JDK package from the Java website and install as follows (see #chmod 755 jdk-1_5_0_10-linux-amd64-rpm.bin #./jdk-1_5_0_10-linux-amd64-rpm.bin 2.Create a symbolic link for Sun JDK by entering the following: #ln -s /usr/java/jdk1.5.0_10 /usr/local/jdk Installing and Configuring Tomcat Advanced Apache HTTP Server Features Using the Apache HTTP Server Benchmarking Tool Apache HTTP Server Status and Information <YOUR_WEB_SERVER_IP http://<YOUR_WEB_SERVER_IP>/server-info /server-info Apache HTTP Server Log Using Virtual Host Support Using Apache HTTP Server URL Redirection Using Apache HTTP Server Proxy Features Error Responses and Redirects Using Per-UserWeb Directories Integrating the Web Server Stack Components Configuring the Apache and Tomcat Connector 3.Insert the following line below the DocumentRoot line: <Connector server.xml <Service Verify that the following lines are included and not commented out in the Integrating the Apache Web Server and PHP Integrating the Apache Web Server and Perl Integrating the Apache Web Server and Python Connecting Tomcat to a Database Connecting Tomcat and MySQL Create a data source descriptor file named $CATALINA_HOME/conf/context.xml For example: 2.Start the Tomcat web server by entering the following command: # $CATALINA_HOME/bin/startup.sh Connecting Tomcat and Oracle Obtaining and Installing the Oracle JDBC Driver Creating an Oracle Data Source Configuring the Oracle Server Testing the Oracle Database Connectivity Verify that the Oracle test page is displayed http://<YOUR_HOSTNAME>:8080/oracleTest.jsp Figure 13 Oracle Database Test Connecting Tomcat to MySQL or Oracle Using Hibernate Installing Hibernate, Tomcat, and JDK Configuring a Database Driver in Tomcat Adding Test Data to the Databases Creating a Simple Application in Tomcat IP_OR_HOSTNAME_OF_DB_SERVER asm.jar asm-attrs.jar antlr-2.7.6rc1.jar Hibernate uses a configuration file named hibernate.cfg.xml Create a Hibernate configuration file named /osms/hibernate/utility Compile the HibernateSessionFactory.java #javac -cp$CATALINA_HOME/webapps/SimpleDemo /WEB-INF/lib/hibernate3.jarHibernateSessionFactory.java # cd $CATALINA_HOME/webapps/SimpleDemo/WEB-INF/classes\ /com/hp/osms/hibernate In this directory, create a Hibernate POJO file named $CATALINA_HOME/webapps/SimpleDemo/WEB-INF according to the mapping file for your application. Add the following lines: package com.hp.osms.hibernate; Verifying the Simple Application Operation Secure the Web Server Stack Enabling HTTPS Support in the Apache HTTP Server Apache HTTP Server Authorization Protecting Apache HTTP Server Authorization with Symas CDS NOTE: In the steps for this procedure: rootdn is set to rootpw in the Protecting Tomcat Authorization with Symas CDS Create a web application named in your Tomcat Web server by adding the following code to the file TIP: <Realm <Engine Monitor Tomcat with OpenView Tomcat SPI Software Prerequisites and Reference Guides Tomcat SPI Components Tools Policies Appendix A: Checklist for Building a Web Server Middleware Stack Page Appendix B: Frequently Asked Questions Appendix C: Vendor Information Reference Appendix D: Hibernate Test Application Source Code