开发者

Craeting QueueTable in OracleAQ 11.2.0

I have installed Oracle11.2.0(windows,32 bit) and tried to create a queuetable.. (I have granted all permissions for t开发者_如何学JAVAhe jmsuser,AQ_ADMINISTRATOR_ROLE,AQ_USER_ROLE,DB_Access).

when try to create a queuetable, Oracle gives following issue;

oracle.jms.AQjmsException: ORA-01017: invalid username/password; logon denied ORA-06512: at "SYS.DBMS_AQADM", line 81

My sample code is as follows,

  createQueue(Session session) {
    AQQueueTableProperty qt_prop;
    AQQueueTable q_table;
    AQjmsDestinationProperty dest_prop;
    Queue queue;
    qt_prop = new AQQueueTableProperty("SYS.AQ$_JMS_BYTES_MESSAGE");

    /* create a queue table */
    q_table = ((AQjmsSession) session).createQueueTable("jmsuser", "test_queue_table",
                                                                qt_prop);

    }

Any idea?

Thanks


I solved this with following setting;

ALTER SYSTEM GLOBAL_TOPIC_ENABLED = FALSE;

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