The buffer limit is an X11/xterm issue, not an R problem. Regarding your main motivation to read data from a db, several options exist for communication between R and relational database management systems - RODBC, RJDBC, RMySQL, ROracle, RPostgreSQL, RSQLite, RMonetDB, ... In the R Data Import/Export Manual have a look at the section on relational databases
http://cran.r-project.org/doc/manuals/r-release/R-data.html#Relational-databases Cheers, Jagat > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of angeloimm > Sent: Wednesday, November 28, 2012 2:12 AM > To: r-help@r-project.org > Subject: Re: [R] R strange behaviour when building huge concatenation > > Hello John > Thank you for the tips > I already tried by using RKWard and RStudio and I got the same > error...so I > passed to the R console > Maybe it's the buffer limit but, since I'm really newbie to R, I'ld > like to > know how to configure this limit > In any case in my application I'ld like to avoid to write data in a csv > file (by using java) and then use R in order to import these > data....I'ld > like to read data from DB and then pass them to R (well it'ld be good > also > if R read data from DB...but I'm afraid I can do a great mistake in > handling connection and so on in R and my time is really short) > Is there any way in order to read data from db (in Java) and pass all > the > data to R without write them in a csv file? > > Thank you to all you > Cheers, > Angelo > > > 2012/11/27 John Kane [via R] <ml-node+s789695n4651040...@n4.nabble.com> > > > I am currently getting the very strange results that if I paste your > > orginal data from your first message into my R terminal I get the > same > > errors you do. By the way that ";" is not needed in R. > > > > If I paste the same data into Rstudo, either into the editor or the > > console it works fine. > > > > If I paste the data into gedit and send it to the console it works > fine > > but if I paste it into the gedita console I get your error messages > again. > > A quick try, pasting it into an R buffer in EMACS seems to work just > fine. > > > > I have no idea what is happening unless jagat.k.sheth is correct and > we > > are hitting a buffer limit of some kind. > > > > I'd suggest getting a decent editor and going with it. Working > directly > > in an R terminal is enough to drive most people crazy. > > > > Any of the editiors/ides mentioned above are good with different > > strengtsts etc. At a guess, Rstudio is the easiest to install and > get > > running on Ubuntu, gedit is pretty easy but you need to install the r > gedit > > plug-in. EMACS as far as I can tell is very good and very powerful > but I > > have not used it enough to really comment on it. > > > > In any case one way or the other they can read in the data. I'd also > > suggest not even 'thinking' about writing a vector statement that > long. It > > would be much easier to do something like write the numbers in a > column in > > a spreadsheet and import from there. There are various ways to do > this but > > the simplist would be to just save the file as a csv file and import > it > > using read.table or read.csv. > > > > I'm sorry that I cannot be of more help. Perhaps one of the R gurus > can > > comment on the possible buffer problem. > > > > John Kane > > Kingston ON Canada > > > > > > > -----Original Message----- > > > From: [hidden > email]<http://user/SendEmail.jtp?type=node&node=4651040&i=0> > > > Sent: Tue, 27 Nov 2012 07:04:13 -0800 (PST) > > > To: [hidden > email]<http://user/SendEmail.jtp?type=node&node=4651040&i=1> > > > Subject: Re: [R] R strange behaviour when building huge > concatenation > > > > > > Hello John > > > It seems correct to me too but in my R console it seems to not be > > working > > > Here there is what I did: > > > i copied the statement on one row (leaving and removing the final > > useless > > > semi colomn) > > > i tried to execute it in the R console (in order to open my R > console I > > > simply opened a terminal window on my ubuntu machine and I typed > "R") > > > when I click "enter" the inserted statement doesn't not run...I > simply > > > see > > > the cursor on a new line and this new line starts with "+" > > > > > > Here there is a little stack of what I see on my terminal: > > > , 1, 1, 2, 2, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 17, > 2, 2, > > > 0, > > > 2, 0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, > 1, 0, > > > 0, > > > 1, 0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 7, 0, 0, 1, 0, 0, 3, 0, > 0, 2, > > > 4, > > > 0, 1, 0, 0, 0, 0, 2, 1, 0, 4, 2, 0, 0, 1, 3, 0, 0, 1, 0, 0, 1, 0, > 1, 1, > > > 0, > > > 0, 0, 0, 0, 0, 0, 0, 0, 2, 3, 0, 1, 0, 1, 1, 3, 3, 0, 0, 0, 0, 1, > 0, 2, > > > 0, > > > 1, 0, 0, 0, 1, 1, 0, 2, 0, 2, 0, 3, 0, 4, 0, 1, 1, 0, 0, 1, 0, 3, > 0, 0, > > > 0, > > > 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 3, 0, 6, 0, 0, 0, 0, 3, 0, 0, 0, > 2, 5, > > > 0, > > > 1, 0, 0, 1, 0, 1, 0, 0, 2, 0, 1, 2, 0, 0, 7, 0, 0, 2, 0, 2, 2, 0, > 0, 0, > > > 0, > > > 0, 2, 0, 8, 0, 0, 5, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 3, 0, 2, 0, 0, > 0, 2, > > > 1, > > > 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 2, 0, 0, 1, 0, 1, 2, 0, 0, 1, 0, > 2, 0, > > > 0, > > > 3, 0, 0, 0, 1, 0, 0, 0, 1, 0, 9, 3, 0, 0, 0, 0, 0, 0, 3, 0, 0, 2, > 0, 1, > > > 1, > > > 1, 0, 0, 0, 2, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, > 0, 0, > > > 0, > > > 1, 4, 0, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 2, 0, > 1, 0, > > > 0, > > > 6, 0, 0, 0, 0, 1, 0, 0, 2, 6, 0, 1, 0, 0, 0, 0, 2, 0, 7, 0, 1, 2, > 1, 1, > > > 1, > > > 0, 0, 1, 5, 0, 1, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, > 5, 1, > > > 0, > > > 1, 2, 0, 0, 1, 2, 0, 1, 0, 2, 0, 1, 2, 7, 1, 2, 0, 0, 0, 5, 0, 4, > 0)) > > > + > > > + > > > + > > > + > > > + > > > > > > Each time i click enter i go on a new line starting with "+" > > > Then if i start in tying some character I get an error like this: > > > > > > + > > > + > > > + q > > > + > > > + q > > > Errore: unexpected symbol in: > > > " > > > q" > > > > > > Sometimes this error (Errore: unexpected symbol in:) appears in the > > > statement execution > > > > > > Here there are my sessionInfo() result: > > >> sessionInfo() > > > R version 2.14.1 (2011-12-22) > > > Platform: i686-pc-linux-gnu (32-bit) > > > > > > locale: > > > [1] LC_CTYPE=it_IT.UTF-8 LC_NUMERIC=C > > > [3] LC_TIME=it_IT.UTF-8 LC_COLLATE=it_IT.UTF-8 > > > [5] LC_MONETARY=it_IT.UTF-8 LC_MESSAGES=it_IT.UTF-8 > > > [7] LC_PAPER=C LC_NAME=C > > > [9] LC_ADDRESS=C LC_TELEPHONE=C > > > [11] LC_MEASUREMENT=it_IT.UTF-8 LC_IDENTIFICATION=C > > > > > > attached base packages: > > > [1] stats graphics grDevices utils datasets methods > base > > > > > > > > > I really don't know why this happens....above all because it seems > to me > > > a > > > very very simple statement... > > > Thank to all you for the support > > > > > > > > > > > > > > > -- > > > View this message in context: > > > > > http://r.789695.n4.nabble.com/R-strange-behaviour-when-building-huge- > concatenation-tp4650817p4650970.html > > > Sent from the R help mailing list archive at Nabble.com. > > > > > > ______________________________________________ > > > [hidden email] > <http://user/SendEmail.jtp?type=node&node=4651040&i=2>mailing list > > > https://stat.ethz.ch/mailman/listinfo/r-help > > > PLEASE do read the posting guide > > > http://www.R-project.org/posting-guide.html > > > and provide commented, minimal, self-contained, reproducible code. > > > > ____________________________________________________________ > > FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! > > > > ______________________________________________ > > [hidden email] > <http://user/SendEmail.jtp?type=node&node=4651040&i=3>mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide > > http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > > > > > ------------------------------ > > If you reply to this email, your message will be added to the > discussion > > below: > > > > http://r.789695.n4.nabble.com/R-strange-behaviour-when-building-huge- > concatenation-tp4650817p4651040.html > > To unsubscribe from R strange behaviour when building huge > concatenation, click > > > here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsub > scribe_by_code&node=4650817&code=YW5nZWxvaW1tQGdtYWlsLmNvbXw0NjUwODE3fC > 04MTM3OTMwMDg=> > > . > > > NAML<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro > _viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespac > es.BasicNamespace-nabble.view.web.template.NabbleNamespace- > nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%2 > 1nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml- > send_instant_email%21nabble%3Aemail.naml> > > > > > > > -- > View this message in context: http://r.789695.n4.nabble.com/R-strange- > behaviour-when-building-huge-concatenation-tp4650817p4651094.html > Sent from the R help mailing list archive at Nabble.com. > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting- > guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
