Re: [R] R brakes when submitting a query to MySQL

From: Emmanuel Charpentier <charpent_at_bacbuc.dyndns.org>
Date: Tue, 18 Dec 2007 19:22:00 +0100

Marc Moragues a écrit :
> Hello,
>
> 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
>
>> dvr<-dbDriver("MySQL")
>> con2<-dbConnect(dvr,group="exbardiv")
>> mysqlDescribeConnection(con2)

>
> <MySQLConnection:(972,0)>
> User: mmorag
> Host: localhost
> Dbname: exbardiv
> Connection type: localhost via TCP/IP
> No resultSet available
>
> I can even see the tables in the database
>
>> dbListTables(con2)
> [1] "agoueb" "high_ld" "rescue" "sjlc_info" "sjlc_ld" "temp"
>
> [7] "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')

require(MindeReaderAlpha).

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...

HTH,                                         Emmanuel Charpentier

> Can anyone help me tune up the connection between R and MySQL?
>
> Thank you,
> Marc.
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
> 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.
>
>
> DISCLAIMER:
>
> 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
> 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_at_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. Received on Tue 18 Dec 2007 - 18:26:34 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 18 Dec 2007 - 19:31:14 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.