Re: [R] Java Exception error while reading large data in R from DB using RJDBC.

2012-11-01 Thread Hasan Diwan
On 1 November 2012 11:47, Hasan Diwan wrote: > Sir, > > On 30 October 2012 04:32, aajit75 wrote: >> >> Please suggest where am i going wrong or alternate option to solve such >> issues while reading large DB table. >> > > You might consider setting the fetch size. I haven't used RJDBC in a few

Re: [R] Java Exception error while reading large data in R from DB using RJDBC.

2012-11-01 Thread Hasan Diwan
Sir, On 30 October 2012 04:32, aajit75 wrote: > > Please suggest where am i going wrong or alternate option to solve such > issues while reading large DB table. > You might consider setting the fetch size. I haven't used RJDBC in a few months, but hopefully, the hints on http://www.rforge.net/

Re: [R] Java Exception error while reading large data in R from DB using RJDBC.

2012-11-01 Thread Jessica Streicher
Actually forget that loop, that was old code. Now remember i had to actually split the one query down into several queries to get everything. On 01.11.2012, at 18:38, Jessica Streicher wrote: > I didn't have the same exception yet, but please make sure you have a stable > connection (avoid wlan

Re: [R] Java Exception error while reading large data in R from DB using RJDBC.

2012-11-01 Thread Jessica Streicher
I didn't have the same exception yet, but please make sure you have a stable connection (avoid wlan). I personally ran out of memory very often and had to make several queries, combining the results in R instead. This is probably not the best thing to do, but worked for me to fetch large amount

[R] Java Exception error while reading large data in R from DB using RJDBC.

2012-10-30 Thread aajit75
Dear List, Java Exception error while reading large data in R from DB using RJDBC. I am trying to read large data from DB table(Vectorwise), using RJDBC connection. I have tested the connection with small size data and was able to fetch DB tables using same connection(conn as in my code). Pleas