1 Reply Latest reply on Feb 25, 2004 7:41 AM by Bjoern Weis

    oracle-jdbc2-service.xml

    Bjoern Weis Newbie

      Hello,

      I send it in [Connectors and JCA/JBoss], because [Messaging, JMS & JBossMQ] won't work, the error message is 'Cannot invoke the operation : the module threw an exception'.

      I want to store the message queues in an Oracle 9i (Version 9.2.0.2.0) Database, but it fails. It seems that Oracle don't like the "BLOB" in the "CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )" statement. I have allready tried to create this table manually, then I get the folowing error message:

      "ORA-00406: COMPATIBLE-Parameter muss 9.2.0.0.0 oder groesser sein"
      In english it have to:
      "ORA-00406: COMPATIBLE parameter needs to be 9.2.0.0.0 or greater"

      When I remove the BLOB it worked, so I think Oracle don't like the BLOB datatyp. Is there any solution of this Problem?

      Regards
      Bjoern

      PS: I used the oracle-jdbc2-service.xml from the examples directory and the Oracle 9i jdbc driver.