cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Vaterlaus <>
Subject How to query multiple SQL databases
Date Thu, 14 Jul 2005 09:22:54 GMT
Dear Cocooners

I'm facing the following problem, and I'm a bit clueless which way is
the best to solve it. Therefore I'm interested on your thoughts and
experiences regarding such a problem.

The problem:
* I have n databases to query
* The query on each database is the same
* The number (n) of databases has to be evaluated at run time
* The databases can be accessed by dblink
* The name of the databases to query are stored in another table
* A single request from a web page should start all queries
* The result of all queries is displayed on one web page
* A single query could look like this
        SELECT * FROM table_abc@db_name

As a solution I can think of a subquery in SQL or using xsp-logic.
What are your thoughts?



To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message