[R] R brakes when submitting a query to MySQL
charpent at bacbuc.dyndns.org
Tue Dec 18 19:22:00 CET 2007
Marc Moragues a écrit :
> I would like to retrieve data stored in MySQL database, so I installed
> RMySQL package.
> I can successfully connect with the my database using the following code
> User: mmorag
> Host: localhost
> Dbname: exbardiv
> Connection type: localhost via TCP/IP
> No resultSet available
> I can even see the tables in the database
>  "agoueb" "high_ld" "rescue" "sjlc_info" "sjlc_ld" "temp"
>  "temp_snp1" "temp_snp2"
> However, when I try to query the database, R breakes.
What does *that* means ? You should be a bit more descriptive...
> res<-dbSendQuery(con,'select * from sjlc_ld')
Hmmmm ... Isn't the "breakage" just a loooong wait with no answer ? Or
maybe a timeout ?
In which case I'd try to put a semicolon (";") at the end of the SQL
query, thus making it syntactically valid SQL...
> Can anyone help me tune up the connection between R and MySQL?
> Thank you,
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> SCRI, Invergowrie, Dundee, DD2 5DA.
> The Scottish Crop Research Institute is a charitable company limited by guarantee.
> Registered in Scotland No: SC 29367.
> Recognised by the Inland Revenue as a Scottish Charity No: SC 006662.
> This email is from the Scottish Crop Research Institute, but the views
> expressed by the sender are not necessarily the views of SCRI and its
> subsidiaries. This email and any files transmitted with it are confidential
> to the intended recipient at the e-mail address to which it has been
> addressed. It may not be disclosed or used by any other than that addressee.
> If you are not the intended recipient you are requested to preserve this
> confidentiality and you must not use, disclose, copy, print or rely on this
> e-mail in any way. Please notify postmaster at scri.ac.uk quoting the
> name of the sender and delete the email from your system.
> Although SCRI has taken reasonable precautions to ensure no viruses are
> present in this email, neither the Institute nor the sender accepts any
> responsibility for any viruses, and it is your responsibility to scan the email
> and the attachments (if any).
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help