Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SLSB query big table

 
xiao gao
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic