Why so many database accessing?

[yxyang]

Hello

I am using CMP.
The case is : session bean A--->session B---->CMP.
I already configed the session A and Session B methods are transaction reqired. and entity bean use commit option D and with big cache pool size and instant pool size. Because the 3.2.3 use on-find by default(am i right?), so i expect that only the first time when container access the db, it will call actuall db. the later entity bean calling only involves the retrieving information from the cache.

But when i use ethereal to monitor the traffic of db accessing, it is supprised that there are so many db accessing.

Any comments?

regards

yang

[yxyang]

refresh this topic

[aloubyansky]

Is it EJBQL queries? They always load data from the database.

[yxyang]

Yes, it is EJBQuery? How to solve this problem? If i use JBoss specific query, will it solve the problem?

regards

yang