2 Replies Latest reply on Feb 27, 2002 6:59 PM by Todd Marshall

    How to locate a DataSource in an EJB

    jian gao Newbie

      After configuring a DataSource,how should I write code to get database connection in an EJB?
      Shall I use JNDI? Thanks!

        • 2. Re: How to locate a DataSource in an EJB
          Todd Marshall Newbie

          Yes, you want to use JNDI.

          Here is an example in a helper class I wrote so I could have easy access in my JSPs to the same datasource I was using in my beans.

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

          public class DBConnection

          static public Connection getConnection()
          Connection dbConn = null;

          // get database connection from jboss
          Context initialContext = new InitialContext();
          DataSource ds= (DataSource) initialContext.lookup("java:/DefaultDS");
          dbConn = ds.getConnection();

          catch (NamingException ne)
          System.out.println("Naming Exception: " + ne);
          catch (SQLException se)
          System.out.println("SQL Exception: " + se);

          return dbConn;