• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

running a .jar file using MySQL trigger

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is it possible to run a .jar file using a MySQL trigger? since I want to run a certain code every time my table is updated, though ATM my current solution to this is to simply run my code infinitely and this is a total waste of memory thus I was hoping if it would be possible to just run it every time there is an update in the table
 
Saloon Keeper
Posts: 14488
325
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Maybe you can explain in a little bit more detail why you want to do this?
 
rodolfo tuble
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Stephan van Hulst wrote:Maybe you can explain in a little bit more detail why you want to do this?



Sure, It seems like I can't edit my question so I'll just post it here. The reason for this is because my main java program that does the inserting in the table is inside a no internet PC "it is needed to be that way", and the function inside the .jar file which I want to trigger every time there is an update in my table, the one I currently am running infinitely using a while loop needs an internet connection for the API inside it to work, also it is found inside the DB server which has an access to internet. Yes, the two files are on different machines one has internet and the other doesn't, and it is necessary to keep things that way. Thus I was wondering if there is an alternative solution to my infinite loop which is eating a lot of memory and I find it to be very impractical way of implementation.
 
Message for you sir! I think it is a tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic