JBoss AMQ - error while configuring persistenceAdapter with postgreSQL - type "blob" does not exist
Issue
- While configuring AMQ to work with Postgresql drivers,
<persistenceAdapter>
<jdbcPersistenceAdapter dataSource="#postgresql-ds" lockKeepAlivePeriod="3000">
</jdbcPersistenceAdapter>
</persistenceAdapter>
- Following problem occurs while starting broker:
2017-03-01 10:24:52,980 | WARN | AMQ-1-thread-1 | DefaultJDBCAdapter | .jdbc.adapter.DefaultJDBCAdapter 117 | 137 - org.apache.activemq.activemq-osgi - 5.11.0.redhat-621107 | Could not create JDBC tables; they could already exist. Failure was: CREATE TABLE ACTIVEMQ_MSGS(ID BIGINT NOT NULL, CONTAINER VARCHAR(250), MSGID_PROD VARCHAR(250), MSGID_SEQ BIGINT, EXPIRATION BIGINT, MSG BLOB, PRIMARY KEY ( ID ) )
Message: ERROR: type "blob" does not exist | Position: 138 SQLState: 42704 Vendor code: 0
Environment
- Red Hat JBoss A-MQ
- 6.2.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.