OHDSI Home | Forums | Wiki | Github

Help with White Rabbit and Rabbit in a Hat, ETL process

HI All,
Does anyone have experience with generating a scan report using White Rabbit and Rabbit in a Hat, and the ETL process? We are having problems with this, as we are doing this for the first time for a new database, and would appreciate some help. For instance, there is connection error at the first step of the process (below).
Thanks
Sara

Hello Sara,

This points to a problem with the Oracle JDBC driver. White Rabbit is a Java program that relies on an Oracle JDBC driver to connect to the database, so you have to make sure that you have a Oracle JDBC driver / client on the classpath that is compatible with the Java version and Oracle version you are using. You seem to be using a 64 bit Java but you have a 32-bit client. See https://docs.oracle.com/database/121/JJDBC/overvw.htm#JJDBC28037.

Greetings,

Kees

Hi Kees

Thanks for the lead. I will try that out. Thanks for your help!

best
Sara

Infact this issue maybe due to two reasons

  1. proper format is host/SID — format host:port:SID is written in documentation but in case of oracle, it doesn’t work
  2. Database Name is infact schema name which contains tables
t