Dynamic datasource selection/ swapping ADF

Just did this for a quick poc so pleased adapt this code as is is not production suitable.

1) Create a factory

package za.poc;
import oracle.jbo.server.DatabaseTransactionFactory;

public class CustomDatabaseTransactionFactory extends

 DatabaseTransactionFactory {
    public CustomDatabaseTransactionFactory() {
        super();
    }
    
    public oracle.jbo.server.DBTransactionImpl2 create() {
      return new CustomTransaction();
    }
}

2) Create new Transaction class

package za.poc;

import oracle.adf.share.ADFContext;
import oracle.jbo.server.DBTransactionImpl2;

public class CustomTransaction extends DBTransactionImpl2 {
  public CustomTransaction() {
    super();
  }

  public void connectToDataSource(java.util.Hashtable p1, java.lang.String p2, java.lang.String p3,
    java.lang.String p4, boolean p5) {
    String userName = (String)ADFContext.getCurrent()

      .getSessionScope().get("USER_NAME");
      if (userName != null) {
          if ("test".equalsIgnoreCase(userName) ) {
            p2 = "jdbc/testDS";
          }
      }
       super.connectToDataSource(p1, p2, p3, p4, p5);
  }
}

3) Override AM TransactionFactory property to your newly created class.

4) set the session value on login.
session.setAttribute("USER_NAME", "test");

See this blog post for an alternative (probably better)
http://jobinesh.blogspot.com/2011/04/modifying-application-modules-jdbc.html