2 Replies Latest reply on Mar 11, 2002 7:28 PM by garyg

    MDB doing something strange w/ JDBC

    garyg Novice

      I have a MDB that does a JDBC sql update to a table. The executeUpdate method returns a 1 meaning that one row was successfully updated. Yet when I look in the dbase, it's still the old value.

      So I'm wondering why it works everywhere's else except in this MDB. Maybe I've got something w/ the configuration wrong, specifically the <resource-ref> tag maybe? No exceptions are being thrown and I think I've got the Dbase reference in this MDB properly.

      Any help/ideas/pointers much appreciated.

      Are these entries correct?

      --- ejb-jar.xml ---

      <message-driven>
      <ejb-name>Receiver</ejb-name>
      <ejb-class>com.neuroquest.cais.ejb.message.receiver.Receiver</ejb-class>
      <message-selector></message-selector>
      <transaction-type>Bean</transaction-type>
      <acknowledge-mode>Auto-acknowledge</acknowledge-mode>
      <message-driven-destination>
      <destination-type>javax.jms.Queue</destination-type>
      </message-driven-destination>
      <resource-ref>
      <res-ref-name>jdbc/PostgresqlDB</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
      </resource-ref>
      </message-driven>

      --- jboss.xml ---

      <message-driven>
      <ejb-name>Receiver</ejb-name>
      <configuration-name>Standard Message Driven Bean</configuration-name>
      <destination-jndi-name>queue/receiver</destination-jndi-name>
      <resource-ref>
      <res-ref-name>jdbc/PostgresqlDB</res-ref-name>
      <resource-name>java:/PostgresqlDB</resource-name>
      </resource-ref>
      <secure-name>
      false
      </secure-name>
      </message-driven>