1 Reply Latest reply on Oct 4, 2003 2:37 AM by null null

    table not found

    null null Newbie

      When I try to query a table on a database from a session bean I
      get the following :
      SQLException java.sql.SQLException: Table not found: mytable in statement [select * from mytable]

      The same query from a jsp page with the same DataSource works...

      This is my code.
      Any help is appreciated....
      Thanks.
      u

      .....
      try {
      initCtx = new InitialContext();
      envCtx = (Context) initCtx.lookup("java:comp/env");


      ds = (DataSource) envCtx.lookup("jdbc/protocollo");
      } catch (NamingException ne) {
      test += "NamingException " + ne;
      }


      if (ds !=null) {

      try {
      conn = ds.getConnection();
      //query = new Query(conn);
      if (conn == null) test += "Cconn is null ";
      else test += "conn is not null";
      } catch (SQLException sqle) {
      System.out.println("SQLException " + sqle);
      test += "Conn is nulllllll";
      }

      try {

      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select * from mytable");

      if (rs.next()) {
      test += "---------------" + rs.getString(1);

      } else
      test += "no results";


      stmt.close();
      } catch (SQLException sqle) {
      System.out.println("SQLException " + sqle);
      test += "SQLException " + sqle;
      }
      ........


      if I print test variable I get :

      conn is not null
      SQLException java.sql.SQLException: Table not found: mytable in statement [select * from mytable]



      Below my ejb-jar.xml and jboss.xml

      ejb-jar.xml

      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
      <ejb-jar>
      <enterprise-beans>

      Deployment descriptor for Protocollo Bean
      <display-name>MyBean</display-name>
      <ejb-name>ProtocolloEJB</ejb-name>
      MyclassHome
      MyclassProtocollo
      <ejb-class>MyclassProtocolloBean</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Bean</transaction-type>
      <resource-ref>
      <res-ref-name>jdbc/myds</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>



      </enterprise-beans>
      </ejb-jar>


      jboss.xml

      <?xml version="1.0" encoding="UTF-8" ?>

      <enterprise-beans>

      <ejb-name>MyEJB</ejb-name>
      <jndi-name>ejb/MyEJB</jndi-name>
      <resource-ref>
      <res-ref-name>jdbc/myds</res-ref-name>
      <resource-name>Data source protocollo</resource-name>
      </resource-ref>


      </enterprise-beans>

        • 1. Re: table not found
          null null Newbie

          sorry, this is the correct post:

          When I try to query a table on a database from a session bean I
          get the following :
          SQLException java.sql.SQLException: Table not found: mytable in statement [select * from mytable]

          I stated that neither my connection or my datasource are null.

          The same query from a jsp page with the same DataSource works...

          This is my code.
          Any help is appreciated....
          Thanks.
          u

          .....
          try {
          initCtx = new InitialContext();
          envCtx = (Context) initCtx.lookup("java:comp/env");


          ds = (DataSource) envCtx.lookup("jdbc/myds");
          } catch (NamingException ne) {
          test += "NamingException " + ne;
          }


          if (ds !=null) {

          try {
          conn = ds.getConnection();
          //query = new Query(conn);
          if (conn == null) test += "Cconn is null ";
          else test += "conn is not null";
          } catch (SQLException sqle) {
          System.out.println("SQLException " + sqle);
          test += "Conn is null";
          }

          try {

          Statement stmt = conn.createStatement();
          ResultSet rs = stmt.executeQuery("select * from mytable");

          if (rs.next()) {
          test += "---------------" + rs.getString(1);

          } else
          test += "no results";


          stmt.close();
          } catch (SQLException sqle) {
          System.out.println("SQLException " + sqle);
          test += "SQLException " + sqle;
          }
          ........


          if I print test variable I get :

          conn is not null
          SQLException java.sql.SQLException: Table not found: mytable in statement [select * from mytable]



          Below my ejb-jar.xml and jboss.xml

          ejb-jar.xml

          <?xml version="1.0" encoding="UTF-8"?>
          <!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
          <ejb-jar>
          <enterprise-beans>

          Deployment descriptor for Protocollo Bean
          <display-name>MyBean</display-name>
          <ejb-name>MyEJB</ejb-name>
          MyclassHome
          Myclass
          <ejb-class>MyclassBean</ejb-class>
          <session-type>Stateless</session-type>
          <transaction-type>Bean</transaction-type>
          <resource-ref>
          <res-ref-name>jdbc/myds</res-ref-name>
          <res-type>javax.sql.DataSource</res-type>
          <res-auth>Container</res-auth>
          </resource-ref>



          </enterprise-beans>
          </ejb-jar>


          jboss.xml

          <?xml version="1.0" encoding="UTF-8" ?>

          <enterprise-beans>

          <ejb-name>MyEJB</ejb-name>
          <jndi-name>ejb/MyEJB</jndi-name>
          <resource-ref>
          <res-ref-name>jdbc/myds</res-ref-name>
          <resource-name>Data source protocollo</resource-name>
          </resource-ref>


          </enterprise-beans>