Hi, I have a web application requiring to connect to one of several SQL Server databases. They are all identical in structure; what changes is the IP address, user and password. So far I had configured datasources as -ds.xml files in the deploy directory. But in this case I don't know the connection parameters in advance: they are discovered at runtime depending on the user who logs in. Is there any way in JBoss to dynamically setup a javax.sql.Datasource object and do the JNDI binding at runtime? As additional information, I'm using Spring + Hibernate. Thanks!!!
Any file which you put in the deploy directory will be deployed by JBoss.
I am also using a similar kind of design where i build a dynamic datasource.
For the next request which comes in check whether the old datasource string and the new datasource are not equal then if they are not equal then i deploy the new datasource.
And i also sleep if i deploy the datasource for sometime . So that the new datasource is deployed. But i never change the jndi name of the datasource.
I hope this must help you.
|Retrieving data ...|