monetdblite doesn't seem to work with `pool`

[joelgombin]

Reprex:

``` r
# library(DBI)
# dbdir <- "~/test/monetdb"
# con <- dbConnect(MonetDBLite::MonetDBLite(), dbdir)
# dbWriteTable(con, "mtcars", mtcars)
# dbListTables(con)

library(DBI)
library(MonetDBLite)
library(pool)

pool <- dbPool(
  drv = MonetDBLite(),
  path = "~/test/monetdb"
)

dbGetQuery(pool, "SELECT * FROM mtcars LIMIT 5;")
#> Error in .local(conn, statement, ...): Unable to execute statement 'SELECT * FROM mtcars LIMIT 5;'.
#> Server says 'ParseException:SQLparser:42S02!SELECT: no such table 'mtcars''.
dbListTables(pool)
#> character(0)

Session info

``` r devtools::session_info() #> Session info ------------------------------------------------------------- #> setting value #> version R version 3.4.1 (2017-06-30) #> system x86_64, linux-gnu #> ui X11 #> language fr_FR #> collate fr_FR.UTF-8 #> tz Europe/Paris #> date 2017-08-19 #> Packages ----------------------------------------------------------------- #> package * version date #> assertthat 0.2.0 2017-04-11 #> backports 1.1.0 2017-05-22 #> base * 3.4.1 2017-07-08 #> bindr 0.1 2016-11-13 #> bindrcpp 0.2 2017-06-17 #> codetools 0.2-15 2016-10-05 #> compiler 3.4.1 2017-07-08 #> datasets * 3.4.1 2017-07-08 #> DBI * 0.7 2017-06-18 #> dbplyr 1.1.0 2017-06-27 #> devtools 1.13.3 2017-08-02 #> digest 0.6.12 2017-01-27 #> dplyr 0.7.2 2017-07-20 #> evaluate 0.10.1 2017-06-24 #> glue 1.1.1 2017-06-21 #> graphics * 3.4.1 2017-07-08 #> grDevices * 3.4.1 2017-07-08 #> htmltools 0.3.6 2017-04-28 #> knitr 1.16 2017-05-18 #> later 0.3 2017-06-25 #> magrittr 1.5 2014-11-22 #> memoise 1.1.0 2017-04-21 #> methods * 3.4.1 2017-07-08 #> MonetDBLite * 0.4.2 2017-08-19 #> pkgconfig 2.0.1 2017-03-21 #> pool * 0.1.0.9000 2017-08-19 #> R6 2.2.2 2017-06-17 #> Rcpp 0.12.12 2017-07-15 #> rlang 0.1.2.9000 2017-08-19 #> rmarkdown 1.6 2017-06-15 #> rprojroot 1.2 2017-01-16 #> stats * 3.4.1 2017-07-08 #> stringi 1.1.5 2017-04-07 #> stringr 1.2.0 2017-02-18 #> tibble 1.3.3 2017-07-25 #> tools 3.4.1 2017-07-08 #> utils * 3.4.1 2017-07-08 #> withr 2.0.0 2017-07-28 #> yaml 2.1.14 2016-11-12 #> source #> cran (@0.2.0) #> CRAN (R 3.4.0) #> local #> CRAN (R 3.4.0) #> CRAN (R 3.4.0) #> CRAN (R 3.3.1) #> local #> local #> CRAN (R 3.4.0) #> CRAN (R 3.4.0) #> CRAN (R 3.4.1) #> CRAN (R 3.4.0) #> cran (@0.7.2) #> CRAN (R 3.4.0) #> CRAN (R 3.4.0) #> local #> local #> CRAN (R 3.4.0) #> CRAN (R 3.4.0) #> cran (@0.3) #> CRAN (R 3.4.0) #> CRAN (R 3.4.0) #> local #> Github (hannesmuehleisen/MonetDBLite@c649d9d) #> cran (@2.0.1) #> Github (rstudio/pool@3073b62) #> CRAN (R 3.4.0) #> CRAN (R 3.4.0) #> Github (hadley/rlang@0e62148) #> CRAN (R 3.4.0) #> CRAN (R 3.3.2) #> local #> cran (@1.1.5) #> cran (@1.2.0) #> Github (tidyverse/tibble@d8ffbed) #> local #> local #> CRAN (R 3.4.1) #> CRAN (R 3.3.2) ```

[hannes]

Try

pool <- dbPool( drv = MonetDBLite(), embedded = "~/test/monetdb" )

On 2017-08-20, at 00:00, Joel Gombin notifications@github.com wrote:

Reprex:

# library(DBI)
# dbdir <- "~/test/monetdb"
# con <- dbConnect(MonetDBLite::MonetDBLite(), dbdir)
# dbWriteTable(con, "mtcars", mtcars)
# dbListTables(con)

library(
DBI
)
library(
MonetDBLite
)
library(
pool
)

pool <-
 dbPool(

drv =
 MonetDBLite(),

path = "~/test/monetdb"

)

dbGetQuery(
pool, "SELECT * FROM mtcars LIMIT 5;"
)

#> Error in .local(conn, statement, ...): Unable to execute statement 'SELECT * FROM mtcars LIMIT 5;'.
#> Server says 'ParseException:SQLparser:42S02!SELECT: no such table 'mtcars''.

dbListTables(
pool
)

#> character(0)
Session info

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[joelgombin]

Ah, my bad, wasn't sure of the name the argument should take. This works. Thanks!