Bug 581818 - Database: No option available in 'Database Type' selection box to install 'Oracle 11g'
Summary: Database: No option available in 'Database Type' selection box to install 'Or...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Database
Version: 3.0.0
Hardware: All
OS: Linux
urgent
medium
Target Milestone: ---
: ---
Assignee: John Sanda
QA Contact: Corey Welton
URL:
Whiteboard:
Depends On:
Blocks: rhq_triage jon24-oracle11
TreeView+ depends on / blocked
 
Reported: 2010-04-13 10:54 UTC by Rajan Timaniya
Modified: 2010-08-12 16:57 UTC (History)
0 users

Fixed In Version: 2.4
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-08-12 16:57:28 UTC
Embargoed:


Attachments (Terms of Use)
screenshot (72.19 KB, image/png)
2010-04-13 10:54 UTC, Rajan Timaniya
no flags Details
screenshot (73.90 KB, image/png)
2010-05-21 10:04 UTC, Rajan Timaniya
no flags Details

Description Rajan Timaniya 2010-04-13 10:54:31 UTC
Created attachment 406204 [details]
screenshot

Description of problem:
JON installation don't have option for 'Oracle 11g' in 'Database Type' selection box.

Note: Workaround is, select 'Database Type = Oracle 10g' and install JON on Oracle 11g.

Version-Release number of selected component (if applicable):
jon build #88 Revision: 10607  (http://hudson-qe.rhq.rdu.redhat.com:8080/job/jon/88/)

How reproducible:
Always

Steps to Reproduce:
1) Start JON Server and open JON installation screen
  
Actual results:
JON installation don't have option for 'Oracle 11g' in 'Database Type' selection box.

Expected results:
JON installation should have option for 'Oracle 11g' in 'Database Type' selection box.

Additional info:
Please refer attached screenshot.

Comment 1 Charles Crouch 2010-04-19 17:07:14 UTC
Do we actually have any implementation differences between 10 and 11 on the backend? If not we should just change the label to say Oracle10/11

Comment 2 Charles Crouch 2010-05-18 04:44:43 UTC
I'm not aware of any impl differences to so the label in the installer should be updated to be "Oracle 10/11"

Comment 3 John Sanda 2010-05-20 15:07:48 UTC
The option label in the database type dropdown has been changed to Oracle 10/11.

commit hash: c74e03dfeac5dfdb6ea6e868ac645144e6cf0b64

Comment 4 Rajan Timaniya 2010-05-21 10:03:45 UTC
Description of problem:
JON installation don't have option for 'Oracle 10/11' in 'Database Type'
selection box.


Version-Release number of selected component (if applicable):
JON build# 160 - Revision: 10620
http://hudson-qe.rhq.rdu.redhat.com:8080/job/jon/160/

How reproducible:
Always

Steps to Reproduce:
1) Start JON Server and open JON installation screen
2) Select 'Oracle' in 'Database Type'

Actual results:
1) JON installation don't have option for 'Oracle' in 'Database Type'
selection box.
2) 'Database Type' selection is 'Oracle' then also JON installation screen shows postgres values for following parameter:
    Database Connection URL
    Database JDBC Driver Class
    Database XA DataSource Class 

Expected results:
1) JON installation should have option for 'Oracle 10/11' in 'Database Type' selection box.
2) If 'Database Type' selection is 'Oracle' then JON installation screen should shows oracle values for following parameter:
    Database Connection URL
    Database JDBC Driver Class
    Database XA DataSource Class 

Additional info:
Please refer attached screenshot.

Comment 5 Rajan Timaniya 2010-05-21 10:04:17 UTC
Created attachment 415633 [details]
screenshot

Comment 6 John Sanda 2010-05-21 13:45:38 UTC
I talked with Charles and Ian and made the decision to change the label to just 'Oracle' since the db properties are the same for 10g and 11g. And Ian pointed out that this is consistent with other database types where we leave off the version number.

I just pushed a commit to update the javascript for showing oracle valuess for db connection url, driver class, and xa data source class when the oracle db type is selected.

commit hash: 9ddd31c129230f1c6a0a86dad741387beb0bf955

Comment 7 Rajan Timaniya 2010-05-26 11:30:30 UTC
Verified on JON build #169 - Revision: 10621

1) JON installation has option for 'Oracle' in 'Database Type'
selection box.
2) If 'Database Type' selection is 'Oracle' then JON installation screen shows oracle values for following parameter:
    Database Connection URL
    Database JDBC Driver Class
    Database XA DataSource Class

Comment 8 Corey Welton 2010-08-12 16:57:28 UTC
Mass-closure of verified bugs against JON.


Note You need to log in before you can comment on or make changes to this bug.