Edit D:\app\Administrator\product\11.2.0\dbhome_1\mgw\jlib\oracle\mgw\drivers\aq\AQAdminMgr.class
?? 1? ? ? !"#$%& ?'() *+ ,- ?.%/0123 405 ?6 ?789: ,;<=>?@ABC ,DEF G0HIJKLM#NO&OPQRS ?TOUOVWOX ?YZ [\ ?]^ ?_ `a ?bc ?defghijklm ?n0o pq `rst Zu ?0vw ?0x ?yz{ p|}~0???????? p??????????????????? ?? ???????? ???? ??? ??0? ?? ???? DEBUG Z ConstantValue DOT Ljava/lang/String; <init> ()V Code LineNumberTable LocalVariableTable this "Loracle/mgw/drivers/aq/AQAdminMgr; getCountForQueue N(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)I trcm errm qtObj msgState conn Ljava/sql/Connection; schema qtable qname stmt Ljava/sql/PreparedStatement; rs Ljava/sql/ResultSet; sql Exceptions getCountForSubscriber `(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)I subName getSubscriberID `(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)J subObj isSubscriber `(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Z sub_type I validSub addQueueSubscriber N(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V queueName rule Ljava/sql/CallableStatement; removeQueueSubscriber <(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)V alterSubscriberRule moveMessage ?(Ljava/sql/Connection;Ljava/lang/String;Loracle/mgw/drivers/aq/AQMessageID;Ljava/lang/String;Ljava/lang/String;)Loracle/mgw/drivers/aq/AQMessageID; srcQueue msgId #Loracle/mgw/drivers/aq/AQMessageID; destQueue midDest? removeMessage _(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Loracle/mgw/drivers/aq/AQMessageID;)Z sqlE Ljava/sql/SQLException; found describeQueueTable ](Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)Loracle/mgw/drivers/aq/QTableData; tableName describeQueue \(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)Loracle/mgw/drivers/aq/QueueData; describeTransformation N(Ljava/sql/Connection;Ljava/lang/String;)Loracle/mgw/drivers/aq/TransformData; fullName array [Ljava/lang/String; `(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)Loracle/mgw/drivers/aq/TransformData; owner name describeSubscriber ?(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Loracle/mgw/drivers/aq/SubscriberData; subsData &Loracle/mgw/drivers/aq/SubscriberData; toSubscriberData N(Ljava/sql/ResultSet;Ljava/lang/String;)Loracle/mgw/drivers/aq/SubscriberData; agentName agentAddress transformName ruleName subsId J agentProtocol subsType toQueueData 7(Ljava/sql/ResultSet;)Loracle/mgw/drivers/aq/QueueData; qtype enqEnabled deqEnabled s qid maxRetries retryDelay toQTableData 8(Ljava/sql/ResultSet;)Loracle/mgw/drivers/aq/QTableData; multipleConsumers txMsgGrouping objectTypeName sortOrder compatible payloadType toTransformData ;(Ljava/sql/ResultSet;)Loracle/mgw/drivers/aq/TransformData; fromType toType transformId closeStmt (Ljava/sql/Statement;)V Ljava/sql/Statement; closeRSet (Ljava/sql/ResultSet;)V rset toUpper &(Ljava/lang/String;)Ljava/lang/String; isLogLevel (I)Z level trace (Ljava/lang/String;I)V message SourceFile AQAdminMgr.java ? ? java/lang/StringBuffer ???? .AQ$?? READY select count(*) from qt ( where qt.msg_state = ? AND qt.queue = ??????? OAQAdminMgr.getCountForQueue query: query: {0} qtable={1}, queue={2}, state={3} java/lang/StringBuilder?? .???????? Cno result set returned: query: {0} qtable={1}, queue={2}, state={3} java/sql/SQLException ???? AND qt.consumer_name = ? , AND qt.address IS NULL AND qt.protocol = 0 dAQAdminMgr.getCountForSubscriber query: query: {0} qtable={1}, queue={2}, subscriber={3}, state={4}?? Sno result set returned: query: {0} qtable={1}, queue={2}, subscriber={3}, state={4} .AQ$_ _S select subscriber_id ' where (bitand(subscriber_type,1) = 1) # AND queue_name = ? and name = ? ' AND address IS NULL AND protocol = 0 GAQAdminMgr.getSubscriberID query: query: {0} queue={1}, subscriber={2}?? <no result set returned: query: {0} queue={1}, subscriber={2} ???? select subscriber_type subs " where name = ? and queue_name = ? DAQAdminMgr.isSubscriber query: query: {0} queue={1}, subscriber={2} 3{call sys.mgw_aqdriver.add_queue_subscriber(?,?,?)}????? 4{call sys.mgw_aqdriver.remove_queue_subscriber(?,?)} 4{call sys.mgw_aqdriver.alter_subscriber_rule(?,?,?)} /{call sys.mgw_aqdriver.move_message(?,?,?,?,?)}?????? !oracle/mgw/drivers/aq/AQMessageID?? ?? -{call sys.mgw_aqdriver.remove_message(?,?,?)}?? Bselect * from all_queue_tables where queue_table = ? and owner = ? ? ? 5select * from all_queues where name = ? and owner = ? ? ???? ? ? Bselect * from sys.dba_transformations where name = ? and owner = ? &select s.subscriber_id, s.queue_name, 3 s.name, s.address, s.protocol, s.subscriber_type, s.trans_name, s.rule_name from s (where (bitand(s.subscriber_type,1) = 1) % and s.queue_name = ? and s.name = ? * and s.address is NULL and s.protocol = 0 JAQAdminMgr.describeSubscriber query: query: {0} queue={1}, subscriber={2} ? ?????? ?? "queue_name" is null $oracle/mgw/drivers/aq/SubscriberData ??? queue_table?? queue_type "queue_type" is null NORMAL_QUEUE?? EXCEPTION_QUEUE NON_PERSISTENT_QUEUE max_retries?? retry_delay enqueue_enabled "enqueue_enabled" is null no dequeue_enabled "dequeue_enabled" is null oracle/mgw/drivers/aq/QueueData ?? "queue_table" is null type "type" is null variant type 'variant' not supported raw RAW object object_type "object_type" is null "owner" is null sort_order recipients "recipients" is null MULTIPLE message_grouping "message_grouping" is null NONE "compatible" is null oracle/mgw/drivers/aq/QTableData ?? transformation_id from_type "from_type" is null to_type "to_type" is null #oracle/mgw/drivers/aq/TransformData ???? ???? AQN????? oracle/mgw/drivers/aq/AQAdminMgr java/lang/Object "oracle/mgw/common/GatewayException (I)V append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; toString ()Ljava/lang/String; java/sql/Connection prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; java/sql/PreparedStatement setString (ILjava/lang/String;)V -(Ljava/lang/String;)Ljava/lang/StringBuilder; oracle/mgw/common/MgwUtil format n(Ljava/lang/String;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/String; executeQuery ()Ljava/sql/ResultSet; java/sql/ResultSet next ()Z (Ljava/lang/String;)V getInt (I)I ?(Ljava/lang/String;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/String; \(Ljava/lang/String;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/String; ((Ljava/lang/String;Ljava/lang/String;I)V getLong (I)J prepareCall 0(Ljava/lang/String;)Ljava/sql/CallableStatement; java/sql/CallableStatement execute getIDAsBytes ()[B setBytes (I[B)V registerOutParameter (II)V getBytes (I)[B ([B)V getErrorCode ()I oracle/mgw/drivers/aq/AQUtil parseFullName '(Ljava/lang/String;)[Ljava/lang/String; getString (I)Ljava/lang/String; java/lang/String toUpperCase 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; `(JLjava/lang/String;Ljava/lang/String;Ljava/lang/String;IILjava/lang/String;Ljava/lang/String;)V (Ljava/lang/String;)J equalsIgnoreCase (Ljava/lang/String;)Z (Ljava/lang/String;)I ;(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;JI)V `(Ljava/lang/String;Ljava/lang/String;ILjava/lang/String;ZZLjava/lang/String;Ljava/lang/String;)V L(Ljava/lang/String;Ljava/lang/String;JLjava/lang/String;Ljava/lang/String;)V java/sql/Statement close oracle/mgw/common/MgwLog getMgwLogger ()Loracle/mgw/common/MgwLog; exception *(Ljava/lang/String;Ljava/lang/Throwable;)V isLevel (II)Z )(Ljava/lang/String;Ljava/lang/String;II)V ! ? ? ? ? ? ? ? ? ? ? ? ? / *? ? ? ? ? ? ? ? ? ? :::+? L,? M-? N? Yd? +? ? ,? ? ::? Y ? ? ? ? ? ? ? :*? :? -? ? ? ,? Y? +? ? ,? ? -? : ? ? :? ? 0? Y? +? ? ,? ? -? : ? Y ? ?? 6 ? ? ?: ? ? ? ? ? b ? ? ? ? ? ? ? 3 ? 7 ? _ ? i ? s ? | ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? p ? ? ? ? ? ? 3 ? ? ? 7 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? = 1:::+? L,? M-? N? :? Yd? +? ? ,? ? :: ? Y ? ? ? ? ? ? ? !? ? :*? : ? -? ? ? ? ."? Y? +? ? ,? ? - ? #: ? ? :? ? 2$? Y? +? ? ,? ? - ? #: ? Y ? ?? 6 ? ? ?:? ? ? "