AMQ 7: SQL syntax errors when starting broker, using JDBC persistence with Oracle RDBMS 11g and earlier

Solution verified - Updated on

Request a new translation or translation update

A translation for your language preference does not exist. Click below to request a translation for your selected language.

Submit request

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

Subscriber Exclusive Content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content