I don't have JBoss CMP docs handy so I thought somebody know of top off their had.
If I had the following query in my ejb-jar.xml:
SELECT OBJECT(d) FROM TableName d
WHERE d.someField = ?1
When I do the findBy... that corresponds to that QL I understand it's going to retrieve all the primary keys that match the criteria in one SQL call. Correct?
Additionally of all of these primary keys are already in the cache it would not need to issues any more loads to the database and so I end up just with one database read. Correct?
The only reason I am asking is that it takes a bit long to run this method and somebody suggested that JBoss bulk-loading is turned off by default. Is it true?
read-ahead is on-load by default.
you can check how many sqls are being generated by enabling it in the log