[JBoss-user] using statefull beans to manage cursors to the database in a longsearch

[Emerson Cargnin - SICREDI Serviços]

What you think of using a statefull bean to manage a cursor in a long search so that it doens't need to get all the data from the search (that propably won't be needed by the client) neither to make the database repeat all the search for each page it needs.

I can configure the statefull bean to have a short timeout so that it won't keep the db connection too long. In this case it woul'd have to repeat the search transparently to the user. The DBA's here said it would be the best option for long searchs (to keep the cursor opened).


--
xxxxxxxxxxxxxxxxxxxxxxxxxxxx
| Emerson Cargnin |
| Analista de Sistemas Sr. |
| Tel : (051) 3358-4959 |
| SICREDI Serviços |
| Porto Alegre - Brasil |
|xxxxxxxxxxxxxxxxxxxxxxxxxx|



-------------------------------------------------------
This sf.net email is sponsored by:
Battle your brains against the best in the Thawte Crypto
Challenge. Be the first to crack the code - register now:
http://www.gothawte.com/rd521.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user