Re: Database pool and dynamic URLs

[Jorg Heymans]

I let the user collect the available databases from a list, and build a connection string dynamically based on the database name.
So you have a list of available database, can't you just configure all 
of those?
I can also receive XML request specifying the database name.
This is more difficult.
Available databases are not known in advance, so I can't put them in cocoon.xconf.
IIRC some database require configuration file editing (oracle -> 
tnsnames.ora) for resolving the database name. Here you would be limited 
to the ones configured there anyway.

Also: think about the security issues. I wouldn't want to have an open 
database relay on my server to be honest, not even for intranets.

Jorg
--------
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]