David,
You may be able to use JSP to query your database.
Here's a snippet from this article:
http://today.java.net/pub/a/today/2003/06/20/jspDb.html
<html>
<head>
<title>Accessing data in a database</title>
</head>
<body>
<%
try {
// Step 1. Load the JDBC driver
Class.forName("org.gjt.mm.mysql.Driver");
// Step 2. Create a Connection object
Connection con = DriverManager.getConnection(
"jdbc:mysql///xeon/CompanySecret",
"budi", "secret");
........more below.....
The jdbc connection parameters (database, user, password) could be input as parameters
to the JSP.
You could write the JSP output as XML and then use cocoon to transform the result.
Just an idea. May not be the best method though.
Kieran.
_____________________________________________
Kieran Kirwan
Executive Transportation Planner
Transportation Modelling Department
Dublin Transportation Office
Hainault House,
69/71 St. Stephen's Green,
Dublin 2,
Ireland.
Tel: +353 (0)1 4778113
Fax: +353 (0) 1 478 5935
website: www.dto.ie <http://www.dto.ie/>
-----Original Message-----
From: Carmona Perez, David [mailto:[EMAIL PROTECTED]
Sent: 26 January 2004 16:39
To: [EMAIL PROTECTED]
Subject: RE: Database pool and dynamic URLs
Jorg,
I let the user collect the available databases from a list, and build a connection
string dynamically based on the database name.
I can also receive XML request specifying the database name.
Available databases are not known in advance, so I can't put them in cocoon.xconf.
--------
David
-----Mensaje original-----
De: Jorg Heymans [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 26 de enero de 2004 16:57
Para: [EMAIL PROTECTED]
Asunto: Re: Database pool and dynamic URLs
How exactly do you construct these dynamically? (and possibly also :
why?). Can you explain to us your usecase a bit more?
Thanks
Jorg
Carmona Perez, David wrote:
> Dear Cocooners,
>
> I've read an article about connection pooling in
> http://wiki.cocoondev.org/Wiki.jsp?page=ConnectionPooling .
> The technique explained there isn't useful for my case, because the user, password,
> and database name are not known beforehand, they are dynamically constructed.
>
> Any workaround?
> Thanks for any help.
>
> --------
> David
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
Mail Marshal for the presence of computer viruses.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
