This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes MySQL Triggers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySQL Triggers " Watch "MySQL Triggers " New topic
Author

MySQL Triggers

Kavita Tipnis
Ranch Hand

Joined: Sep 21, 2008
Posts: 177
I am trying to save only the modified fields in a history/log table with the old and new values.
I was just experimenting with triggers to achieve this, however I want to do it dynamically on the columns
For example:
IF Old.colname != New.colname THEN //do something
where colname is a fetched from a cursor looping through all the column names. So far it seems like a MySQl limitaiton or I might be missing something
I have my custom DAO pattern and so I am avoiding to check for all the field changes in the code.Also I have data split across in multiple tables,
Looks like lot of people have dealt with this but not in MySQL as of now.

After this post I did create a stored procedure which emits out a trigger and I tried using a prepared statement to create the trigger on the fly but MySql does not support triggers in prepared statements, is there any fix available or any suggestions on how to handle this otherwise.


Thanks,

 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: MySQL Triggers
 
jQuery in Action, 3rd edition