?
Solved

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

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

Hi.

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?

Thanks!

--BrianMc1958
0
Comment
Question by:BrianMc1958
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 1

Expert Comment

by:kerzner
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.
0
 

Author Comment

by:BrianMc1958
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...

--BrianMc1958
0
 
LVL 1

Accepted Solution

by:
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.
0
 

Author Comment

by:BrianMc1958
ID: 13629879
Dear Kerzner,

Thanks.  I'll be looking into this further.

--BrianMc1958
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month12 days, 6 hours left to enroll

752 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