Displaying 1 result from an estimated 1 matches for "postgres_con".
2014 Oct 20
0
dbHasCompleted() always returns TRUE for POSTGRES Database with RJDBC?
...E !!!
while (!dbHasCompleted(res)) {
chunk <- fetch(res, 10)
print(nrow(chunk))
}
dbClearResult(res)
dbDisconnect(con)
########## My Code, lamentably not reproducible because of needed
Postgres-Server, not working #########
# Connect to Postgres-Database
res2 <- dbSendQuery(Postgres_con,
"select id from mytable limit 1000;"
)
dbHasCompleted(res2) ##RETURNS TRUE!
while (!dbHasCompleted(res2)) {
chunk <- fetch(res2, 10 )
rbind(dk, chunk)
}
try({
dbClearResult(res2)
rm(chunk,res2)
})
[[alternative HTML version de...