Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

Hi,

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?

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>