|By Troy Holmes||
|July 23, 2003 12:00 AM EDT||
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.
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.
-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.
Step 5: Add the Data Source
The data source is where we assign the JNDI name and alias users.
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
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.
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.
-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
Step 4: Add the Data Source
Step 5: Add the Resource
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.
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.
|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.
SYS-CON Events announced today that Site24x7, the cloud infrastructure monitoring service, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Site24x7 is a cloud infrastructure monitoring service that helps monitor the uptime and performance of websites, online applications, servers, mobile websites and custom APIs. The monitoring is done from 50+ locations across the world and from various wireless carriers, thus providing a global perspective of the end-user experience. Site24x7 supports monitoring H...
Apr. 21, 2015 02:30 AM EDT Reads: 1,895
SYS-CON Events announced today that Intelligent Systems Services will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Established in 1994, Intelligent Systems Services Inc. is located near Washington, DC, with representatives and partners nationwide. ISS’s well-established track record is based on the continuous pursuit of excellence in designing, implementing and supporting nationwide clients’ mission-critical systems. ISS has completed many successful projects in Healthcare, Commercial, Manufacturing, ...
Apr. 21, 2015 02:15 AM EDT Reads: 2,474
WebRTC is an up-and-coming standard that enables real-time voice and video to be directly embedded into browsers making the browser a primary user interface for communications and collaboration. WebRTC runs in a number of browsers today and is currently supported in over a billion installed browsers globally, across a range of platform OS and devices. Today, organizations that choose to deploy WebRTC applications and use a host machine that supports audio through USB or Bluetooth can use Plantronics products to connect and transit or receive the audio associated with the WebRTC session.
Apr. 21, 2015 02:00 AM EDT Reads: 1,708
The best mobile applications are augmented by dedicated servers, the Internet and Cloud services. Mobile developers should focus on one thing: writing the next socially disruptive viral app. Thanks to the cloud, they can focus on the overall solution, not the underlying plumbing. From iOS to Android and Windows, developers can leverage cloud services to create a common cross-platform backend to persist user settings, app data, broadcast notifications, run jobs, etc. This session provides a high level technical overview of many cloud services available to mobile app developers, includi...
Apr. 21, 2015 02:00 AM EDT Reads: 646
SYS-CON Events announced today that B2Cloud, a provider of enterprise resource planning software, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. B2cloud develops the software you need. They have the ideal tools to help you work with your clients. B2Cloud’s main solutions include AGIS – ERP, CLOHC, AGIS – Invoice, and IZUM
Apr. 21, 2015 02:00 AM EDT Reads: 3,295
The WebRTC Summit 2015 New York, to be held June 9-11, 2015, at the Javits Center in New York, NY, announces that its Call for Papers is open. Topics include all aspects of improving IT delivery by eliminating waste through automated business models leveraging cloud technologies. WebRTC Summit is co-located with 16th International Cloud Expo, @ThingsExpo, Big Data Expo, and DevOps Summit.
Apr. 21, 2015 01:45 AM EDT Reads: 2,325
SYS-CON Events announced today that Tufin, the market-leading provider of Security Policy Orchestration Solutions, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. As the market leader of Security Policy Orchestration, Tufin automates and accelerates network configuration changes while maintaining security and compliance. Tufin's award-winning Orchestration Suite™ gives IT organizations the power and agility to enforce security policy across complex, multi-vendor enterprise networks. With more than 1...
Apr. 21, 2015 01:45 AM EDT Reads: 3,425
As enterprises move to all-IP networks and cloud-based applications, communications service providers (CSPs) – facing increased competition from over-the-top providers delivering content via the Internet and independently of CSPs – must be able to offer seamless cloud-based communication and collaboration solutions that can scale for small, midsize, and large enterprises, as well as public sector organizations, in order to keep and grow market share. The latest version of Oracle Communications Unified Communications Suite gives CSPs the capability to do just that. In addition, its integration ...
Apr. 21, 2015 01:30 AM EDT Reads: 4,058
SYS-CON Events announced today that Cloudian, Inc., the leading provider of hybrid cloud storage solutions, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Cloudian, Inc., is a Foster City, California - based software company specializing in cloud storage software. The main product is Cloudian, an Amazon S3-compliant cloud object storage platform, the bedrock of cloud computing systems, that enables cloud service providers and enterprises to build reliable, affordable and scalable cloud storage solu...
Apr. 21, 2015 01:00 AM EDT Reads: 2,508
SYS-CON Events announced today that Gridstore™, the leader in hyper-converged infrastructure purpose-built to optimize Microsoft workloads, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Gridstore™ is the leader in hyper-converged infrastructure purpose-built for Microsoft workloads and designed to accelerate applications in virtualized environments. Gridstore’s hyper-converged infrastructure is the industry’s first all flash version of HyperConverged Appliances that include both compute and storag...
Apr. 21, 2015 12:45 AM EDT Reads: 4,427
SYS-CON Events announced today that IDenticard will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. IDenticard™ is the security division of Brady Corp (NYSE: BRC), a $1.5 billion manufacturer of identification products. We have small-company values with the strength and stability of a major corporation. IDenticard offers local sales, support and service to our customers across the United States and Canada. Our partner network encompasses some 300 of the world's leading systems integrators and security s...
Apr. 21, 2015 12:00 AM EDT Reads: 5,011
BroadSoft on Tuesday announced that it is a recipient of the 2014 Frost & Sullivan Market Leadership Award in the Hosted/Cloud Internet Protocol (IP) Telephony market for Latin America. According to Frost & Sullivan market research, the Latin America (LATAM) hosted/cloud Internet Protocol (IP) telephony market, including integrated unified communications and collaboration (UC&C) applications, is currently experiencing a rapid growth trajectory and is expected to exhibit a tenfold rise in annual revenues in the 2013-2020 period. With more than 600 cloud deployments internationally, BroadSoft w...
Apr. 21, 2015 12:00 AM EDT Reads: 2,084
In 2015, 4.9 billion connected "things" will be in use. By 2020, Gartner forecasts this amount to be 25 billion, a 410 percent increase in just five years. How will businesses handle this rapid growth of data? Hadoop will continue to improve its technology to meet business demands, by enabling businesses to access/analyze data in real time, when and where they need it. Cloudera's Chief Technologist, Eli Collins, will discuss how Big Data is keeping up with today's data demands and how in the future, data and analytics will be pervasive, embedded into every workflow, application and infra...
Apr. 20, 2015 10:45 PM EDT Reads: 975
Participants will reach the final if their IoT solution is liked. A community vote will determine the best solutions submitted in each country, after which an expert jury will select the national winners and the best international IoT solution. Each country's best solution can win a national marketing campaign worth up to €30,000 and become a partner in Deutsche Telekom's participating markets. The winning international solution can become partner of Deutsche Telekom Group across all eight countries and reach out to a potential of 10,8 million business customers. Deutsche Telekom Group has a...
Apr. 20, 2015 05:00 PM EDT Reads: 856
Health care systems across the globe are under enormous strain, as facilities reach capacity and costs continue to rise. M2M and the Internet of Things have the potential to transform the industry through connected health solutions that can make care more efficient while reducing costs. In fact, Vodafone's annual M2M Barometer Report forecasts M2M applications rising to 57 percent in health care and life sciences by 2016. Lively is one of Vodafone's health care partners, whose solutions enable older adults to live independent lives while staying connected to loved ones. M2M will continue to gr...
Apr. 20, 2015 03:00 PM EDT Reads: 1,122
SYS-CON Events announced today that Vicom Computer Services, Inc., a provider of technology and service solutions, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. They are located at booth #427. Vicom Computer Services, Inc. is a progressive leader in the technology industry for over 30 years. Headquartered in the NY Metropolitan area. Vicom provides products and services based on today’s requirements around Unified Networks, Cloud Computing strategies, Virtualization around Software defined Data Ce...
Apr. 20, 2015 02:00 PM EDT Reads: 1,484
Dave will share his insights on how Internet of Things for Enterprises are transforming and making more productive and efficient operations and maintenance (O&M) procedures in the cleantech industry and beyond. Speaker Bio: Dave Landa is chief operating officer of Cybozu Corp (kintone US). Based in the San Francisco Bay Area, Dave has been on the forefront of the Cloud revolution driving strategic business development on the executive teams of multiple leading Software as a Services (SaaS) application providers dating back to 2004. Cybozu's kintone.com is a leading global BYOA (Build Your O...
Apr. 20, 2015 02:00 PM EDT Reads: 1,151
VoxImplant has announced full WebRTC support in the newest versions of its Android SDK and iOS SDK. The updated SDKs, which enable audio and video calls on mobile devices, are now compatible with the WebRTC standard to allow any mobile app to communicate with WebRTC-enabled browsers, including Google Chrome, Mozilla Firefox, Opera, and, when available, Microsoft Spartan. The WebRTC-updated SDKs represent VoxImplant's continued leadership in simplifying the development of real-time communications (RTC) services for app developers. VoxImplant (built by Zingaya, the real-time communication servi...
Apr. 20, 2015 12:45 PM EDT Reads: 1,984
What exactly is a cognitive application? In her session at 16th Cloud Expo, Ashley Hathaway, Product Manager at IBM Watson, will look at the services being offered by the IBM Watson Developer Cloud and what that means for developers and Big Data. She'll explore how IBM Watson and its partnerships will continue to grow and help define what it means to be a cognitive service, as well as take a look at the offerings on Bluemix. She will also check out how Watson and the Alchemy API team up to offer disruptive APIs to developers.
Apr. 20, 2015 12:00 PM EDT Reads: 1,595
The IoT Bootcamp is coming to Cloud Expo | @ThingsExpo on June 9-10 at the Javits Center in New York. Instructor. Registration is now available at http://iotbootcamp.sys-con.com/ Instructor Janakiram MSV previously taught the famously successful Multi-Cloud Bootcamp at Cloud Expo | @ThingsExpo in November in Santa Clara. Now he is expanding the focus to Janakiram is the founder and CTO of Get Cloud Ready Consulting, a niche Cloud Migration and Cloud Operations firm that recently got acquired by Aditi Technologies. He is a Microsoft Regional Director for Hyderabad, India, and one of the f...
Apr. 20, 2015 12:00 PM EDT Reads: 1,311