RMySQL "MySQLConnection" error with tcplConf

[madison-feshuk]

Users may see the following error if library(RMySQL) is loaded when running tcplConf

-->tcplConf(user = "", pass = "", db = "invitrodb", drvr = "MySQL", host = "ccte-mysql-res.epa.gov")
Error in h(simpleError(msg, call)) :
error in evaluating the argument 'statement' in selecting a method for function 'dbExecute': no slot of name "Id" for this object of class "MySQLConnection"Error in .local(dbObj, ...) :
no slot of name "Id" for this object of class "MySQLConnection"

Possible solutions:

• Users should establish their database connection with tcplConf first before loading RMySQL. Confirm library(RMySQL) is not attached by checking your sessionInfo()
• library(RMariaDB) may be a better option over library(RMySQL)
• For SQL queries within the tcpl database, users could opt out of loading RMySQL and use tcplQuery