search for: mysqlconnect

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