Click here to Skip to main content
15,885,044 members
Home / Discussions / Java
   

Java

 
AnswerRe: building my own messenger using java Pin
Dave Kreskowiak26-Aug-09 6:14
mveDave Kreskowiak26-Aug-09 6:14 
AnswerRe: building my own messenger using java Pin
Zhat27-Aug-09 2:36
Zhat27-Aug-09 2:36 
GeneralRe: building my own messenger using java Pin
Sedruol2k927-Aug-09 3:21
Sedruol2k927-Aug-09 3:21 
Questionjava application for mobile phone Pin
rahuljin23-Aug-09 21:04
rahuljin23-Aug-09 21:04 
AnswerRe: java application for mobile phone Pin
David Skelly23-Aug-09 22:34
David Skelly23-Aug-09 22:34 
AnswerRe: java application for mobile phone Pin
rahul.tenguriya25-Aug-09 19:14
rahul.tenguriya25-Aug-09 19:14 
GeneralRe: java application for mobile phone Pin
Nagy Vilmos25-Aug-09 21:49
professionalNagy Vilmos25-Aug-09 21:49 
QuestionWhat does Statement.setFetchSize(nSize) method really do? Pin
cofi++23-Aug-09 1:15
cofi++23-Aug-09 1:15 
hi. i have this really big table with some millions of records every day and in the end of every day i am extracting all the records of the previous day. i am doing this like

<br />
String SQL = <br />
"select col1, col2, coln <br />
from mytable <br />
where timecol = yesterday";<br />
<br />
Statement.executeQuery(SQL);<br />


but the problem is that this program takes like 2GB of memory because it takes all the results in memory then it processes it.

i tried setting the Statement.setFetchSize(10) but it takes exactly the same memory from OS it does not make any difference. i'm using "Microsoft SQL Server 2005 JDBC Driver" for this.

i there any way to read the results in small chunks like oracle does when the query is executed it show only a few rows and as you scroll down more results are shown?
AnswerRe: What does Statement.setFetchSize(nSize) method really do? Pin
Nagy Vilmos24-Aug-09 3:44
professionalNagy Vilmos24-Aug-09 3:44 
QuestionNotification Field Names Pin
sangeethanarayan21-Aug-09 21:19
sangeethanarayan21-Aug-09 21:19 
AnswerRe: Notification Field Names Pin
TorstenH.23-Aug-09 20:38
TorstenH.23-Aug-09 20:38 
QuestionJava convert uLaw encoded audio file to PCM ecoded Pin
Moonis Ahmed21-Aug-09 1:51
Moonis Ahmed21-Aug-09 1:51 
AnswerRe: Java convert uLaw encoded audio file to PCM ecoded Pin
427748024-Aug-09 11:03
427748024-Aug-09 11:03 
GeneralRe: Java convert uLaw encoded audio file to PCM ecoded Pin
Moonis Ahmed24-Aug-09 17:38
Moonis Ahmed24-Aug-09 17:38 
QuestionJava SWT interop with ActiveX control Pin
Judah Gabriel Himango20-Aug-09 15:33
sponsorJudah Gabriel Himango20-Aug-09 15:33 
QuestionRe: Java SWT interop with ActiveX control Pin
JongYoungKim20-Oct-09 14:20
JongYoungKim20-Oct-09 14:20 
Questionplease help Pin
madhu912419-Aug-09 5:09
madhu912419-Aug-09 5:09 
AnswerRe: please help Pin
EliottA19-Aug-09 5:40
EliottA19-Aug-09 5:40 
AnswerRe: please help Pin
TorstenH.19-Aug-09 21:48
TorstenH.19-Aug-09 21:48 
GeneralRe: please help Pin
EliottA20-Aug-09 6:05
EliottA20-Aug-09 6:05 
QuestionDate Dialog Box Pin
alonchap17-Aug-09 23:08
alonchap17-Aug-09 23:08 
AnswerRe: Date Dialog Box Pin
David Skelly18-Aug-09 2:14
David Skelly18-Aug-09 2:14 
QuestionMake a client to client chat socket programming with Java Pin
cem tezer17-Aug-09 17:49
cem tezer17-Aug-09 17:49 
AnswerRe: Make a client to client chat socket programming with Java Pin
TorstenH.18-Aug-09 19:53
TorstenH.18-Aug-09 19:53 
QuestionGraph Colouring Pin
Dini_luv16-Aug-09 6:25
Dini_luv16-Aug-09 6:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.