.NET & Java Publish-Subscribe pattern

[Ludwig Wittgenstein]

Hello, all.

Does anyone know of documentation about implementing a publish-
subscribe model between a .NET Web service provide and a Java service
consumer? I have this problem I am trying to solve, and would greatly
appreciate it if someone can tell me what the best solution would be
for it.

I have a .NET 2.0 (ASMX) webservice on a server on a dedicated hosting
server, and several clients in different cities running linux servers
with MySQL, usually their MySQL server is synchronized with one I have
on a dedicated hosting server. This is easy to do, I just have web
service clients on each linux server calling webmethods on the .NET2.0/
SQL server and push information whenever there is a change in the
database. The problem is that I want to put data on the .NET2.0/SQL
server and have it propagated on all the MySQL servers. What is the
best way to do this? I believe a naive (?) solution would be to have
web service clients on the linux machines polling the .NET2.0 web
service every once in a while asking for data. However, I think that a
publish-subscribe model best fits this scenario, so that I can have
the .NET2.0 server publish new updates, send events to the subscribes
(the linux servers endpoint), which in turn will update the data on
their MySQL servers. What's the possible way to implement that? I'm
not asking someone to design it for me, I just want to be pointed into
the right technology-direction, I have the following solutions in
mind, let me know if I'm right or not:

1. use WS-Eventing: the .NET2.0 server publishes, and Apache Axis
webservices on each Linux client will subscribe to it.
2. Have JMS clients the Linux machines subscribe to a channel created
somehow by the .NET2.0 endpoint (is that possible?). The .NET2.0
service will send messages to all subscribers.

Thanks a lot,

[PlatinumBay]

Ludwig,

Whoa, there are whole books written on this topic. :)

If you go the web services route, remember to use only core types (types
that directly translate to xml types), so Java can interact with them. I
don't know that I would recommend polling web services. It would partly
depend on how realtime the remote data stores needed to be.

You may want to think about using SQL Server in all locations, and using the
built-in replication functionality (publisher/subscriber). You may also
want to look into middleware like BizTalk.

http://databases.about.com/cs/sqlserver/a/aa041303a.htm
http://www.microsoft.com/technet/pro...w/default.mspx

Hope this helps,
Steve

"Ludwig Wittgenstein" <se********@hotmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

Hello, all.

Does anyone know of documentation about implementing a publish-
subscribe model between a .NET Web service provide and a Java service
consumer? I have this problem I am trying to solve, and would greatly
appreciate it if someone can tell me what the best solution would be
for it.

I have a .NET 2.0 (ASMX) webservice on a server on a dedicated hosting
server, and several clients in different cities running linux servers
with MySQL, usually their MySQL server is synchronized with one I have
on a dedicated hosting server. This is easy to do, I just have web
service clients on each linux server calling webmethods on the .NET2.0/
SQL server and push information whenever there is a change in the
database. The problem is that I want to put data on the .NET2.0/SQL
server and have it propagated on all the MySQL servers. What is the
best way to do this? I believe a naive (?) solution would be to have
web service clients on the linux machines polling the .NET2.0 web
service every once in a while asking for data. However, I think that a
publish-subscribe model best fits this scenario, so that I can have
the .NET2.0 server publish new updates, send events to the subscribes
(the linux servers endpoint), which in turn will update the data on
their MySQL servers. What's the possible way to implement that? I'm
not asking someone to design it for me, I just want to be pointed into
the right technology-direction, I have the following solutions in
mind, let me know if I'm right or not:

1. use WS-Eventing: the .NET2.0 server publishes, and Apache Axis
webservices on each Linux client will subscribe to it.
2. Have JMS clients the Linux machines subscribe to a channel created
somehow by the .NET2.0 endpoint (is that possible?). The .NET2.0
service will send messages to all subscribers.

Thanks a lot,

[Ludwig Wittgenstein]

@PlatinumBay

I wish I can use MS SQL server! the main problem is that the clients
are running MySQL on Linux! Any other ideas?

On Jun 5, 1:08 am, "PlatinumBay" <[e-mail]:

Ludwig,

Whoa, there are whole books written on this topic. :)

If you go the web services route, remember to use only core types (types
that directly translate to xml types), so Java can interact with them. I
don't know that I would recommend polling web services. It would partly
depend on how realtime the remote data stores needed to be.

You may want to think about using SQL Server in all locations, and using the
built-in replication functionality (publisher/subscriber). You may also
want to look into middleware like BizTalk.

http://databases.about.com/cs/sqlser...06/evaluate/ov...

