Hi,

I have an entity bean that has a table behind it with only ~1400 records. A normaly command line SQL query on this table takes no time to get all the rows back. JBoss 3.2.3 on Win2000 times out on a 20 minute transaction, however.

The table has a two-part key and no relationships. JBoss keeps putting out the following query over and over again to get the data:

SELECT ... FROM ... WHERE (key1 = ? AND key2 = ?) || (key1 = ? AND key2 = ?) ...

Should I tweek a configuration somewhere?

Thanks,
Chad