Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

ADF sort of generic screen for tables with the same structure

We have a couple (about a hundred) of tables with the same structure (Code, Description, Create Date, Update Date). So I wanted to do something simple so that I did not have to create all these screens 1) EO   I created the EO based on one of the tables I had that had the above columns. I then Added a transient attribute called table name to my EO based on a groovy expression. (the expression needs to change as I am reading web tier stuff from the model layer but I will fix this later) I then generated a java class for my EO. And added the following overriden method to my newly created java class. protected StringBuffer buildDMLStatement(int i, AttributeDefImpl[] attributeDefImpl,   AttributeDefImpl[] attributeDefImpl2, AttributeDefImpl[] attributeDefImpl3, boolean b) {   StringBuffer statement = super.buildDMLStatement(   i, attributeDefImpl, attributeDefImpl2, attributeDefImpl3, b); return new StringBuffer(StringUtils.replace(statement.to...
Post a Comment
Read more

Util code

public static MethodExpression getMethodExpression( String expr, Class returnType, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); ExpressionFactory elFactory = fc.getApplication().getExpressionFactory(); return elFactory.createMethodExpression( elctx, expr, returnType, argTypes); } public static javax.faces.el.MethodBinding getMethodBinding( String expr, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); return fc.getApplication().createMethodBinding(expr, argTypes); } SetPropertyListener listener = new SetPropertyListener( ActionEvent.class.getName()); listener.setFrom(link.getRoute()); listener.setValueExpression("to", JSFUtils.getValueExpression("#{pageFlowScope.route}", String.class)); action.addActionListener(listener); AdfFacesContext.getCurrentInstance().getPageFlowScope() .put("route", lin...
Post a Comment
Read more

MANIFEST.MF merge JDeveloper for an executable jar

Goto your project > properties. Then click on deployment in the menu. Edit or add a jar deployment profile. Fill in the details under jar options (select Include manifest and give it a main class name) Also remember that the merge functionality only works with a BLANK line at the end of the merge file. REALLY this caught me. My merge file contents: Class-Path: commons-codec-1.3.jar [...empty line here CRLF...]
1 comment
Read more