OPENSearch JDBC drivers screw up connexion exceptions on other JDBC drivers :

Plugins SQL
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
opensearch-sql-jdbc-shadow-1.4.0.1.jar
Linux centos

Describe the issue:
When I add opensearch JDBC drivers to my OS classpath, when i’m having connexion issue with other JDBC driver ( like oracle, account locked, such kind of things), I received next exception:
JDBC SQL Exception : org.opensearch.jdbc.config.ConnectionPropertyException: java.net.URISyntaxException: URL does not begin with the mandatory prefix jdbc:opensearch://.: jdbc:oracle:thin:@::

if i remove from classpath env the open serach jdbc drivers, i gather the proper exception :
Error message:
Something went wrong while connecting to JDBC SQL Exception : java.sql.SQLException: ORA-28000: The account is locked.

I tested with other JDBC drivers and it’s the same behaviour when we are having a connexion issue. we received the opensearch exception invalid URI.

Anyone else observed such behaviour ?

2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.