[IPython-dev] RJDBC in IPython using rmagic

Alessandro Gagliardi adfgagliardi at gmail.com
Fri Oct 18 16:58:00 EDT 2013


I would like to be able to access a MS SQL Server Database in R through
IPython Notebook. I've been able to get RJDBC to work in R natively, but
when I try to load the library through rmagic, I get the following error:

Loading required package: rJava
Error : .onLoad failed in loadNamespace() for 'rJava', details:
  call: dyn.load(file, DLLpath = DLLpath, ...)
  error: unable to load shared object
'/usr/local/lib/R/site-library/rJava/libs/rJava.so':
  libjvm.so: cannot open shared object file: No such file or directory
Error: package ‘rJava’ could not be loaded

It would seem that when R is being run through IPython Notebook, it cannot
find libjvm.so. I'm not entirely clear on how rmagic works (and how running
commands through a cell headed with %%R is different from running the same
through R itself). Any help would be much appreciated.

Thank you,

Alessandro Gagliardi
Sr. Data Scientist, Glassdoor.com
alessandro.gagliardi at glassdoor.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ipython-dev/attachments/20131018/6c33faef/attachment.html>


More information about the IPython-dev mailing list