configuring database connectivity in websphere for oracle


i need web sources or links for configuring database connectivity in websphere for oracle, and can i use oracle 10g express edition.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gkmadhavAuthor Commented:
thanks honorGod, but actually i have seen this source, could i get a better source with detailed explanation.
Here is the custom database configuration for a custom application:
It does provide the basic information though.
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

gkmadhavAuthor Commented:
the link provides good info. also can i use oracle 10g express edition for the Oracle Database.
HonorGodSoftware EngineerCommented:
What version of WebSphere are we talking about?
gkmadhavAuthor Commented:
WebSphere 5.0 or even 4.0
HonorGodSoftware EngineerCommented:
To find out if a particular version of WebSphere (e.g., 5.0) supports a specific database product, start by looking at the WebSphere Application Server support page:

At the bottom of the page, under the section labelled "Other valuable resources", look for the "Detailed system requirements" link (which happens to be under the "Planning upgrades" group)

On the "Detailed system requirements" page, select the link that is appropriate for the version of WebSphere being investigated, e.g., "Software requirements" under "Version 5.0.2 Application Server".

On this page, use the "Application Server" link to get to the specific page related to this product.

This page has a table that identifies the supported products, and the Operating System (platforms) on which they might be supported.

Scroll down, and locate the portion of the table with the "Databases" heading.

This section identifies that only Oracle 8i and 9i might be supported.
Please note, however, that this information reflects the database versions that were available at the time the product was being developed, and tested.  IBM doesn't "go back" and add support for newer product versions that become available after a WebSphere version is delivered.

Looking at other versions of WebSphere, we see that support for Oracle 10g is shown in the detailed requirements table for WebSphere Application Server 6.0, but not for WebSphere Application Server 5.1.  This leads me to believe that it (Oracle 10g) became available sometime after 5.1 was delivered, and before 6.0, so that it was available to the IBM WebSphere development and test teams.

Hopefully this helps.

By the way,  if we use the "Product support lifecycle" link from the WebSphere Application Server support page, we can see that V 5.0 went "out of support" on 30-Sep-2006, and that V 5.1 goes "out of support" on 26-Sep-2008.  Just something to consider...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gkmadhavAuthor Commented:
thanks bro, thats a good explanantion.
HonorGodSoftware EngineerCommented:
You are very welcome.  I'm glad to be able to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.