search for: isidcurrent

....findInheritedMethods(signature, fdef, mtable = allmethods, table = mlist, useInherited = useInherited, verbose = verbose) 9: selectMethod("coerce", sig, optional = TRUE, c(from = TRUE, to = FALSE), fdef = coerceFun, mlist = coerceMethods) 8: as(obj, "integer") 7: isIdCurrent(con) 6: postgresqlQuickSQL(conn, statement, ...) 5: dbGetQuery(con, paste("SELECT tbl FROM Meta ", where, ";")) 4: dbGetQuery(con, paste("SELECT tbl FROM Meta ", where, ";")) 3: TSdbi:::TSdeleteSQL(serIDs = serIDs, con = con, ...) 2: TSdelete("vec&quot...

..., if the connections is not alive anymore. if (!connected()) con<-dbConnect(MySQL(),user=.., password=..,host=..,db=..) But how can I do the test connected()? I thought the way to do this was, connected()<-function(){return (exists("con") & isIdCurrent(con))} But that does'n work, after some time connected() returns TRUE, but the next dbGetQuery signals Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: MySQL server has gone away) How can I test if the connection is still valid? Thanks Frans

...l latex example dbReadTable-methods text html latex example dbSendQuery-methods text html latex example dbSetDataMappings-methods text html latex example fetch-methods text html latex example isIdCurrent text html latex example make.db.names-methods text html latex example mysqlDBApply text html latex example mysqlSupport text html latex safe.write text htm...

...ext html latex example MySQLResult-class text html latex example S4R text html latex dbApply text html latex example dbObjectId-class text html latex example isIdCurrent text html latex example mysqlDBApply text html latex example mysqlSupport text html latex safe.write text html latex example * DONE (RMySQL) * checking package directory .....

...> dbReadTable-methods text html latex example > dbSendQuery-methods text html latex example > dbSetDataMappings-methods text html latex example > fetch-methods text html latex example > isIdCurrent text html latex example > make.db.names-methods text html latex example > mysqlDBApply text html latex example > mysqlSupport text html latex > safe.write...

...A)* * }* * object* *}* *> mysqlNewConnection* *function (drv, dbname = "", username = "", password = "", host = "",* * unix.socket = "", port = 0, client.flag = 0, groups = NULL,* * default.file = character(0))* *{* * if (!isIdCurrent(drv))* * stop("expired manager")* * con.params <- as.character(c(username, password, host, dbname,* * unix.socket, port, client.flag))* * groups <- as.character(groups)* * if (length(default.file) == 1) {* * default.file <- file.path(dirname(de...

...l latex example dbReadTable-methods text html latex example dbSendQuery-methods text html latex example dbSetDataMappings-methods text html latex example fetch-methods text html latex example isIdCurrent text html latex example make.db.names-methods text html latex example mysqlDBApply text html latex example mysqlSupport text html latex safe.write text htm...

...ext html latex example dbReadTable-methods text html latex example dbSendQuery-methods text html latex example dbSetDataMappings-methods text html latex example fetch-methods text html latex example isIdCurrent text html latex example make.db.names-methods text html latex example oraParseConParams text html latex example oraSupport text html latex safe.write text html lat...