File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Make it so: Java DB Connections & Transactions this week in the JDBC 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.

I agree. Here's the link:
subject: SLSB query big table
It's not a secret anymore!