1 Reply Latest reply on Apr 17, 2002 8:00 AM by L Stitz

    Table not found

    Ruth Newbie

      I'm working with jboss2.4.4-Tomcat4.0.1, I configure the jboss.jcml file with my DB Oracle 9i (with driver classes12.zip in

      lib/ext )
      ----------JBOSS.JCML-----------

      oracle.jdbc.driver.OracleDriver



      DefaultDS
      oracle.jdbc.xa.client.OracleXADataSource
      jdbc:oracle:thin:@bart:1521:test
      silicon
      Pamela
      10
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0


      ---------------

      The ejb's are BMP, there is the descriptors files:

      ----------EJB-JAR.XML-----------
      ...
      <resource-ref>
      <res-ref-name>jdbc/DefaultDS</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>

      ------------------------------

      ---------JBOSS.XML------------------
      <enterprise-beans>

      <ejb-name>DiagnosE</ejb-name>
      <jndi-name>diagnosServer</jndi-name>
      <resource-ref>
      <res-ref-name>jdbc/DefaultDS</res-ref-name>
      <jndi-name>java:/DefaultDS</jndi-name>
      </resource-ref>

      </enterprise-beans>
      ---------------------------

      I can make the deploy but when i try execute the client, failed in sentencies sql:
      Table not found!

      Anybody can help me?
      Thanks in advanced.

        • 1. Re: Table not found
          L Stitz Newbie

          Looks more like a database/sql-related problem than anything to do with JBoss. At least, he seems to be able to connect to the database server, but fails to find a table with the name provided in your jdbc code or sql statement.

          Hope this did help,
          Lars