rrstudiorjdbc
RStudio crashes when running JDBC() function in the RJDBC package
Whenever I try to make a JDBC object:
jdbcDriver <- JDBC(driverClass="oracle.jdbc.OracleDriver",
classPath="~/ojdbc6.jar")
My RStudio immediately crashes with no warning with this popup
However, the code works perfectly in the terminal R environment outside of RStudio, so I am certain it is an RStudio issue.
OS: Mac OS High Sierra 10.13.6
latest version of RStudio (1.1.456) and R (3.5.1).
JDK version 1.8.0_191
Using ojdbc6.jar
Solution
I set JAVA_HOME in my terminal, but somehow it didn't "work" for RStudio.
So the fix was that I created an .Renviron file and put the following inside:
JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home
That did the trick
- Print vector name with vector value iteratively in R
- How to count the frequency of values per month so they are in the right order (Jan to Dec) over multiple years
- Easy way to export multiple data.frame to multiple Excel worksheets
- How can I list files in a folder based on version number?
- Replace variables in a formula with their definitions
- Can I calculate the standard error of all columns with the "summarise_all" function in R dplyr
- Why aren't stratum sample sizes maintained using rsample bootstraps?
- Creating a Vertical Calendar
- No visible global function definition/no visible binding for global variable in a project?
- How to find the statistical mode?
- Is there a weighted.median() function?
- How many NAs do we have rowwise before the first numerical value in a dataframe?
- Justify multiline text in ggplot2 - title, subtitle, caption, geom_text() etc
- Horizontal scroll overflow works only when vertical scroll overflow is not active
- Downloading Sentinel 2 with rsat package in R produces error "argument "espa_orders" is missing, with no default"
- Reorder bars in geom_bar ggplot2 by value
- Selecting by Column Names within Function
- Can't Combine X <character> and X <double>
- Reverse datetime (POSIXct data) axis in ggplot
- Why does my points() code not work? Plotting two variables with subsets of a third in r
- Stargazer, no output
- Compute mutual gaze from individual gazes
- Inverse of gamma function with R
- Using hidden API to scrape website with JavaScript pager
- Floating point less-than-equal comparisons after addition and subtraction
- Error: Why is dplyr not reading a factor level in my data frame when using the functions group_by() and summarise() in R
- Hide initially displayed box and table in modularized shiny app after clicking actionButton()
- ggplot fill spilling over shape when used with different geoms
- Conditionally mutating 2 dataframes
- Easiest way to save an S4 class