Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 12 Jan 2007 @ 10:46:00 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Response between Message based application around database
From:   Anomy Anom

<-- Anonymously Posted: Friday, January 12, 2007 04:31 -->


I need some help to simulate real time answers between an eai application and teradata. My Applications(Web services and weblogic EJB with one instance by user with 10 users ) send messages with query parameters to another business EJB application. This business EJB application compute parameters, execute queries and store the results in teradata.

How can my web services retrieve their own results as soon as possible without executing a select query every second?

I wished to used queue tables but i can't filter results from a queue table on an message id (*** Failure 5920 Select and consume: 'Not expecting a WHERE clause').

By the way create as much queue table as web service is a bad solution (number of web service may evolve).

I thinked about used "select and consume top 1 id_message from queue_table" query from all webservice and pop back the retrieved message_id if it doesn't match the web service message id, but it seems dangerous and may generate deads lock.

Have you any solution?


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020