ORA privlege errors when using JDBC persistence

Solution Unverified - Updated -

Issue

  • We are using AMQ 6.1 with JBOSS EAP6.3. We use JDBC persistance configuration with AMQ. Our backend is Oracle.

We are seeing the following exceptiom/error eventhough the tables are already created . We see this almost everytime we get the error. You can refer to case Case #01458516 which happens to have all the configuration files.

CREATE TABLE ACTIVEMQ_MSGS (ID NUMBER NOT NULL, CONTAINER VARCHAR (?), MSGID_PROD VARCHAR (?), MSGID_SEQ NUMBER, EXPIRATION NUMBER, MSG BLOB, PRIMARY KEY (ID)): java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges 
CREATE TABLE ACTIVEMQ_ACKS (CONTAINER VARCHAR (?) NOT NULL, SUB_DEST VARCHAR (?), CLIENT_ID VARCHAR (?) NOT NULL, SUB_NAME VARCHAR (?) NOT NULL, SELECTOR VARCHAR (?), LAST_ACKED_ID NUMBER, PRIMARY KEY (CONTAINER, CLIENT_ID, SUB_NAME)): java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges 

Could you please let us know why we get the privlege errors.

Environment

  • Red Hat JBoss A-MQ
    • 6.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.