Hi!

I am connecting to a MS SQL Server 2K. If i use the mssql-service.xml the finder returns the correct set of data.

If I change to mssql-xa-service.xml the finder does not return any rows.

The finder is called in a stateless session bean which uses bean managed transactions.

The query of the finder is "Select Object(ti) from TeacherImportBean ti where ti.processFlag = TRUE".

The generated SQL is correct. I have tryed it within the QueryAnalyzer of the SQL Server.

There are more than 9000 rows within the DB which meet that criteria.

The finder is called directly after "sessionContext.getUserTransaction().begin();" so I am sure that there can not be any locks on that rows because I am also the only user on that DB.

Every other Session Bean is working fine. The only difference is, that all other beans use Container Managed Transactions.

Didi