JBoss AMQ - error while configuring persistenceAdapter with postgreSQL - type "blob" does not exist

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In