+++ 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.
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.