aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes SLSB query big table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "SLSB query big table" Watch "SLSB query big table" New topic

SLSB query big table

xiao gao

Joined: Oct 11, 2001
Posts: 21
Hi all
I have a huge table with 100,000 rows data to query. I want to query data every 20 rows and I want to use SLSB for the DB query.
I have a data client called queryResult holding the the home proxy of that SLSB, each time it create a instance of that SLSB to perform the db query and get a collection of data from SLSB.
I want to know if my solution is acceptable which not occur too much performace penlty.
The other question is since I use SLSB for the db query, how I can query certain amount of data from db and pass to queryResult dat a client..I use Oracle 8.1.6 with JDBC 2.0/ JBoss 3. I find setFetchSize doesn't work at all.

Consider Paul's rocket mass heater.
subject: SLSB query big table
Similar Threads
Need to retrieve only perticular attributes from table
transfer unserilaized objects as SOAP response
Transfering 3rd party (unserialized) objects through web server.
query.list() and query.uniqueResult() in hibernate return null
Hibernate - How to retrieve data from the database