Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Question on Java Required version #109

Closed
AllanRTate opened this issue Jul 28, 2020 · 2 comments · Fixed by #116
Closed

Question on Java Required version #109

AllanRTate opened this issue Jul 28, 2020 · 2 comments · Fixed by #116

Comments

@AllanRTate
Copy link

Hello,
I'm relatively new to R and am trying to use it with Excel files. I'm using:

RStudio v. 1.3.1056
R version 4.0.2
java version "14.0.2" 2020-07-14

I successfully installed XLConnect, but loading the package failed with this error:

error: Installed java version 14.0.2+12-46 is not between Java>=8 and <=11! This is needed for this package

Questions:

  1. Where are system requirements detailed? The user manual only said jre v6 or higher.
  2. Is support for java v. 14 coming and if so when?
  3. Besides downgrading to java v. 11, is there another option to solve this?
  4. Is there an alternative to XLConnect?

Thanks,

Allan
@spoltier
Copy link
Member

Hi @AllanRTate,

We'll likely include support for later java versions at some point in the future. Don't have a timeline for that unfortunately.
In general, you should use CRAN to install and see requirements of R packages. See for XLConnect: https://cran.r-project.org/package=XLConnect.
Unfortunately, there is no other way but to downgrade to java 11.
Depending on what you're looking for, there are some alternatives, e.g. xlsx.

spoltier referenced this issue Sep 24, 2020
@spoltier
safer java check, cran comments
ef9262c
@CidaJiang
Copy link

Dear Spoltier,

This is a new user of the XLConnect.package.
Same to AllenRTate, I also have the question that require(XLConnect) failed, as following:

"Error: package or namespace load failed for ‘XLConnect’:
.onLoad failed in loadNamespace() for 'XLConnect', details:
call: fun(libname, pkgname)
error: Installed java version 15.0.1+9-18 is not between Java>=8 and <=11! This is needed for this package"

I spent two whole days to solve the problem, but failed.
I don't know why I get the error.

I'm using:

_macOS Catalina 10.15.7

R version 4.0.3 (2020-10-10) (64-bit)

java version "15.0.1" 2020-10-20
Java(TM) SE Runtime Environment (build 15.0.1+9-18)
Java HotSpot(TM) 64-Bit Server VM (build 15.0.1+9-18, mixed mode, sharing)_

In addition, I require(rJava) successfully in R.

What should I do to require(XLConnect) successfully?

Thanks.

Cida

spoltier added a commit that referenced this issue Dec 3, 2020
@spoltier
#109 extend and document java check tolerance
fb03c86
@spoltier spoltier mentioned this issue Dec 3, 2020
Closed
@spoltier spoltier mentioned this issue Dec 10, 2020
Merged
2 tasks
spoltier added a commit that referenced this issue Dec 24, 2020
@spoltier @riccardoporreca
Feature/java15 #109 (#116)
2b8104c 
* #109 extend and document java check tolerance

* #105 stub action

Stub action as generated by github workflow starter

* #105 WIP basic setup

* #105 activate for current branch

* #105 use more recent setup R version

* #105 os matrix, javareconf

* #105 javareconf as root

* Install rJava from package manager

* #105 nonroot javareconf

* #105 java debugging

* #105 more java debugging

* #105 try r version 4 only

* #105 debug PATH

* #105 set vars for javareconf

* #105 alternatives wrong flag syntax

* #105 display javareconf output

* #105 display javareconf output

* #105 set vars before R install

* #105 remove preinstalled JVMs

* issue #105 check java home path

* #105 pass java home explicitly to javareconf

* #105 remove java check, too severe

* #105 add tinytex to build vignettes

* #105 no TeX, same check as travis

* #105 add changes from full example

* #105 param OS + version, skip vignettes

* #105 skip vignettes in build

* #105 upload if fail,  check XLConnect pkg file

* #105 debug check, pkg file not as expected

* #105 more file debugging

* #105 more debugging

* #105 retry with tinytex install

* #105 add LaTeX dependencies

* #105 use R helper functions for TeX deps

* #105 >_<

* #105 R install tinytex to get helper fns

* #105 conditionals, correct step order

* #105 more TeX deps

* #105 still need install tinytex

* #105 typo

* #105 compact vignettes

* #105 test nodoc path

* #105 typo build_args

* #105 more lenient option for no doc check

* #105 nodoc: ignore subdirectory issues

* #105 ignore warnings in nodoc

* issue #105 reduce size of upload, upload built pkg

* #105 more combinations

* #105 add windows + env vars

* #105 no windows, show test output

* #105 fallback to devtools if rcmdcheck not here

* #105 try MRAN snapshot for 3.2.5

* #105 cache incl. repo, temp. only legacy

* #105 avoid fallback on CRAN

* #105 explicit repos

* #105 use legacy-compatible sessionInfo()

* #105 install rcmdcheck from CRAN if available

* #105 no devtools fallback, all builds

* #105 coverage information

* #105 coverage -_-

* #105 covr sys dependencies

* #105 cover only if success, explicit checks

* #105 disable full test suite flag

* #105 effective TZ variation

* #105 reactivate full test suite option

* #105 remove commented out code

* #105 run complete test suite

* #105 install built package to run tests

* #105 correct path to src package

* #105 set RCMDCHECK var explicitly

* #105 working dir for test suite

* #105 correct path to test output

* #105 clean after full tests

* #105 Windows

* #105 typo in conditional

* #105 windows: use cmd shell

* #105 Windows: no javareconf >_<

