Bug 580042 - oracle database: RHQ Server failed to install on Oracle 10g with ORA-00972: identifier is too long error
Summary: oracle database: RHQ Server failed to install on Oracle 10g with ORA-00972: i...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Database
Version: 3.0.0
Hardware: All
OS: Linux
urgent
urgent
Target Milestone: ---
: ---
Assignee: Simeon Pinder
QA Contact: Corey Welton
URL:
Whiteboard:
Depends On: 580020
Blocks: rhq_triage 570453 jon-sprint8-bugs
TreeView+ depends on / blocked
 
Reported: 2010-04-07 11:23 UTC by Rajan Timaniya
Modified: 2010-08-12 16:53 UTC (History)
0 users

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

Attachments (Terms of Use)
screenshot (33.91 KB, image/png)
2010-04-07 11:23 UTC, Rajan Timaniya 		no flags Details
log file (14.15 KB, text/x-log)
2010-04-07 11:24 UTC, Rajan Timaniya 		no flags Details
View All

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.
Note You need to log in before you can comment on or make changes to this bug.