Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


NEWBIE: How to wake up Java on MS SQL Server event?

Posted on 2005-03-01
Medium Priority
Last Modified: 2009-07-29
Dear Java Experts,


I have an application with an ASP/Vbscript GUI, a Java back end and an MS SQL Server database shared by both.  The GUI writes the user input to the database, and the Java wakes up from its sleep once a second to process it if it's there.  (It's low volume...)

Is there a (fairly simple) way to have the Java wake up from it's sleep only when the GUI writes the user input to the database?  Or, is there a way for the Vbscript to send a message to the Java to wake up now?


Question by:BrianMc1958
  • 2
  • 2

Expert Comment

ID: 13446246
Can the GUI write a file that Java app will be watching for? And delete it after it awoke. This solution would be by far the easiest to implement.

Author Comment

ID: 13558017
Dear kerzner,

Thanks, but I'm really looking for a more direct method.  I'm trying to avoid having the Java app need to wake up and check something.  Instead, I'm looking for a  way to have something external wake it up...


Accepted Solution

kerzner earned 750 total points
ID: 13558258
You can use JMS for direct messaging between the two applcations. For Java JMS is native, but for other language you would have to find client code.

Or, you can have a trigger in MSSQL, which would then send a JMS message.

Effient and fast, but neither if fairly simple.

Author Comment

ID: 13629879
Dear Kerzner,

Thanks.  I'll be looking into this further.


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses
Course of the Month15 days, 7 hours left to enroll

575 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question