* #105 windows: set pkg repo as quick fix

* #105 Windows: check java version

* #105 Java: both x64 and x86

* #105 java x86 exception

* #105 restrict to java x64 on macOS

* #105 abridged check witout multi archs

* #105 single arch for full test suite

* #105 temp: check windows only

* #105 reactivate others, multiarch except on win

* #105 typo in R conditional

* Update .github/workflows/ci-tests.yml

Co-authored-by: Riccardo Porreca <[email protected]>

* Apply suggestions from code review

Co-authored-by: Riccardo Porreca <[email protected]>

* #105 suggestions: coverage, artifact name

* #105 full build on oldrel + devel

* #105 quotes

* #105 readable artifact name

* #105 disambiguate failure results artifact

Co-authored-by: Riccardo Porreca <[email protected]>
spoltier added a commit that referenced this issue Feb 11, 2021
@spoltier
Check system dependencies using pkg manager (#117)
9515879 
* #109 extend and document java check tolerance

* #105 stub action

Stub action as generated by github workflow starter

* #105 WIP basic setup

* #105 activate for current branch

* #105 use more recent setup R version

* #105 os matrix, javareconf

* #105 javareconf as root

* Install rJava from package manager

* #105 nonroot javareconf

* #105 java debugging

* #105 more java debugging

* #105 try r version 4 only

* #105 debug PATH

* #105 set vars for javareconf

* #105 alternatives wrong flag syntax

* #105 display javareconf output

* #105 display javareconf output

* #105 set vars before R install

* #105 remove preinstalled JVMs

* issue #105 check java home path

* #105 pass java home explicitly to javareconf

* #105 remove java check, too severe

* #105 add tinytex to build vignettes

* #105 no TeX, same check as travis

* #105 add changes from full example

* #105 param OS + version, skip vignettes

* #105 skip vignettes in build

* #105 upload if fail,  check XLConnect pkg file

* #105 debug check, pkg file not as expected

* #105 more file debugging

* #105 more debugging

* #105 retry with tinytex install

* #105 add LaTeX dependencies

* #105 use R helper functions for TeX deps

* #105 >_<

* #105 R install tinytex to get helper fns

* #105 conditionals, correct step order

* #105 more TeX deps

* #105 still need install tinytex

* #105 typo

* #105 compact vignettes

* #105 test nodoc path

* #105 typo build_args

* #105 more lenient option for no doc check

* #105 nodoc: ignore subdirectory issues

* #105 ignore warnings in nodoc

* issue #105 reduce size of upload, upload built pkg

* #105 more combinations

* #105 add windows + env vars

* #105 no windows, show test output

* #105 fallback to devtools if rcmdcheck not here

* #105 try MRAN snapshot for 3.2.5

* #105 cache incl. repo, temp. only legacy

* #105 avoid fallback on CRAN

* #105 explicit repos

* #105 use legacy-compatible sessionInfo()

* #105 install rcmdcheck from CRAN if available

* #105 no devtools fallback, all builds

* #105 coverage information

* #105 coverage -_-

* #105 covr sys dependencies

* #105 cover only if success, explicit checks

* #105 disable full test suite flag

* #105 effective TZ variation

* #105 reactivate full test suite option

* #105 remove commented out code

* #105 run complete test suite

* #105 install built package to run tests

* #105 correct path to src package

* #105 set RCMDCHECK var explicitly

* #105 working dir for test suite

* #105 correct path to test output

* #105 clean after full tests

* #105 Windows

* #105 typo in conditional

* #105 windows: use cmd shell

* #105 Windows: no javareconf >_<

* #105 windows: set pkg repo as quick fix

* #105 Windows: check java version

* #105 Java: both x64 and x86

* #105 java x86 exception

* #105 restrict to java x64 on macOS

* #105 abridged check witout multi archs

* #105 single arch for full test suite

* #105 temp: check windows only

* #105 reactivate others, multiarch except on win

* #105 typo in R conditional

* fix copy paste error in dependency loading

* Issues #103, #106 - add poi ooxml schemas

* #103, #106 - test xlsx file

* Check system packages - incl. debian names

* Add available RPM package names

* Javadeps: suppress warnings of pkg queries

* Javadeps: suppress system check warnings

* JavaDeps try suppressing pkg messages

* JavaDeps: use capture.output for system calls

* JavaDeps: check distro

* trim immediately after capture.output

* JavaDeps simplify, capture not needed

* JavaDeps remove NOTEs

* JavaDeps - ignore util function in codecov

* JavaDeps fix rpm version check

* JavaDeps - try latest R setup

* JavaDeps - disable macOs not working

* JavaDeps revert r setup to v1

* JavaDeps - patched action for macOs

* Prepare cran comments for upcoming release

* Upgrade java dependencies

* check if non-legacy works

* JavaDeps - PR was merged, set to master actions

* JavaDeps keep previous POI version

* JavaDeps - NEWS update

* JavaDeps: update POI, off by 1 last row of empty

* JavaDeps use backwards compatible XLConnect, revert tests

* JavaDeps - java check before d/l pkg when installing

* JavaDeps - check java version without .jinit

* JavaDeps copyright headers

* PR feedback: java version check message

* PR Feedback: reword CRAN comment

* PR feedback 2nd round of copyright headers

* PR feedback remove wordpress references

* PR feedback install instructions

* JavaDeps final 1.0.2 JAR
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Feature/java15 #109 miraisolutions/xlconnect
3 participants
@spoltier @AllanRTate @CidaJiang