ORA privlege errors when using JDBC persistence
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, tools, and much more.