[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Query from RDBMS Event generator

Posted on 2006-05-17
3
Medium Priority
?
210 Views
Last Modified: 2013-12-10
This is what I would like to do.

I want the Integration process to kick in as soon as a new row in a table called tableA is added. For this I have defined the channel rule in the RDBMS Event Generator.

So as soon as new row is added , I want to get the result of the query "Select * from tableB where id=1"  and send it to the subscription method in my jpd.

How do I do this?

thanks in advance
0
Comment
Question by:expertsit
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
ECollin earned 750 total points
ID: 16706494
hi,

why don't you execute your query with a database control directly after receiving the first message (insert into table A) ?

Emmanuel
0
 

Author Comment

by:expertsit
ID: 16709089
Excellent idea! Let me try that.

thanks
0
 

Author Comment

by:expertsit
ID: 16738158
That worked.

thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Suggested Courses
Course of the Month8 days, 23 hours left to enroll

590 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