Hi,
I'd like to know some details about how a application server caches its Entity Beans.
When i call an Entity Bean's home finder method
from any client, what exactly heapens on the server ? Does it search the line ( or lines ) on its cache, or it makes an database call every time ?
I would like to know what heapen on the server when a Entity Bean tries an SQL like this simple one:
SELECT SALARY from employee
WHERE <CONDITION>
supose the bean tries the following cases to <CONDITION> tag:
First query :
"SALARY > 1000 AND SALARY < 2000"
and later, i tries the second one:
"SALARY > 1000 AND SALARY < 2500"
At the second execution,will the application server query its EJB cache looking for lines that match the query ( in this case all lines that SALARY is between 1000 and 2000 are already in cache, they were stored there by the fisrt execution ) and ask the database only for the lines that is not in the cache yet , or the things dont work like this ??
Is the applications server cache system that smart ? Where to find info about it on the web ?
Thanks in advance.
Claudio Gualberto
I'd like to know some details about how a application server caches its Entity Beans.
When i call an Entity Bean's home finder method
from any client, what exactly heapens on the server ? Does it search the line ( or lines ) on its cache, or it makes an database call every time ?
I would like to know what heapen on the server when a Entity Bean tries an SQL like this simple one:
SELECT SALARY from employee
WHERE <CONDITION>
supose the bean tries the following cases to <CONDITION> tag:
First query :
"SALARY > 1000 AND SALARY < 2000"
and later, i tries the second one:
"SALARY > 1000 AND SALARY < 2500"
At the second execution,will the application server query its EJB cache looking for lines that match the query ( in this case all lines that SALARY is between 1000 and 2000 are already in cache, they were stored there by the fisrt execution ) and ask the database only for the lines that is not in the cache yet , or the things dont work like this ??
Is the applications server cache system that smart ? Where to find info about it on the web ?
Thanks in advance.
Claudio Gualberto