OHDSI Home | Forums | Wiki | Github

Connection from R to the Redshift database while Achilles installation

Developers
#1

Hi Folks ,

We have followed the instruction to install Achilles and while creating the database connector to Redshift it is throwing below error and we tries directly connecting the Redshift from R it is working .

Command we are trying

achilles(connectionDetails, cdmDatabaseSchema = “nephroplus”,
. resultsDatabaseSchema = “results”, vocabDatabaseSchema = “vocabulary”,
. numThreads = 1, sourceName = “My Source Name”, cdmVersion = “5.3.0”,
. runHeel = TRUE, runCostAnalysis = TRUE)

Please let us know if we need additional configuration in R for this to work .

Error

Error in rJava::.jcall(jdbcDriver, “Ljava/sql/Connection;”, “connect”, : java.sql.SQLException: Amazon Error setting default driver property values.
Traceback:

  1. achilles(connectionDetails, cdmDatabaseSchema = “nephroplus”,
    . resultsDatabaseSchema = “results”, vocabDatabaseSchema = “vocabulary”,
    . numThreads = 1, sourceName = “My Source Name”, cdmVersion = “5.3.0”,
    . runHeel = TRUE, runCostAnalysis = TRUE)
  2. DatabaseConnector::connect(connectionDetails = connectionDetails)
  3. connect(dbms = connectionDetails$dbms, user = connectionDetails$user,
    . password = connectionDetails$password, server = connectionDetails$server,
    . port = connectionDetails$port, schema = connectionDetails$schema,
    . extraSettings = connectionDetails$extraSettings, oracleDriver = connectionDetails$oracleDriver,
    . connectionString = connectionDetails$connectionString, pathToDriver = connectionDetails$pathToDriver)
  4. connectUsingJdbcDriver(driver, connectionString, user = user,
    . password = password, dbms = dbms)
  5. rJava::.jcall(jdbcDriver, “Ljava/sql/Connection;”, “connect”,
    . as.character(url), p)
  6. .jcheck(silent = FALSE)

Regards
Abhishek Verma

#2

The Operating system is Linux Ubuntu 20 and Java 8 is installed on it .

#3

Hi @abhiiitr02,

So to confirm, when you run this:

connection <- DatabaseConnector::connect(connectionDetails = connectionDetails)

you get no error?

Thanks,
Ajit

t