4 Replies Latest reply on May 7, 2004 11:06 AM by adrian.brock

    SQLException: table not found

    sysuser1

      Hello,

      I have implemented a MDB and a sessin bean that get a record from a database after received a jms message.
      But I have got an SQLException Table not found when I start the test, but I can see my table in the jmx console.
      Here are my conf files:

      the AdminDB-ds.xml:

      <local-tx-datasource>
      <jndi-name>jdbc/AdminDB</jndi-name>
      <connection-url>jdbc:postgresql://svt-lmk91:5432/AdminDB</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>postgres</user-name>


      <!-- <new-connection-sql></new-connection-sql> -->

      <check-valid-connection-sql>select * from is_copyprotocol</check-valid-connection-sql>

      </local-tx-datasource>



      my ejb-jar.xml:

      <?xml version="1.0" encoding="ISO-8859-1"?>
      <!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>

      Deployment descriptor for the MDBTest
      <display-name>XferAgent</display-name>
      <enterprise-beans>

      <message-driven>
      Mdb for messages recieved about the test
      <display-name>Message Driven Bean MdbTest</display-name>
      <ejb-name>MdbTest2</ejb-name>
      <ejb-class>com.iratensolutions.mdbDB.MdbTest2</ejb-class>
      <transaction-type>Bean</transaction-type>
      <acknowledge-mode>Auto-acknowledge</acknowledge-mode>
      <message-driven-destination>
      <destination-type>javax.jms.Topic</destination-type>
      <subscription-durability>NotDurable</subscription-durability>
      </message-driven-destination>

      <ejb-local-ref>
      <ejb-ref-name>ejb/SessionTestLocalHome</ejb-ref-name>
      <ejb-ref-type>Session</ejb-ref-type>
      <local-home>com.iratensolutions.mdbDB.SessionTestLocalHome</local-home>
      com.iratensolutions.mdbDB.SessionTestLocal
      <ejb-link>SessionTestBean</ejb-link>
      </ejb-local-ref>
      </message-driven>


      <ejb-name>SessionTestBean</ejb-name>
      <local-home>com.iratensolutions.mdbDB.SessionTestLocalHome</local-home>
      com.iratensolutions.mdbDB.SessionTestLocal
      <ejb-class>com.iratensolutions.mdbDB.SessionTestBean</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Bean</transaction-type>

      <resource-ref>
      <res-ref-name>jdbc/AdminDB</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>



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

      my jboss.xml:
      <?xml version="1.0" encoding="UTF-8"?>

      <!DOCTYPE jboss PUBLIC
      "-//JBoss//DTD JBOSS 3.2//EN"
      "http://www.jboss.org/j2ee/dtd/jboss_3_2.dtd">


      <enterprise-beans>
      <message-driven>
      <ejb-name>MdbTest2</ejb-name>
      <destination-jndi-name>topic/testTopic</destination-jndi-name>
      </message-driven>



      <ejb-name>SessionTestBean</ejb-name>
      <local-jndi-name>SessionLocalHome</local-jndi-name>
      <jndi-name>SessionLocalHome</jndi-name>
      <resource-ref>
      <res-ref-name>jdbc/AdminDB</res-ref-name>
      <resource-name>AdminDB</resource-ref-name>
      <jndi-name>java:jdbc/AdminDB</jndi-name>
      </resource-ref>

      </enterprise-beans>



      Thanks for any help.

        • 1. Re: SQLException: table not found
          sesques

           

          "aquafresh" wrote:
          Hello,

          my jboss.xml:
          <?xml version="1.0" encoding="UTF-8"?>

          <!DOCTYPE jboss PUBLIC
          "-//JBoss//DTD JBOSS 3.2//EN"
          "http://www.jboss.org/j2ee/dtd/jboss_3_2.dtd">

          <jboss>
          <enterprise-beans>
          <message-driven>
          <ejb-name>MdbTest2</ejb-name>
          <destination-jndi-name>topic/testTopic</destination-jndi-name>
          </message-driven>


          <session>
          <ejb-name>SessionTestBean</ejb-name>
          <local-jndi-name>SessionLocalHome</local-jndi-name>
          <jndi-name>SessionLocalHome</jndi-name>
          <resource-ref>
          <res-ref-name>jdbc/AdminDB</res-ref-name>
          <resource-name>AdminDB</resource-ref-name>
          <jndi-name>java:jdbc/AdminDB</jndi-name>
          </resource-ref>
          </session>
          </enterprise-beans>

          </jboss>

          Thanks for any help.


          Hi,

          I think the jndi name must be "java:/jdbc/AdminDB"
          Try it.

          Pascal



          • 2. Re: SQLException: table not found
            sysuser1

            unfortunately I obtain still the same error.
            I have try a lot of way to specify the jndi but still get the same error.

            • 3. Re: SQLException: table not found
              darranl

              Have you had a look at JNDI View to see what is bound?

              • 4. Re: SQLException: table not found

                I have deleted your cross post to the JBoss/JCA forum.
                I already posted you a link on how to behave properly in public forums.