Hope this helps,

Steve

"Ludwig Wittgenstein" <[e-mail] in message

news:11**********************@g4g2000hsf.googlegro ups.com...

Hello, all.

Does anyone know of documentation about implementing a publish-
subscribe model between a .NET Web service provide and a Java service
consumer? I have this problem I am trying to solve, and would greatly
appreciate it if someone can tell me what the best solution would be
for it.

I have a .NET 2.0 (ASMX) webservice on a server on a dedicated hosting
server, and several clients in different cities running linux servers
with MySQL, usually their MySQL server is synchronized with one I have
on a dedicated hosting server. This is easy to do, I just have web
service clients on each linux server calling webmethods on the .NET2.0/
SQL server and push information whenever there is a change in the
database. The problem is that I want to put data on the .NET2.0/SQL
server and have it propagated on all the MySQL servers. What is the
best way to do this? I believe a naive (?) solution would be to have
web service clients on the linux machines polling the .NET2.0 web
service every once in a while asking for data. However, I think that a
publish-subscribe model best fits this scenario, so that I can have
the .NET2.0 server publish new updates, send events to the subscribes
(the linux servers endpoint), which in turn will update the data on
their MySQL servers. What's the possible way to implement that? I'm
not asking someone to design it for me, I just want to be pointed into
the right technology-direction, I have the following solutions in
mind, let me know if I'm right or not:

1. use WS-Eventing: the .NET2.0 server publishes, and Apache Axis
webservices on each Linux client will subscribe to it.
2. Have JMS clients the Linux machines subscribe to a channel created
somehow by the .NET2.0 endpoint (is that possible?). The .NET2.0
service will send messages to all subscribers.

Thanks a lot,

[PlatinumBay]

Ludwig,

Here are some links I found which may help you:

http://forums.mysql.com/read.php?60,155547,155547
The poster is using linked servers on the SQL Server and the MySQL ODBC
driver.

http://lists.mysql.com/myodbc/9221

Hope this helps,
Steve
"Ludwig Wittgenstein" <se********@hotmail.comwrote in message
news:11*********************@k79g2000hse.googlegro ups.com...

@PlatinumBay

I wish I can use MS SQL server! the main problem is that the clients
are running MySQL on Linux! Any other ideas?

On Jun 5, 1:08 am, "PlatinumBay" <[e-mail]:

>Ludwig,

Whoa, there are whole books written on this topic. :)

If you go the web services route, remember to use only core types (types
that directly translate to xml types), so Java can interact with them. I
don't know that I would recommend polling web services. It would partly
depend on how realtime the remote data stores needed to be.

You may want to think about using SQL Server in all locations, and using
the
built-in replication functionality (publisher/subscriber). You may also
want to look into middleware like BizTalk.

http://databases.about.com/cs/sqlser...06/evaluate/ov...

Hope this helps,

Steve

"Ludwig Wittgenstein" <[e-mail] in message

news:11**********************@g4g2000hsf.googlegr oups.com...

Hello, all.

Does anyone know of documentation about implementing a publish-
subscribe model between a .NET Web service provide and a Java service
consumer? I have this problem I am trying to solve, and would greatly
appreciate it if someone can tell me what the best solution would be
for it.

I have a .NET 2.0 (ASMX) webservice on a server on a dedicated hosting
server, and several clients in different cities running linux servers
with MySQL, usually their MySQL server is synchronized with one I have
on a dedicated hosting server. This is easy to do, I just have web
service clients on each linux server calling webmethods on the .NET2.0/
SQL server and push information whenever there is a change in the
database. The problem is that I want to put data on the .NET2.0/SQL
server and have it propagated on all the MySQL servers. What is the
best way to do this? I believe a naive (?) solution would be to have
web service clients on the linux machines polling the .NET2.0 web
service every once in a while asking for data. However, I think that a
publish-subscribe model best fits this scenario, so that I can have
the .NET2.0 server publish new updates, send events to the subscribes
(the linux servers endpoint), which in turn will update the data on
their MySQL servers. What's the possible way to implement that? I'm
not asking someone to design it for me, I just want to be pointed into
the right technology-direction, I have the following solutions in
mind, let me know if I'm right or not:

1. use WS-Eventing: the .NET2.0 server publishes, and Apache Axis
webservices on each Linux client will subscribe to it.
2. Have JMS clients the Linux machines subscribe to a channel created
somehow by the .NET2.0 endpoint (is that possible?). The .NET2.0
service will send messages to all subscribers.

Thanks a lot,