[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - mySQL batch updates

I am using jBoss 4.2.2GA along with mySQL Server 5.0 in a production environment. I have an early morning scheduled task that picks up files and performs updates to the mySQL tables. The process builds SQL update commands and then calls mySQL and makes the updates directly. My problem is that the web transactions do not reflect these changes unless I restart jBoss. It continues to pick up and display the original table values. I have tried flushing mySQL and using commit but nothing appears to make a difference. What do I have to do to get jBoss to pick up these dynamic batch changes to the tables? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4181902#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...