I can also do the same thing if my application takes the database connection using ds.getConnection() But in my case I am using Hibernate and kodo-jdo. Both cases i need a managed connection, so I am using the same -ds file for this. Finally all connections will come from same connection pool. Since Hibernate and Kodo-jdo takes the connection using datasource look up in their own code, I won't be able to change the database there. So this has to managed in the datasource level. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4151891#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...