Bug 580042

Summary: oracle database: RHQ Server failed to install on Oracle 10g with ORA-00972: identifier is too long error
Product: [Other] RHQ Project Reporter: Rajan Timaniya <rtimaniy>
Component: DatabaseAssignee: Simeon Pinder <spinder>
Status: CLOSED CURRENTRELEASE QA Contact: Corey Welton <cwelton>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 3.0.0   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 2.4 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-08-12 16:53:07 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 580020    
Bug Blocks: 565628, 570453, 576714    
Attachments:
Description Flags
screenshot
none
log file none

Description Rajan Timaniya 2010-04-07 11:23:26 UTC 
Created attachment 404915 [details]
screenshot

Description of problem:
RHQ Server failed to install on Oracle 10g with java.sql.SQLException: ORA-00972: identifier is too long

Version-Release number of selected component (if applicable):
master (build #154) GIT Revision: dbb5bc7867d54c54b1037f43e9f69eac1b34c2b9

How reproducible:
Always

Steps to Reproduce:
1) Install RHQ Server on Oracle 10g
2) Provide all database connection parameters and make sure that test connection successful. 
3) Click on 'Install Server!'

Note: Test connection gives 'No suitable driver found for jdbc:oracle:thin:' error (Bug #580020), so I have copied classes12.jar to /rhq-server-3.0.0-SNAPSHOT/jbossas/server/default/lib.
  
Actual results:
RHQ Server failed to install on Oracle 10g with java.sql.SQLException: ORA-00972: identifier is too long

Expected results:
RHQ Server should install on Oracle 10g without any error 

Additional info:
Please refer attached screenshot and log files.
Comment 1 Rajan Timaniya 2010-04-07 11:24:12 UTC 
Created attachment 404916 [details]
log file
Comment 2 Simeon Pinder 2010-04-09 20:41:19 UTC 
Reproduced and fixed.

git 6804ccd91cad11dd7ee5863a74cc523643e89c89

updated sql to use valid oracle identifiers.

Installation completes now.

Should be fixed in valid builds of [master] >= 178.
Comment 3 Rajan Timaniya 2010-04-15 11:36:50 UTC 
Verified on JON build #88 - Revision: 10607

RHQ Server installed on Oracle 10g without java.sql.SQLException, so marking this bug as verified.
Comment 4 Corey Welton 2010-08-12 16:53:07 UTC 
Mass-closure of verified bugs against JON.