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