Welcome!

IBM Cloud Authors: Pat Romanski, Peter Silva, Sarah Patrick, Liz McMillan, Carmen Gonzalez

Related Topics: IBM Cloud

IBM Cloud: Article

Running WSAD and WAS with Oracle

Running WSAD and WAS with Oracle

During a recent EAI project, it came to my attention that it is difficult to find documentation on the topic of installing Oracle into WebSphere Studio Application Developer (WSAD) and WebSphere Application Server (WAS) 5.0. This article will attempt to expedite the search for this information by discussing both installation processes.

WSAD
Step 1: Install Oracle

The first step is to install the Oracle drivers and the tnsnames.ora file into our system. To do this, install the Oracle client onto the machine that contains WSAD by following the instructions provided by Oracle. For simplicity's sake, this article assumes use of the defaults provided by the Oracle installation wizard.

Step 2: Set Up the Default User Password
This is part of the new J2C security configuration and it is located on the Security tab. In this section, we will create a user ID and password and assign it to an alias ID. This alias is required in Step 5.

  • Select the Security tab. It is located three tabs to the right of the Data Source tab.
  • Next, add a JAAS Authentication Entry by selecting the Add button next to JAAS Authentication Entries.
  • Fill in the following information and select the OK button:
    -Alias: OracleUser
    -User ID: The Oracle-defined user ID
    -Password: The password for the Oracle user
    -Description: Default Oracle user

    Step 3: Create a Server and Configuration
    WSAD uses an embedded server to test development code. To use this server we must first create a new server and configuration. Create a new server by selecting New -> Other -> Server/Configuration from the menu.

    On the first screen enter Test Server as the server name and select Test Environment as the server type. Use the default port of 9080 and click on the Finish button. This will create a new server and configuration in the Server Configuration screen located in the lower panel of WSAD.

    Step 4: Add the JDBC Driver
    This step will link the Oracle driver we installed in Step 1 to the newly created server/configuration.

  • First, select the server and select the Data Source tab. This tab sets the configuration on the server.
  • From the Data Source tab of the server configuration, select the Add button. This will display a list of databases.
  • From this list, select the Oracle database; this will populate the provider types.
  • From the provider types list, select JDBC:Thin:Driver.
  • Select the Next button and assign the name OracleThinDriver to this driver.
  • Finally, select the Finish button.

    Step 5: Add the Data Source
    The data source is where we assign the JNDI name and alias users.

  • First, highlight the JDBC provider that we created in Step 3 and select the Add button.
  • A popup window will appear that requires the selection of a type of driver; here again, select JDBC:Thin: Driver.
  • We have two options available on this screen, enabling us to select a version 5.0 data source or a version 4.0 data source. In this article, we are concerned only with new functionality and therefore will not be discussing the 4.0 setup. Select the 5.0 data source and then click the Next button.
  • Leave the name and JNDI at their default values.
  • Select the Alias list box and choose the alias created in Step 2, OracleUser. Add this alias to both types of authentication.
  • Finally, select the Finish button.

    Step 6: Edit the Resource
    The only required field in the Resources screen is the URL. This field is used by the server to look up the tnsnames.ora file and find the port to the database. Select the URL and make the following modification.

    The URL format is jdbc:oracle:thin: @xxx.xxx.xxx.xxx:1521:dbalias. This URL is broken into four sections delimited by colons. The URL is defined as follows:

    • Provider type
    • Oracle host IP address
    • Oracle listener port
    • Oracle database name
    This URL needs to match the Oracle configuration for your installation. It is essential that these fields match the corresponding tnsnames.ora file. If any of the information is incorrect, you'll receive errors.

    Figure 1 is an example of the completed data source.

    Now that we've configured our WSAD environment, we can proceed to testing. This can be completed in six steps:
    1.  Create a new Web project.
    2.  Copy the servlet code from Listing 1 into your new Web project. Modify the table name and column name in the servlet code to match the table and columns in your database.
    3.  Modify the user ID and password to match your database.
    4.  Modify your web.xml to initialize the servlet on startup.
    5.  Publish the project to the server/ configuration we created earlier.
    6.  Start the server.

    If successful, the server console will now display the output of our table.

    WAS
    The Admin Console is now run through the Deployment Manager. We will not go into detail on this process, as that is out of scope for this article. However, it is important to understand that all configuration management is handled via the Deployment Manager. If you would like more information on this topic, refer to the IBM Redbook (SG24-6195-00), titled "IBM WebSphere Version 5.0 System Management and Configuration."

    Step 1: Install Oracle
    We must install the Oracle drivers on each application server. The Oracle driver is a server resource and the Deployment Manager does not manage it. To do this, install the Oracle client onto the machine that contains WAS by following the instructions provided by Oracle. As before, use the defaults provided by the Oracle installation wizard.

    Step 2: Create the J2C Default User ID and Password
    Now we need to set up our alias, which will be required in Step 5.

  • Start the application server and deployment manager, and log in to the Admin Console.
  • Select the Security link.
  • Next, select the JAAS Configuration link. A list of menu options should be displayed.
  • Select the J2C Authentication Data link, which will pop up a screen that displays the J2C authentication data entries.
  • Select the New button and a window will display that enables the input of the alias information. Fill in the following information and select the OK button:
    -Alias: OracleUser
    -User ID: The user ID that you have set up in Oracle
    -Password: The password that you have set up in Oracle for the user ID above
    -Description: Default Oracle user

    Step 3: Add the JDBC Driver

  • Expand the Resources tree and select the JDBC providers. This brings up the screen that requires the selection of a scope. You must select a scope and then the Apply button. If you do not select the Apply button, none of the modifications made in the next few steps will be propagated to the correct scope.
  • In this exercise, we will propagate the changes at the cell level, which implies that the changes propagate to all nodes and servers within the given cluster. Select the Apply button and then the New button.
  • A screen will appear that displays a list of JDBC providers. Select the Oracle JDBC Thin Driver and then the OK button.
  • On the next screen, we will accept the defaults values; notice that the classpath has a path variable for Oracle. We will set up this variable in Step 5.
  • Finally, select the OK button.

    Step 4: Add the Data Source

  • Select the JDBC driver from the list of installed drivers.
  • Select the Data Source link at the bottom of the page. Select the version 5.0 data source. This is marked as "Data Source" on the screen, while the version 4 data source is marked as "Data Source (version 4.0)."
  • Next, assign the JNDI name to the data source. Click the New button and a screen will appear that requires the input of the name and JNDI name. The application server does not put any default values into these fields. We will enter the same values that were the defaults in the WSAD example. For name enter data source 1, and for JNDI name enter jdbc/ds1.
  • Select the list box on Container Managed and select the alias created in Step 2.
  • Press the OK button

    Step 5: Add the Resource

  • Select the Data Source link. This will display the data source panel.
  • Scroll to the bottom of the screen and select the Custom properties link.
  • The only required field is the URL; therefore, select the URL from the Name column.
  • The URL format is: jdbc:oracle: thin:@xxx.xxx.xxx.xxx:1521:dbalias. This URL should be defined in the same manner as in WSAD Step 6.
  • Input the correct data into the URL value field and select the OK button.
  • Select the Save option in the upper right-hand corner to save the configuration to the master configuration file. This will propagate the configuration to the nodes within the cluster

    Step 6: Create the JDBC Driver Environment Variable
    The final step is to create an environment variable that enables WAS to access the JDBC driver.

  • First, select the Environment link on the left toolbar.
  • Next, select the Manage WebSphere Variables link. This will display a list of variables managed by WebSphere. We must remember to select the scope of the change as we did for setting up the data source.
  • Select cell level and press the Apply button.
  • Select the ORACLE_JDBC_DRIVER_PATH.
  • Modify the value to correspond to the location of your Oracle driver. The default is "c:\oracle\ora81\jdbc\lib".
  • Select the Save button in the upper right-hand corner.

    Now that we have configured our WAS environment, we need to test our configuration. This can be completed in six easy steps:
    1.  Create a new Web project.
    2.  Copy the servlet code as before into your new Web project. Modify the table name and column name in the servlet code to match the table and columns in your database.
    3.  Modify your web.xml to initialize the servlet on startup.
    4.  Create a WAR file wrapping the servlet code for deployment.
    5.  Install the WAR file into WAS as a new enterprise application.
    6.  Start the application.

    If we were successful, the log files of your server console should display our table information.

  • More Stories By Troy Holmes

    My name is Troy Holmes, I live in Northern Virginia. I have been working in the IT industry for 14 years currently working as a J2EE architect using Websphere 5.0. I have completed several large scale J2EE applications using both BEA and WebSphere. I am a certified Java Programmer, currently preparing for SCWCD and SCJA. I have been working in the java environment for 5 years. I am proficient in Java, C++, Power builder, VB, Unix Shell. I have more then 5 years experience in Oracle and 2 years experience in Informix. My professional background ranges from System Administrator to System Architect.

    Comments (2) View Comments

    Share your thoughts on this story.

    Add your comment
    You must be signed in to add a comment. Sign-in | Register

    In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


    Most Recent Comments
    Pallavi 09/15/04 02:04:49 PM EDT

    Very good article. I had lots of problems with Oracle and WSAD connectivity. This article helped me to solve all the problems!

    Jesse Aalberg 07/31/03 08:47:00 PM EDT

    You think this is an obscure topic, try finding some info on using Oracle 9i JDBC OCI driver! FWIW, the KEY difference when using this driver is the DataSource URL. It must be jdbc:oracle:oci:@ , where is the entry in your tnsnames.ora file.

    I've spent so much time trying to get this to work, and have only recently accomplished it. Just thought I'd share.

    @ThingsExpo Stories
    One of the bewildering things about DevOps is integrating the massive toolchain including the dozens of new tools that seem to crop up every year. Part of DevOps is Continuous Delivery and having a complex toolchain can add additional integration and setup to your developer environment. In his session at @DevOpsSummit at 18th Cloud Expo, Miko Matsumura, Chief Marketing Officer of Gradle Inc., will discuss which tools to use in a developer stack, how to provision the toolchain to minimize onboa...
    Companies can harness IoT and predictive analytics to sustain business continuity; predict and manage site performance during emergencies; minimize expensive reactive maintenance; and forecast equipment and maintenance budgets and expenditures. Providing cost-effective, uninterrupted service is challenging, particularly for organizations with geographically dispersed operations.
    SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 ad...
    Join us at Cloud Expo | @ThingsExpo 2016 – June 7-9 at the Javits Center in New York City and November 1-3 at the Santa Clara Convention Center in Santa Clara, CA – and deliver your unique message in a way that is striking and unforgettable by taking advantage of SYS-CON's unmatched high-impact, result-driven event / media packages.
    SYS-CON Events announced today that Commvault, a global leader in enterprise data protection and information management, has been named “Bronze Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Commvault is a leading provider of data protection and information management...
    There will be new vendors providing applications, middleware, and connected devices to support the thriving IoT ecosystem. This essentially means that electronic device manufacturers will also be in the software business. Many will be new to building embedded software or robust software. This creates an increased importance on software quality, particularly within the Industrial Internet of Things where business-critical applications are becoming dependent on products controlled by software. Qua...
    With an estimated 50 billion devices connected to the Internet by 2020, several industries will begin to expand their capabilities for retaining end point data at the edge to better utilize the range of data types and sheer volume of M2M data generated by the Internet of Things. In his session at @ThingsExpo, Don DeLoach, CEO and President of Infobright, will discuss the infrastructures businesses will need to implement to handle this explosion of data by providing specific use cases for filte...
    SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Avere delivers a more modern architectural approach to storage that doesn’t require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbuilding of data centers ...
    SYS-CON Events announced today that Pythian, a global IT services company specializing in helping companies adopt disruptive technologies to optimize revenue-generating systems, has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. Founded in 1997, Pythian is a global IT services company that helps companies compete by adopting disruptive technologies such as cloud, Big Data, advanced analytics, and DevO...
    SYS-CON Events announced today that Alert Logic, Inc., the leading provider of Security-as-a-Service solutions for the cloud, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Alert Logic, Inc., provides Security-as-a-Service for on-premises, cloud, and hybrid infrastructures, delivering deep security insight and continuous protection for customers at a lower cost than traditional security solutions. Ful...
    Fortunately, meaningful and tangible business cases for IoT are plentiful in a broad array of industries and vertical markets. These range from simple warranty cost reduction for capital intensive assets, to minimizing downtime for vital business tools, to creating feedback loops improving product design, to improving and enhancing enterprise customer experiences. All of these business cases, which will be briefly explored in this session, hinge on cost effectively extracting relevant data from ...
    SYS-CON Events announced today that iDevices®, the preeminent brand in the connected home industry, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. iDevices, the preeminent brand in the connected home industry, has a growing line of HomeKit-enabled products available at the largest retailers worldwide. Through the “Designed with iDevices” co-development program and its custom-built IoT Cloud Infrastruc...
    As enterprises work to take advantage of Big Data technologies, they frequently become distracted by product-level decisions. In most new Big Data builds this approach is completely counter-productive: it presupposes tools that may not be a fit for development teams, forces IT to take on the burden of evaluating and maintaining unfamiliar technology, and represents a major up-front expense. In his session at @BigDataExpo at @ThingsExpo, Andrew Warfield, CTO and Co-Founder of Coho Data, will dis...
    The Quantified Economy represents the total global addressable market (TAM) for IoT that, according to a recent IDC report, will grow to an unprecedented $1.3 trillion by 2019. With this the third wave of the Internet-global proliferation of connected devices, appliances and sensors is poised to take off in 2016. In his session at @ThingsExpo, David McLauchlan, CEO and co-founder of Buddy Platform, will discuss how the ability to access and analyze the massive volume of streaming data from mil...
    WebSocket is effectively a persistent and fat pipe that is compatible with a standard web infrastructure; a "TCP for the Web." If you think of WebSocket in this light, there are other more hugely interesting applications of WebSocket than just simply sending data to a browser. In his session at 18th Cloud Expo, Frank Greco, Director of Technology for Kaazing Corporation, will compare other modern web connectivity methods such as HTTP/2, HTTP Streaming, Server-Sent Events and new W3C event APIs ...
    SYS-CON Events announced today that Men & Mice, the leading global provider of DNS, DHCP and IP address management overlay solutions, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. The Men & Mice Suite overlay solution is already known for its powerful application in heterogeneous operating environments, enabling enterprises to scale without fuss. Building on a solid range of diverse platform support,...
    Eighty percent of a data scientist’s time is spent gathering and cleaning up data, and 80% of all data is unstructured and almost never analyzed. Cognitive computing, in combination with Big Data, is changing the equation by creating data reservoirs and using natural language processing to enable analysis of unstructured data sources. This is impacting every aspect of the analytics profession from how data is mined (and by whom) to how it is delivered. This is not some futuristic vision: it's ha...
    Silver Spring Networks, Inc. (NYSE: SSNI) extended its Internet of Things technology platform with performance enhancements to Gen5 – its fifth generation critical infrastructure networking platform. Already delivering nearly 23 million devices on five continents as one of the leading networking providers in the market, Silver Spring announced it is doubling the maximum speed of its Gen5 network to up to 2.4 Mbps, increasing computational performance by 10x, supporting simultaneous mesh communic...
    The cloud promises new levels of agility and cost-savings for Big Data, data warehousing and analytics. But it’s challenging to understand all the options – from IaaS and PaaS to newer services like HaaS (Hadoop as a Service) and BDaaS (Big Data as a Service). In her session at @BigDataExpo at @ThingsExpo, Hannah Smalltree, a director at Cazena, will provide an educational overview of emerging “as-a-service” options for Big Data in the cloud. This is critical background for IT and data profes...
    With the Apple Watch making its way onto wrists all over the world, it’s only a matter of time before it becomes a staple in the workplace. In fact, Forrester reported that 68 percent of technology and business decision-makers characterize wearables as a top priority for 2015. Recognizing their business value early on, FinancialForce.com was the first to bring ERP to wearables, helping streamline communication across front and back office functions. In his session at @ThingsExpo, Kevin Roberts...