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;
精彩评论