r - rjdbc Parallel query with parallelmap -


i'm trying run query in parallele , 00001: error in .jcheck() : no running jvm detected. maybe .jinit() help. error. queries working when run them 1 one

my script:

i know it's not reproductible can't give give log/pass :)

i tried .jinit() , sys.setenv(java_home='c:\\program files\\java\\jdk1.8.0_102') in slave it's not working

library(rjdbc) library(parallelemap)  jdbcdriver <- jdbc(driverclass="oracle.jdbc.oracledriver",  classpath="ojdbc6.jar" ) jdbcconnection <- dbconnect(jdbcdriver, "jdbc:oracle:thin:@//mybase", "login", "pass")  query_list<- list( "select * table1",                    "select * table2",                    "select * table3",                    "select * table4",                     "select * table5")    import_base_fonction <- function(query) {return(dbgetquery( jdbcconnection , query))}   parallelstartsocket( 5 )   parallellibrary("rjdbc","rjava") parallelexport("listquery_list","import_base_fonction" ,"jdbcconnection")  mes_tables <- parallelmap(import_base_fonction,query_list)    parallelstop()

my session info 

r version 3.4.1 (2017-06-30) platform: x86_64-w64-mingw32/x64 (64-bit) running under: windows server >= 2012 x64 (build 9200)  matrix products: default  locale: [1] lc_collate=french_france.1252  lc_ctype=french_france.1252    lc_monetary=french_france.1252 lc_numeric=c                   lc_time=french_france.1252      attached base packages: [1] stats     graphics  grdevices utils     datasets  methods   base       other attached packages:  [1] parallelmap_1.3      phvid_1.0.8          mcmcpack_1.4-0       mass_7.3-47          coda_0.19-1          lbe_1.44.0           dplyr_0.7.1           [8] plyr_1.8.4           shiny_1.0.3          dt_0.2               shinydashboard_0.6.1 data.table_1.10.4    rjdbc_0.2-5          rjava_0.9-8          [15] dbi_0.7               loaded via namespace (and not attached):  [1] rcpp_0.12.11       compiler_3.4.1     bindr_0.1          tools_3.4.1        digest_0.6.12      checkmate_1.8.3    tibble_1.3.3       lattice_0.20-35     [9] pkgconfig_2.0.1    rlang_0.1.1        matrix_1.2-10      parallel_3.4.1     sparsem_1.77       bindrcpp_0.2       htmlwidgets_0.9    matrixmodels_0.4-1 [17] grid_3.4.1         glue_1.1.1         r6_2.2.2           magrittr_1.5       backports_1.1.0    bbmisc_1.11        htmltools_0.3.6    mcmc_0.9-5         [25] assertthat_0.2.0   mime_0.5           xtable_1.8-2       httpuv_1.3.5       quantreg_5.33

the base on oracle 11.xx server.

please guide.

i think can change import_base_fonction 

import_base_fonction <- function(query) {   .jinit("ojdbc6.jar")   return(dbgetquery( jdbcconnection , query))  }

Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

transpose - Maple isnt executing function but prints function term -

im using maple im in worksheetmode tried using maple input , 2d input , want transpose matrix a: := `<|>`(`<,>`(1, .5, -2), `<,>`(.5, 9/4+b, 5+3*b), `<,>`(-2, 5+3*b, 18+9*b+4*a)); b:= transpose(a); when exectute sheet dont translated values, there same input. matrix looks same input matrix plus function term. you can see picture in following link: why arent functions executed? meanwhile b:=a^+ doing right way , transposed matrix. other functions return function body instead needed values... if using 2d input mode (the default) space you've got between transpose , bracketed (b) interpreted multiplcation. rid of such space. also, either load package @ start of document like, with(linearalgebra): before calling transpose command package, or call it's full name like, linearalgebra:-transpose(b);
Read more