File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "SLSB query big table" Watch "SLSB query big table" New topic
Author

SLSB query big table

xiao gao
Greenhorn

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.

Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SLSB query big table
 
Similar Threads
transfer unserilaized objects as SOAP response
Hibernate - How to retrieve data from the database
query.list() and query.uniqueResult() in hibernate return null
Need to retrieve only perticular attributes from table
Transfering 3rd party (unserialized) objects through web server.