jswerdel
commented
5 years ago The issue in in your connectionDetails setup. You will need to use the connection details specific for the database you are using.
Hope this helps.
Joel N. Swerdel, PhD MS MPH Associate Director, Epidemiology Analytics [Janssen_Hor_RGB] Janssen Research & Development jswerdel@ITS.JNJ.commailto:jswerdel@ITS.JNJ.com
From: jdratto notifications@github.com Sent: Tuesday, September 10, 2019 12:21 PM To: OHDSI/PheValuator PheValuator@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [EXTERNAL] [OHDSI/PheValuator] Error connecting (#7)
when I try to use the EvaluatingPhenotypeAlgorithms example I get this error. I can't tell if this is on my end or your end.
connectionDetails <- createConnectionDetails(dbms = "postgresql",
· server = "localhost/ohdsi",
*
· user = "joe",
*
· password = "supersecret")
*
phenoTest <- PheValuator::createPhenoModel(connectionDetails = connectionDetails,
· xSpecCohort = 1769699,
*
· cdmDatabaseSchema = "my_cdm_data",
*
· cohortDatabaseSchema = "my_results",
*
· cohortDatabaseTable = "cohort",
*
· outDatabaseSchema = "scratch.dbo", #a database schema with write access
*
· trainOutFile = "PheVal_10X_DM_train",
*
· exclCohort = 1770120, #the xSens cohort
*
· prevCohort = 1770119, #the cohort for prevalence determination
*
· estPPV = 0.75,
*
· modelAnalysisId = "20181206V1",
*
· excludedConcepts = c(201820),
*
· cdmShortName = "myCDM",
*
· mainPopnCohort = 0, #use the entire subject population
*
· lowerAgeLimit = 18,
*
· upperAgeLimit = 90,
*
· startDate = "20100101",
*
· endDate = "20171231")
*
xSpecCohort 1769699 cdmDatabaseSchema my_cdm_data cohortDatabaseSchema my_results cohortDatabaseTable cohort outDatabaseSchema scratch.dbo trainOutFile PheVal_10X_DM_train exclCohort 1770120 prevCohort 1770119 estPPV 0.75 modelAnalysisId 20181206V1 excludedConcepts 201820 addDescendantsToExclude FALSE cdmShortName myCDM mainPopnCohort 0 lowerAgeLimit 18 upperAgeLimit 90 gender 8507 gender 8532 startDate 20100101 endDate 20171231 Connecting using PostgreSQL driver Error in rJava::.jcall(jdbcDriver, "Ljava/sql/Connection;", "connect", : org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/OHDSI/PheValuator/issues/7?email_source=notifications&email_token=AESDXZSU2MEMWWGNKBRKAWTQI7CM5A5CNFSM4IVJ3AAKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HKP4A3A, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AESDXZS7BI6JY3IPOFJEAKDQI7CM5ANCNFSM4IVJ3AAA.
when I try to use the EvaluatingPhenotypeAlgorithms example I get this error. I can't tell if this is on my end or your end.