1 Reply Latest reply on Jan 5, 2008 1:53 AM by wayne baylor

    EJB3 with Eclipse

    Salva Carsi Newbie

      Hi,

      We are trying to work a simple EJB 3 application. Our goal is to post a stateless bean and acces to it from a web application.

      We are developing it with eclipse. Here is the program structure:
      -A java application that contains two interfaces and the bean (also a metainf) to implement the stateless bean.
      -A web application 2.4 (we had tried also with 2.5).

      We deploye the bean as a jar in the jboss, and it seems to recognize it. But when we try to acces with the web app (via servlet) we got an java.nullPointerException.

      Ejb Code:

      import java.sql.ResultSet;
      import java.sql.SQLException;
      import javax.ejb.Remote;
      
      
      /**
       * This is the business interface for Carp enterprise bean.
       */
      @Remote
      public interface EjbRemote {
      
       boolean doStatement(String queryName) throws SQLException;
      
       ResultSet doQuery(String query) throws SQLException;
      
       void printQuery(String query);
      }
      


      import java.sql.ResultSet;
      import java.sql.SQLException;
      import javax.ejb.Local;
      @Local
      public interface EjbLocal {
      
       boolean doStatement(String queryName) throws SQLException;
      
       ResultSet doQuery(String query) throws SQLException;
      
       void printQuery(String query);
      }
      


      import javax.annotation.Resource;
      import javax.ejb.Stateless;
      import javax.sql.DataSource;
      import java.sql.Statement;
      import java.sql.Connection;
      import java.sql.ResultSet;
      import java.sql.SQLException;
      
      @Stateless
      public class EjbBean implements EjbLocal, EjbRemote {
      
       @Resource(mappedName = "TACWDS") DataSource TACWDS;
      
       public EjbBean() {
      
       }
      
       public boolean doStatement(String query) {
       //TODO implement doStatement
       return false;
       }
      
       public final ResultSet doQuery(String query) throws SQLException {
       System.out.println("Esecuzione query : " + query);
       Connection conn = TACWDS.getConnection();
       Statement stm = conn.createStatement();
       return stm.executeQuery(query);
       }
      
       public final void printQuery(String query) {
       System.out.println("Esecuzione query : " + query);
       }
      }
      


      Servlet Code:

      
      public class appServlet extends HttpServlet {
       @EJB EjbLocal sless;
      
       public void service(HttpServletRequest req, HttpServletResponse resp)
       throws ServletException, IOException{
      
       resp.setContentType("text/html");
       PrintWriter out = resp.getWriter();
       //sless.printQuery("SELECT * FROM FOO");
      
       System.out.println("sless state: "+sless);
       }
      }