Automatically create separate DS'es for web-applications

[lkowalczyk]

I am planning to use JBoss 3.0.4 bundled with Tomcat 4.0.6 and I know I will need separate databases for each web-application I deploy.

How can I use separate data source for each application without resorting to manually adding *-service.xml files each time I deploy a new application (BTW: can JBoss pick up the service files without restart?)

Or maybe I can package *-service.xml file into to the ear files? I browsed through the forums but couldn't find any mention about it.

[joelvogt]

? I'm not too sure how you would do that. At the end of the day you need to tell jboss how the datasource is set up which is what your service is for.

[lkowalczyk]

Well, yes but I would like it to happen automatically (or with little effort on my side). I was thinking of a something like a parametrized data source configuration, ie. connection url is parametrized with application name (for instance, jdbc:postgresql://localhost/${webapp}).

It need not be exactly like this, I would be perfectly happy if I could tell jboss to look for service file in the ear (or war) file. Can I do this?

I would like to avoid having to restart server each time an application is deployed.

[joelvogt]

so you can't hot deploy your apps and your database service?

[lkowalczyk]

I had problems with that, that's why I asked if it's possible at all.