Red Hat Bugzilla – Full Text Bug Listing
|Summary:||Cannot delete a package in a new created Repositories|
|Product:||[Other] RHQ Project||Reporter:||Larry O'Leary <loleary>|
|Component:||Content||Assignee:||RHQ Project Maintainer <rhq-maint>|
|Status:||CLOSED WONTFIX||QA Contact:||Mike Foley <mfoley>|
|Version:||4.5||CC:||bkramer, hrupp, loleary|
|Fixed In Version:||Doc Type:||Bug Fix|
|Doc Text:||Story Points:||---|
|Last Closed:||2014-10-30 10:05:22 EDT||Type:||Bug|
|oVirt Team:||---||RHEL 7.3 requirements from Atomic Host:|
|Bug Depends On:|
Description Larry O'Leary 2012-11-20 13:22:03 EST
+++ This bug was initially created as a clone of JBoss ON Bug #877032 +++ Description of problem: When Oracle is used as a backend database, attempt to delete newly created package in a repository fails with the following Exception: Failed to delete packages: [I@7d7cec2f from repository: 10051 Error: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query In the rhq-server-log4j.log file the following is logged: 2012-11-15 14:49:19,381 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 920, SQLState: 42000 2012-11-15 14:49:19,382 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00920: invalid relational operator Version-Release number of selected component (if applicable): JON 3.1.1 Oracle How reproducible: always Steps to Reproduce: 1. Navigate to Administration -> Content -> Repositories and create new repository; 2. In the new repository, create new package; 3. Attempt to delete newly created package; Actual results: Newly created package is not deleted with above Exception Expected results: Newly created package is successfully deleted. Additional info: Tested the same on Postgres - works fine.
Comment 1 Larry O'Leary 2014-10-30 10:05:22 EDT
Closing as per downstream comment: https://bugzilla.redhat.com/show_bug.cgi?id=877032#c2 > This seems to work fine with Oracle 11g, which is the minimum supported version for JON 3.3. > > Tested both with RHQ 4.12.0-SNAPSHOT and JON 3.2.1.