• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Pl/sql getting row one by one

 
Vidu Greg
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

In my java class, I am connecting to a database and want to get a particular column (longblob type) from a particular table. I dont want to get all the rows in one time as I will get memory problem surely.
I want to get a row one by one, So can anyone please tell me how should I do that?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Vidu Greg:
I dont want to get all the rows in one time as I will get memory problem surely.

Have you tried it to know you get a memory problem? Sometimes we think there will be a problem and the driver optimizes for us. I'm sure you aren't processing by holding all the BLOBs in memory at once. That would clearly be a memory problem.


I want to get a row one by one,

If getting the default 10 or 20 records is too much memory you can call setFetchSize(1) to get one across the network at a time.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic