AMQ 7: SQL syntax errors when starting broker, using JDBC persistence with Oracle RDBMS 11g and earlier
Issue
The AMQ 7 broker has correctly been configured to use JDBC persistence, with Oracle RDBMS as the message store. However, on start-up, the broker fails with SQL syntax errors. For example:
Caused by: Error : 2000, Position : 40, Sql = CREATE TABLE MP(ID NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID)), OriginalSql = CREATE TABLE MP(ID NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID)), Error Msg = ORA-02000: missing ALWAYS keyword
Environment
- Red Hat AMQ 7
- All versions
- Oracle RDMBS
- 11g and earlier
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
