How to dynamically configure a datasource

alaiseca Oct 11, 2006 2:57 PM

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!!!

1. Re: How to dynamically configure a datasource

subramaniam.venkat Nov 22, 2006 7:00 AM (in response to alaiseca)

Hello,

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.

Take Care,
Subbu
Actions