Oracle Connection Issue in Helical Insight 6.0 docker version (Service Name & JDBC Driver)

Technical queries
, , , , ,
#1

Hello, We are using open source BI Helical Insight version 6.0.0.535 SNAPSHOT. While trying to connect to an Oracle database using the service name, the connection is failing.

Thanks,
Netta.

#2

Hello Netta,

The issue was caused due to an incorrect JDBC URL format and driver compatibility.

For Oracle service name connection, the correct JDBC URL format is:

jdbc:oracle:thin:@host:port/service_name

  1. We fixed the JDBC URL format in the databaseDrivers.properties file.

#Oracle

oracle.jdbc.OracleDriver=jdbc:oracle:thin:@{{hostName}}:{{port}}:{{database}},1521

Replaced with

#Oracle

oracle.jdbc.OracleDriver=jdbc:oracle:thin:@{{hostName}}:{{port}}:{{database}}/1521

  1. We used the Ojdbc10.jar driver for compatibility with the latest Java version.

Driver path : /opt/Helical694_61GA/hi/hi-repository/System/Drivers

After making these changes, we restarted the Helical Insight application, and it worked fine.

Thank You,
Helical Insight.