Cannot load rJava and RDBC packages to connect to Aurora

[lopezfelipe]

Link to the notebook Add the link to the notebook.

Describe the bug The lifecycle configuration shown here does not have the dependencies required to load the RJDBC package. The notebook returns an error because the rJava package cannot be found.

To reproduce Launch the CloudFormation template, load the aurora_connect.ipynb notebook, enter the required fields as described in the notebook. The error message will appear when trying to load the rJava and RJDBC packages.

Logs If applicable, add logs to help explain your problem.

`Error: package or namespace load failed for ‘rJava’: .onLoad failed in loadNamespace() for 'rJava', details: call: dyn.load(file, DLLpath = DLLpath, ...) error: unable to load shared object '/home/ec2-user/anaconda3/envs/R/lib/R/library/rJava/libs/rJava.so': libjvm.so: cannot open shared object file: No such file or directory Traceback:

1. library(rJava)
2. tryCatch({ . attr(package, "LibPath") <- which.lib.loc . ns <- loadNamespace(package, lib.loc) . env <- attachNamespace(ns, pos = pos, deps, exclude, include.only) . }, error = function(e) { . P <- if (!is.null(cc <- conditionCall(e))) . paste(" in", deparse(cc)[1L]) . else "" . msg <- gettextf("package or namespace load failed for %s%s:\n %s", . sQuote(package), P, conditionMessage(e)) . if (logical.return && !quietly) . message(paste("Error:", msg), domain = NA) . else stop(msg, call. = FALSE, domain = NA) . })
3. tryCatchList(expr, classes, parentenv, handlers)
4. tryCatchOne(expr, names, parentenv, handlers[[1L]])
5. value[3L]
6. stop(msg, call. = FALSE, domain = NA)`