Re: Tomcat data source

2007-12-05 Thread Roberto Pellegrino
In my application is present a interface (visible only to admin) who permit to specificate what kind of db connection use to make query: - DataConnection -- url, user, pass, driver. If the data are correct it work. - DataSource -- If data source are defined on webApp context the name is the

Re: Tomcat data source

2007-12-05 Thread Roberto Pellegrino
I have seen the documentatio many and many times... My question is clear? The response to my question is: Isn't possible get dataSource reference if is not defined on webApp context... This is a limitation if application expose a method to make query in varius and dinamic datasource Only

Tomcat data source

2007-12-04 Thread Roberto Pellegrino
Hi all, i use Tomcat *5.5.17 *my question is quite simple: it's possible to use a dataSource that are not defined on webApp context??? I define the dataSource on server.xml as follow: Resource auth=Container driverClassName=DriverClassName validationQuery=select count(*) from table

Re: Tomcat data source

2007-12-04 Thread Roberto Pellegrino
a global datasource and not make a reference to it in the context.xml file. --David Roberto Pellegrino wrote: Hi all, i use Tomcat *5.5.17 *my question is quite simple: it's possible to use a dataSource that are not defined on webApp context??? I define the dataSource on server.xml as follow

Re: Tomcat data source

2007-12-04 Thread Roberto Pellegrino
at runtime and store the result in the config file - On change have the jsp or servlet close down the existing DBCP and replace it with a new one. - Update all the other jsps and servlets to get their DataSource from the ServletContext That's what I'd do at least. --David Roberto Pellegrino wrote: I