Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (hermes.apache.org: domain of mvaterlaus@gmail.com
 designates 64.233.184.193 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding;
        b=D6J8e3kc23lCZpS7EoUxAcmobiufipBTD744qTIQt0jl7DLy7dLXC1Oco8SpprcO7XBWD/q3CBVSZWG8A7RrrFSKxaHzFzf2JuSnZA5ECpjbJF5586/1wWx3k4VSSLM4R20UXQJ3Z+XKC8tNg6N5e3SPj5uVTefOrgs1BWUU5MY=
Message-ID: <404c8a8d04102604252153cac9@mail.gmail.com>
Date: Tue, 26 Oct 2004 13:25:11 +0200
From: Markus Vaterlaus <mvaterlaus@gmail.com>
Reply-To: Markus Vaterlaus <mvaterlaus@gmail.com>
To: users@cocoon.apache.org
Subject: Best Practice Connecting to n Databases
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi all,

I'm keen to now your experiences and best practices for the following situation:

I need to be able to select one out of n databases and query it.
N is actually a number around 50.
The queries are the same on each database.
All information relevant to the access to such a database (user name,
password, server name, port, db name) is available in one central
place (xml file or database).
The user selects the database and the first query is executed.

I thought about building dynamically an ESQL serverpage which takes
the access parameters for the selected database as an input. I haven't
tried it yet, therefore I don't know if it's possible at all. What are
your suggestions? Do you have other ideas?

Cheers,

Markus

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org