*
The moose likes JDBC and the fly likes Informix database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Informix database" Watch "Informix database" New topic
Author

Informix database

Mostafa M.shawky
Greenhorn

Joined: Jul 06, 2006
Posts: 2
Hi All;

I want to update Mysql database from Informix database but i have a

huge table and if some thing wrong happens to it, our service can be

down, i need to know the feasibility of making a trigger on this table

or making a Listener which is best performance
And if trigger is best how can i do it

Trigger event:
We need the trigger to check on the updating of field
Trigger action:
When the trigger finds that there is an updating , it will insert a new

row on a remote DB table (MySQL)

best regards
Mostafa M.Shawky

mostafa_showky@hotmail.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Informix database
 
Similar Threads
read text file and save data into database
automatic mail
Beginner problem: MySQL, tomcat, Servlet, connection. Thanks
OO design for Java Database
Copying data from one DB to another