SimpleBMPBean.java

package com.sun.s1asdev.jdbc.appauth.ejb;

import javax.ejb.*;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class SimpleBMPBean
        implements EntityBean {

    protected DataSource ds;
    int id;

    public void setEntityContext(EntityContext entityContext) {
        Context context = null;
        try {
            context = new InitialContext();
            ds = (DataSource) context.lookup("java:comp/env/DataSource");
        } catch (NamingException e) {
            throw new EJBException("cant find datasource");
        }
        System.out.println("[**SimpleBMPBean**] Done with setEntityContext....");
    }

    public Integer ejbCreate() throws CreateException {
        return new Integer(1);
    }

    public boolean test1() {
        //application auth + user/pwd not specified - should fail
        Connection conn = null;
        boolean passed = false;
        try {
            conn = ds.getConnection();
        } catch (Exception e) {
            passed = true;
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception e1) {
                }
            }
        }
        return passed;
    }

    public boolean test2() {
        //application auth + user/pwd  specified - should pass
        Connection conn = null;
        boolean passed = true;
        try {
            conn = ds.getConnection("DBUSER", "DBPASSWORD");
        } catch (Exception e) {
            passed = false;
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception e1) {
                }
            }
        }
        return passed;
    }

    public boolean test3() {
        //application auth + wrong user/pwd 
        Connection conn = null;
        boolean passed = false;
        try {
            conn = ds.getConnection("xyz", "xyz");
        } catch (Exception e) {
            passed = true;
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception e1) {
                }
            }
        }
        return passed;
    }

    public boolean test4() {
        //application auth + user/pwd  specified - right initiall
        //wrong the second time
        Connection conn = null;
        boolean passed = false;

        try {
            conn = ds.getConnection("DBUSER", "DBPASSWORD");
        } catch (Exception e) {
            return false;
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception e1) {
                }
            }
        }

        try {
            conn = ds.getConnection("xyz", "xyz");
        } catch (Exception e) {
            passed = true;
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception e1) {
                }
            }
        }
        return passed;
    }

    public boolean test5() {
        //application auth + user/pwd  specified - right initial
        //ensure that connection with same username is returned in both the cases.
        
        Connection conn = null;
        Connection conn2 = null;
        boolean passed = false;
        boolean result1 = false;
        boolean result2 = false;
        try {
            try {
                conn = ((com.sun.appserv.jdbc.DataSource) ds).getNonTxConnection("DBUSER", "DBPASSWORD");
                if (conn.getMetaData().getUserName().equals("DBUSER")) {
                    result1 = true;
                }
            } catch (Exception e) {
                return false;
            }

            try {
                conn2 = ((com.sun.appserv.jdbc.DataSource) ds).getNonTxConnection("APP", "APP");
                if (conn2.getMetaData().getUserName().equals("APP")) {
                    result2 = true;
                }
            } catch (Exception e) {}
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (Exception e1) {}
            }

            if (conn2 != null) {
                try {
                    conn2.close();
                } catch (Exception e1) {}
            }
        }
        passed = result1 && result2;

        return passed;
    }

    public void ejbLoad() {}

    public void ejbStore() {}

    public void ejbRemove() {}

    public void ejbActivate() {}

    public void ejbPassivate() {}

    public void unsetEntityContext() {}

    public void ejbPostCreate() {}
}