<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ rootadoname | tolower() ] failed in the evaluation of <p> Pure R ???????? ??SQL ?????R ???Java ???????????????????[datasource] ??????[company_name] JDBC Driver for [service] ?RJDBC package ?????R ?????[datasource] ????????[company_name] Driver ?????????????????????????????????????????????R ????????????????????????????????[service] ?SQL ????????????????R ????????[datasource] ?????????????????????? </p> <h2>R ???????</h2> <p> ????????Microsoft R Open ???????????BLAS/LAPACK ???????????????? R ??????????????????????????????????????????????????????????????????Microsoft R Open 3.2.3 ???????CRAN ??????Jan. 1, 2016 snapshot ????????????????????????????????snapshot ??????????? </p> <h2>RJDBC ?????????</h2> <p> ??????????RJDBC ????????????????RJDBC ??????????????????????????????????????? </p> <code> library(RJDBC) </code> <h2>JDBC ?????????[service] ???</h2> <p> ????????[service] ?JDBC ??????????????? </p> <ul> <li>Driver Class:[company_name|tolower()].jdbc.[rootadoname|tolower()].[rootadoname]Driver ???? <li>Classpath:Driver JAR ??????????????????????????????[lib]????????? </ul> <p> dbConnect ?dbSendQuery ????DBI ????R ?????????????????????????????????? </p> <code> driver <- JDBC(driverClass = "[company_name|tolower()].jdbc.[rootadoname|tolower()].[rootadoname]Driver", classPath = "MyInstallationDir\lib\\[company_name|tolower].jdbc.[rootadoname|tolower()].jar", identifier.quote = "'") </code> <p> ????DBI ??????[service] ????SQL ?????????????????dbConnect ??????JDBC ??????????????JDBC ?????????????? </p> <code> conn <- dbConnect(driver,"[extraconnectionprops]") </code> <p> [extraconnectionnotes|def('')] </p> <h2>???? Discovery</h2> <p> ??????[service] API ?????????????????????????????????????????????????????????????? </p> <code> dbListTables(conn) </code> <h2>SQL ??????</h2> <p> dbGetQuery ??????[service] API ???????????SQL ??????????: </p> <code> [extable|tolower] <- dbGetQuery(conn,"[query]") </code> <p> ??????????????[data viewer]???????????????? </p> <code> View([extable|tolower]) </code> <h2>[service] [datatype] ?????</h2> <p> CRAN ??????????????????????????????[datasource] ??????????????????????plot ??????????????????? </p> <code> par(las=2,ps=10,mar=c(5,15,4,2)) barplot([extable|tolower]$[excol#2], main="[service] [extable]", names.arg = [extable|tolower]$[excol#1], horiz=TRUE) </code> <img src="../articles/jdbc-r-1.png" title="A basic bar plot. (Salesforce is shown.)"/>. The error was: The attribute does not exist. This formatter cannot be called with nonexistent attributes.<br><b>URL</b>: /jp/kb/tech/sql-jdbc-r.rst