Friday, October 10, 2003 02:04 PM
You'd have to create a separate connection pool for each data source. Then your application would dictate which pool to get the connection from based on the page that was accessed.
Not sure about frameworks. I'm fairly sure that most app servers will allow you to set up multiple pools.
Hope this helps.