Community

Multiple datasources different IP's Dynamic selection of each

created by Ken Barnes in Datasource Configuration - View the full discussion

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

Start a new discussion in Datasource Configuration at Community