how to cache a CMP-Bean

[Kay Tracid]

Hi,

i have a cmp bean "Minfo" and get my results in my client this way:

try {
Collection c = getHome().findByDisk(disk);
Iterator iterator = c.iterator();
    
Minfo info = null;
while (iterator.hasNext()){
Object obj = iterator.next();
if (obj instanceof Minfo) info = (Minfo)obj; 
System.out.println(info.getDisk()+" "+ info.getExtension());
}
} catch (RemoteException e1) {
e1.printStackTrace();

Every time i call a get-Function, JBoss make a database query, like this:

Executing SQL: SELECT filename, extension, disk, size, id3title, id3artist, id3length, id3bitrate FROM minfo WHERE (id=?)

is it possible to get the information for all get-functions with one sql-call for each bean? is it possible to configure my bean or jboss for this behavior?

i have a performance problem if i call a lot of get-Methods.

Thanks a lot!

[Nathaniel Stoddard]

There are some synchronization settings that you set when you deploy. "Optimistic", etc -- I forget the others. Check out some JBoss documentation. If you use a more lax setting, it may only need to do one select, and your gets can actually return the cached information.