Hi all ,

I am using jdk 1.6.0_01 and jboss 4.0.5.GA.
I have setup jndi lookup in my startup servlet init() method , however it did not lookup the jndi database name at all.
It always give me error message cannot lookup the jndi name.
Anyone have any ideas what is happening here ? Thanks

Below is the startup servlet for my webapps:

public class AdminStartupServlet extends HttpServlet {
 
  protected Logger logger = LoggerManager.getLogger();

 
  public void init(ServletConfig config) throws ServletException {
   
    super.init(config);
    DatabaseAction databaseAction = ActionManager.getDatabaseAction();
   
    try{
       
       databaseAction.process();
       
    } catch(NamingException ne){
       ne.printStackTrace();
    } catch(Exception ex){
       ex.printStackTrace();
    }
   
 }
}

This is DatabaseAction :

public class DatabaseAction {
 
  protected DatabaseAction() {
  }
 
  public void process() throws Exception
       
  {
   
   
    try {
       OracleDatabaseManager.config();
    } catch(Exception ex) {
       throw new Exception("Fail to config ORACLE database connection.", ex);
    }
   
   
  }
 
}


This is the Database Manager to lookup database jndi name


public class OracleDatabaseManager {
 
  protected static DataSource oracleDS;
 
 
  public static synchronized void config() throws Exception {
    try{
       InitialContext initialContext = new InitialContext();
       oracleDS = (javax.sql.DataSource) initialContext.lookup("jdbc/OracleDS");
    }catch(Exception ex){
       ex.printStackTrace();
    }
   
  }
 
 
  public static Connection getOracleConnection() throws Exception {
    try {
       //InitialContext initialContext = new InitialContext();
       //oracleDS = (javax.sql.DataSource) //initialContext.lookup("jdbc/OracleDS");
       return oracleDS.getConnection();
    } catch (Exception ex) {
       throw new Exception(ex);
    }
  }
 
}

web.xml resource-ref tag

<resource-ref>
  Oracle DB Connection
 <res-ref-name>jdbc/OracleDS</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

jboss-web.xml tag

<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
jboss.jca:service=LocalTxCM,name=jdbc/OracleDS
<context-root>/</context->
<resource-ref>
  <res-ref-name>jdbc/OracleDS</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <jndi-name>jdbc/OracleDS</jndi-name>
</resource-ref>
</jboss-web>

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4043062#4043062

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4043062
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user