5 Replies Latest reply on Aug 13, 2003 8:18 AM by Raphael M. Grochtmann

    JBoss 3.2 uses wrong BLOB type for Postgres

    Raphael M. Grochtmann Newbie

      Hi,

      it seems that JBoss 3.2 tries to create the JMS persistence
      tables using the BLOB type "OBJECT" in jbossmq-service.xml.

      This leads to a postgres error on startup:

      DEBUG: query: CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
      ERROR: Unable to locate type name 'object' in catalog

      When I changed this to "BYTEA" in jbossmq-service.xml
      (as I learned from another posting in this forum) it worked.

      Is this a known bug or do I have to change something in
      my config to make postgres work without patching?

      Thanks!
      Cheers
      Raphael