Displaying 16 results from an estimated 16 matches for "mysqlconnect".
Did you mean:
mysql_connect
2012 Mar 24
2
RC / methods package
(I think this is being caused by the new methods package in RC.)
In the RC (March 24) some of my packages are generating a Note
Note: Method with signature "MySQLConnection#integer" chosen for
function "coerce",
target signature "TSMySQLConnection#integer".
"dbObjectId#integer" would also be valid
This is coming from a call to dbGetQuery() in package DBI. The method
with the signature "TSMySQLConnection#integer" i...
2007 Jul 16
1
S4 coerce
...classDef,
2: methods currently exist for coercing from "TSconnection" to
"DBIConnection"; they will be replaced. in:
..removePreviousCoerce(class1, class2, where, prevIs)
# (warning may be important, but I don't understand it)
> setAs("TSconnection", "MySQLConnection", def = function(from) from at con)
> setIs("TSconnection", "MySQLConnection", coerce = function(x) x at con)
Warning messages:
1: there is no automatic definition for as(object, "MySQLConnection") <-
value when object has class "TSconnection"...
2011 Mar 13
2
Problems getting html files out of R CMD check
...e
prepare_Rd: loadTable.Rd:35-37: Dropping empty section \references
prepare_Rd: mapMetadataToTable.Rd:53-55: Dropping empty section \note
prepare_Rd: mapMetadataToTable.Rd:47-49: Dropping empty section \references
prepare_Rd: mapMetadataToTable.Rd:59-61: Dropping empty section \seealso
prepare_Rd: mySqlConnect.Rd:27-29: Dropping empty section \details
prepare_Rd: mySqlConnect.Rd:39-41: Dropping empty section \note
prepare_Rd: mySqlConnect.Rd:33-35: Dropping empty section \references
prepare_Rd: mySqlConnect.Rd:43-45: Dropping empty section \seealso
prepare_Rd: mySqlConnect.Rd:46: Dropping empty section \...
2007 Dec 18
2
R brakes when submitting a query to MySQL
...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" &q...
2001 Aug 15
1
Re: R: Mailing Lists
...es not work in assignTable() in RMySQL ?
More specifically: I cannot append a data.frame to an existing table
in a MySQL database, although I can use the same data.frame to
create a new table.
Even more specifically:
> assignTable(con,"employee",dita,append=T)
Error in execStatement.MySQLConnection(con, statement, ...) :
RS-DBI driver: (could not run statement: Table 'employee'
already exists)
[1] FALSE
===
Jan de Leeuw; Professor and Chair, UCLA Department of Statistics;
US mail: 9432 Boulter Hall, Box 951554, Los Angeles, CA 90095-1554
phone (310)-825-9550; fax (310)-...
2007 Mar 20
1
RMySQL load error
...d package: DBI
[1] "dbObjectId"
[1] "format"
[1] "show"
[1] "print"
[1] "MySQLObject"
[1] "MySQLDriver"
[1] "dbUnloadDriver"
[1] "dbGetInfo"
[1] "dbListConnections"
[1] "summary"
[1] "MySQLConnection"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbDisconnect"
[1] "dbSendQuery"
[1] "dbGetQuery"
[1] "dbGetException"
[1] "dbGetInfo"
[1] "dbListResults"
[1] "summary"
[1] &q...
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
...st
** save image
[1] TRUE
[1] "dbObjectId"
[1] "format"
[1] "show"
[1] "print"
[1] "MySQLObject"
[1] "MySQLDriver"
[1] "dbUnloadDriver"
[1] "dbGetInfo"
[1] "dbListConnections"
[1] "summary"
[1] "MySQLConnection"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbDisconnect"
[1] "dbSendQuery"
[1] "dbGetQuery"
[1] "dbGetException"
[1] "dbGetInfo"
[1] "dbListResults"
[1] "summary"
[1] "dbListT...
2005 Mar 09
1
RMySQL installed but not availalable
...t;
> [1] "format"
> [1] "show"
> [1] "print"
> [1] "MySQLObject"
> [1] "MySQLDriver"
> [1] "dbUnloadDriver"
> [1] "dbGetInfo"
> [1] "dbListConnections"
> [1] "summary"
> [1] "MySQLConnection"
> [1] "dbConnect"
> [1] "dbConnect"
> [1] "dbConnect"
> [1] "dbDisconnect"
> [1] "dbSendQuery"
> [1] "dbGetQuery"
> [1] "dbGetException"
> [1] "dbGetInfo"
> [1] "dbListResults&qu...
2003 Jul 15
1
dbApply (R newbee)
I am trying to use R interfaced with MySQL. Present goal is that R should
calculate the 85% quantile of AvgSpeed for each LinieID. Looking through
documentation of the RMySQL Package, I guessed that dbApply would do the
trick due to this example
## compute quanitiles for each network agent
con <- dbConnect(MySQL(), group="vitalAnalysis")
res <- dbSendQuery(con,
2002 Dec 18
1
A little problem handling logicals in RMySQL under R1.6.1
There is a little problem in handling logicals in RMySQL:
# here is the MySQL connection
> con
<MySQLConnection:(1816,0)>
# here is the data frame
> print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE)))
x y
1 TRUE FALSE
2 FALSE TRUE
# as promised, the two data frame columns are identified as logicals and
# the field types are set to tinyint
> field.types <- sapply(a, dbDataT...
2003 Sep 09
0
problem trying to use a superclass on R-1.7.1
...return(.Object);
}
);
#-----------------------------------------------------
# CLASS Employee (extends Person)
#-----------------------------------------------------
setClass("Employee",representation("Person", service="character",
con="MySQLConnection"));
# con : connection to be established with MySQL database
# constructor
setMethod("initialize","Employee",
function(.Object)
{
.Object <- callNextMethod(); # calls the superclass
constructor
.Object at con <-...
2003 Sep 29
0
problems trying to extend a class
...return(.Object);
}
);
#-----------------------------------------------------
# CLASS Employee (extends Person)
#-----------------------------------------------------
setClass("Employee",representation("Person", service="character",
con="MySQLConnection"));
# con : connection to be established with MySQL database
# constructor
setMethod("initialize","Employee",
function(.Object)
{
.Object <- callNextMethod(); # calls the superclass
constructor
.Object at con <-...
1999 Feb 02
0
Suggestion
...write extensions to R regularly.
One of them was an interface to a mysql database on a
different computer. The best way to do that is to have
something like
mysql<-function (dbname, host = "zap", user = "nobody", password = "ok")
{
handle <<- .RC("mysqlconnect", c(host, user, password, dbname))
}
and
query<-function (cmd)
{
.RC("mysqlquery", handle, cmd)
}
In other words, my mysql (written in C) functions return a true R object.
The .RC function above simply calls the C funtion, passing R objects as
arguments and returns the R o...
2010 Jul 16
1
Troubles with DBI's dbWriteTable in RMySQL
...the last statement above.
On the asumption tha tthat is a data frame, I tried
dbWriteTable(con,"test1",ndf);
But I received the following error:
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbWriteTable", for
signature "MySQLConnection", "character", "matrix"
Then, on the assumption it is trivial to convert a matrix into a data.frame,
i tried:
dbWriteTable(con,"test2",as.data.frame(ndf));
But this produced the following error:
Error in write.table(x, file, nrow(x), p, rnames, sep, eol, na,...
2009 Feb 23
0
Segmentation Fault still exists
...exist",*
* default.file))*
* }*
* drvId <- as(drv, "integer")*
* conId <- .Call("RS_MySQL_newConnection", drvId, con.params,*
* groups, default.file, PACKAGE = .MySQLPkgName)
// here it gets stopped,traceback line 1*
* new("MySQLConnection", Id = conId)*
*}*
--
Thanks in advance
Moumita
[[alternative HTML version deleted]]
2007 Dec 21
0
RMySQL installation
...mat" in "RMySQL"
Creating a new generic function for "print" in "RMySQL"
** help
>>> Building/Updating help pages for package 'RMySQL'
Formats: text html latex example
MySQL text html latex example
MySQLConnection-class text html latex example
MySQLDriver-class text html latex example
MySQLObject-class text html latex example
MySQLResult-class text html latex example
RMySQL-package te...