trigger database changes to java beans

[Tushar]

Hello,

I am working on a client server application involving TOMCAT as Web
server, MySQl as the DB and combination of JSP, Servlet, and JavaBeans
to access and write Data back.

There is another piece of the project (out side my scope of
development) that
writes to the Same MySQL tables and make changes to the data.

How do I write a Trigger/Store Procedure or any such mechanism that
would throw an event that the external Java Beans would catch and take
action like, fetch the changed data....

I am sure this is a very commom issue in application development and
there maybe some patterns that I need to follow.

Any suggestion will be appriciated.

Thanks

Tushar

[Tushar]

Thanks for the response Steve,

The other piece of project that writes the data is in C++ :-)
I fond an article to use JNI so the C++ object can call Java object
when the data is changed. This Java object can be a listener that
all my beans could register to and listen for appropriate event and
update data.

I think I wil take that route.

Thanks

Tushar

Steve Jorgensen <no****@nospam.nospam> wrote in message news:<et********************************@4ax.com>. ..

I suppose there might be a way to do what you're asking, but the usual model for
an app with requirements like that would be to add a middle-tier that is used by
both front-ends. I know you said the other piece was outside your scope of
development, but perhaps you need to broach the isssue to whomever has the
authority that it may be time for the 3-tier idea.

On 4 Aug 2003 06:27:13 -0700, ph*****@lucent.com (Tushar) wrote:

Hello,

I am working on a client server application involving TOMCAT as Web
server, MySQl as the DB and combination of JSP, Servlet, and JavaBeans
to access and write Data back.

There is another piece of the project (out side my scope of
development) that
writes to the Same MySQL tables and make changes to the data.

How do I write a Trigger/Store Procedure or any such mechanism that
would throw an event that the external Java Beans would catch and take
action like, fetch the changed data....

I am sure this is a very commom issue in application development and
there maybe some patterns that I need to follow.

Any suggestion will be appriciated.

Thanks

Tushar

[mchan]

in oracle, one can rmi and socket to an external server. Otherwise,
one can always poll :)
see also, http://www.ftponline.com/portals/com...ta/default.asp

ph*****@lucent.com (Tushar) wrote in message news:<42************************@posting.google.co m>...

Hello,

I am working on a client server application involving TOMCAT as Web
server, MySQl as the DB and combination of JSP, Servlet, and JavaBeans
to access and write Data back.

There is another piece of the project (out side my scope of
development) that
writes to the Same MySQL tables and make changes to the data.

How do I write a Trigger/Store Procedure or any such mechanism that
would throw an event that the external Java Beans would catch and take
action like, fetch the changed data....

I am sure this is a very commom issue in application development and
there maybe some patterns that I need to follow.

Any suggestion will be appriciated.

Thanks

Tushar