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