JBoss 3.2.3 write works from client but not from another EJB

[azydron]

Hi,

I have a problem using A Stateless Session Bean that writes a record to an Oracle 9i table using a JDBC DS declaration. The write (using an SQL INSERT statement) works fine if the call comes from a non-EJB client using a Helper object. If I use the same Helper object from another Stateless Session Bean the write never works, but I do not get an error message. The environment is:

Windows XP Home SP1
JDK 1.4.2_5
JBoss 3.2.3

Reads from the database from the EJB always work fine regardless if the client is another EJB or not.

I have tried all permutations of settings in my ejb-jar.xml etc. and closing connections and PreparedStatements etc.

Thanks in advance,

AZ

[azydron]

Solved - the problem was due to a <xa-datasource> controlled bean being called from a <local-tx-datasource> controlled bean