[jboss-user] [Datasource Configuration] - Multiple datasources different IP's Dynamic selection of each

[Ken Barnes]

Ken Barnes [http://community.jboss.org/people/kenbarnesjr] created the discussion

"Multiple datasources different IP's Dynamic selection of each"

To view the discussion, visit: http://community.jboss.org/message/541523#541523

--------------------------------------------------------------
I have one jboss server that runs on a box with 30+ instances of sybase one the same box with each instance of sybase having a different ip.  I have some web services that clients connect to wanting interaction with any one of the databases.  I can get the Ip address of each that are calling but I need a way to specify the datasource via JNDI that each should use.  Is there any way that I can have one datasource defined in Sybase-ds.xml and then in a module or some mechanism dynamically select the datasource according to IP and have the web service that utilzes the datasoure have the right one.  Would i need 30 ds.xml files each creating a jndi datasource ? 
Thanks for the help

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/541523#541523]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100506/4dc7fbb6/attachment.html