Creating a jboss datasource on-thy-fly

Hi,

we are importing data nightly creating a new mysql database each night (discarding instances which are too old). The databases are the accessed from a JEE application inside the jboss application server (4.2).

Currently we are creating datasource (*-ds.xml) files automatically and put them into the deploy directory. That works but it's not a perfect solution because we have to make sure the datasources are available on all jboss instances. We don't want a jboss cluster for other reasons not related to this question.

So is there a way to create a data source "on the fly"? From the jboss javadoc (http://docs.jboss.com/jbossas/javadoc/4.0.4/connector/index.html?org/jboss/resource/adapter/jdbc/local/LocalTxDataSource.html) I see that there is a LocalTxDataSource class, but I cannot find examples how to use this class. Also we'd rather have a NoTxDataSource.

Any help/ideas is greatly appreciated.

Thanks
HolgerStart Free Trial