Hi,
I was wondering if it was wrong to insert a row manually in
theJMS_SUBSCRIPTIONS at table creation time in order to register a durable
subscription? In my mysql-jdbc-state-service.xml:
<attribute name="SqlProperties">
| ....
| POPULATE.TABLES.01 = INSERT INTO JMS_SUBSCRIPTIONS (CLIENTID,
SUBNAME, TOPIC, SELECTOR) VALUES ("_ownsubscriber",
"_emailSender0","NotificationDurableTopic","subscribers like '%email%'")
| ....
| </attribute>
I think it is not - I am basically mimicing a managed topic just like it would
be done in a jbossmq-state.xml with something like this:
| <DurableSubscription>
| <ClientID>_ownsubscriber</ClientID>
| <Name>_emailSender0</Name>
| <TopicName>NotificationDurableTopic</TopicName>
| <Selector>subscribers like '%email%'</Selector>
| </DurableSubscription>
It is my understanding that both ways of doing it basically relieve the JMS
client code from having to specify the client id and subscription name on their
durable subscriptions. In my environment it does seem to work though the
jbossmq's client subscriber code
| topicSession.createDurableSubscriber(topic,"_emailSend0");
insists in adding a new row to JMS_SUBSCRIPTIONS and my JMS_SUBSCRIPTIONS table
ends up looking like this:
|
+----------------+---------------+-----------------------------+----------------------------+
| | CLIENTID | SUBNAME | TOPIC | SELECTOR
|
|
+----------------+---------------+-----------------------------+----------------------------+
| | _ownsubscriber | _emailSender0 | NotificationDurableTopic | subscribers
like '%email%' |
| | ID:2 | _emailSender0 | NotificationDurableTopic | NULL
|
|
+----------------+---------------+-----------------------------+----------------------------+
|
It looks like I am missing a piece in my setup : I must associate the user with
the connection as is done in jbossmq-state.xml by matching the User node with
the durable subscription node. Does anybody know if it is even possible to
create this association with a jboss-jdbc-state-service.xml DB setup? Thanks in
advance
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3991827#3991827
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3991827
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
