Re: Database notification

frebe wrote:
>>No, triggers start stored procedures on the server side, but nothing
>
> on
>
>>the client side.
>
>
> Yes, that stored procedure can send a message (like JMS
> publish/subscribe) to the client. I don't know what kind of languages
> MySQL supports for stored procedures. If it doesn't support java, you
> might consider switching to a database that support java.


MySQL-5.0 supports triggers, and while it doesn't yet support Java
stored procedures (scheduled for 5.1), you can write UDFs in any
language that can produce a DLL and then have the trigger call your UDF.

One of our guys (before he joined MySQL) wrote a UDF that uses JNI to
let people write their UDFs in Java, so relatively easily you could put
triggers on tables that then use Java-based messaging of one sort or
another to notify the client.

The package (jUDF) is available here:

http://freshmeat.net/projects/judf/?topic_id=66

-Mark
.

Relevant Pages

  • Re: Database notification
    ... publish/subscribe) to the client. ... MySQL supports for stored procedures. ... You would still need triggers that updates the new timestamp table. ...
    (comp.lang.java.databases)
  • Re: Independant QUery
    ... When you have COM component in a machine (server) and if you need invoke ... that COM component from another machine (client), ... These are the system stored procedures (For example: ... >> triggers ...
    (microsoft.public.sqlserver.programming)
  • Re: Business objects, subset of collection
    ... SQL databases sucks for searching large data sets, ... TPC implementations rely heavily on stored procedures. ... Application modules that are executed on the client side but are stored on the server side. ... Lets say you want to find all unpaid invoices. ...
    (comp.object)
  • Re: Portable stored procedures
    ... > JDatastore lets you store binary streams outside the table scema. ... Other databases usually do not store BLOB's ... > you will have to write the function in the client in Java (or whatever ... >> stored procedures written in some proprietary language. ...
    (comp.lang.java.databases)
  • RE: Which event is appropriate....
    ... Yes, this will be a bit heavy, but not really bad, as it is all client ... MVP; ... Triggers the alert message ... > "Kevin Spencer" wrote in message ...
    (microsoft.public.dotnet.framework.aspnet)