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>