Yuvaraj Mani wrote:
>
> I cannot write a trigger becase one is oracle and the other
> is SQL Server.
>
This is heading off-topic, but you have (at least) a
couple of options (assuming Oracle --> Sybase, but
same logic applies other-way-'round):
1) The database is the only thing you can control: In that
case, write a trigger that calls a stored procedure
that sends out a notification. Write a server to
listen for the notification, and have the server
update the other table. Exactly how to make Oracle
do the notification is off-topic (and besides, I
can remember offhand :-)
2) You control the apps updating the system: Have the
apps that do the updates also do the transfer, or
have them send out a message (using something like
JMS), and have a server listen for the messages as
in #1.
--
Christopher St. John [EMAIL PROTECTED]
DistribuTopia http://www.distributopia.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
