dbWriteTable is causing a Warning in connection with the jsonlite package

[hannes101]

I am not really sure if this is really an issue in DBI, but perhaps it's caused by an update of the jsonlite package.
Since I've updated some packages, I get the following warning message, when writing a table into a SQL Server database, which worked before without the warning.

Found more than one class "blob" in cache; using the first, from namespace 'blob'
Also defined by ‘jsonlite’

The issue is also described in the following Stackoverflow question, but I think this should be handled upstream.
https://stackoverflow.com/questions/70994382/r-dbwritetable-more-than-one-class-warning/71039107

sessionInfo()
R version 4.0.2 (2020-06-22)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19042)

Matrix products: default

locale:
[1] LC_COLLATE=German_Germany.1252  LC_CTYPE=German_Germany.1252    LC_MONETARY=German_Germany.1252 LC_NUMERIC=C                   
[5] LC_TIME=German_Germany.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] openxlsx_4.2.4    utf8_1.2.2        vroom_1.3.2       forcats_0.5.0     purrr_0.3.4       readr_1.4.0       tidyr_1.1.4       tibble_3.1.6     
 [9] ggplot2_3.3.5     tidyverse_1.3.0   taskscheduleR_1.4 stringr_1.4.0     stringi_1.7.6     digest_0.6.29     rZISDB_1.3.0      rJava_1.0-4      
[17] xts_0.12.1        zoo_1.8-9         odbc_1.3.3        lubridate_1.8.0   ibmdbR_1.50.0     arules_1.6-6      Matrix_1.4-0      RODBC_1.3-17     
[25] dbplyr_1.4.4      dplyr_1.0.7       DBI_1.1.1         data.table_1.14.0 bbkutils_1.0.2   

loaded via a namespace (and not attached):
 [1] Rcpp_1.0.8       rpart.plot_3.0.9 lattice_0.20-45  assertthat_0.2.1 R6_2.5.0         cellranger_1.1.0 backports_1.4.1  reprex_0.3.0     httr_1.4.2      
[10] pillar_1.6.5     rlang_0.4.12     rematch_1.0.1    readxl_1.3.1     rstudioapi_0.13  blob_1.2.1       rpart_4.1-15     bit_4.0.4        munsell_0.5.0   
[19] broom_0.7.11     compiler_4.0.2   modelr_0.1.8     pkgconfig_2.0.3  tidyselect_1.1.1 fansi_1.0.2      withr_2.4.2      crayon_1.4.2     MASS_7.3-55     
[28] grid_4.0.2       jsonlite_1.7.3   gtable_0.3.0     lifecycle_1.0.1  magrittr_2.0.1   scales_1.1.1     writexl_1.3.1    zip_2.2.0        cli_2.2.0       
[37] fs_1.5.0         xml2_1.3.3       ellipsis_0.3.2   generics_0.1.0   vctrs_0.3.8      tools_4.0.2      bit64_4.0.5      glue_1.6.0       hms_1.1.0       
[46] parallel_4.0.2   colorspace_2.0-0 rvest_0.3.6      haven_2.4.1 

[hannes101]

Ok, this is caused by jsonlite, just found that @krlmlr already reported it here: jeroen/jsonlite#373

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.