Invalid JDBC URL when the URL contains '@' sign

[Abshan]

Problem

Hi All,

@source(type='cdc', 
    url='jdbc:oracle:thin:@localhost:1521/SAMPLEDB',  
    username='admin', 
    password='admin',     
    table.name='inventory.products', 
    operation='insert', 
    database.server.name='PRODINS', 
connector.properties="database.out.server.name=sample,snapshot.mode=initial_schema_only",
    @map(type = 'keyvalue', fail.on.missing.attribute='false'))
define stream ProductInsertInputStream (
    ID int, NAME string, DESCRIPTION string, QUANTITY int);

When we define the Oracle JDBC url format as shown in the sample above, the below mentioned error message get prompted in the SI-Tooling Editor window.

Error!Error while parsing Errors in Siddhi app.The cdc source couldn't get started because of invalid configurations. Found configurations: {username='admin', password=admin, url='jdbc:oracle:thin:@localhost:1521/sample_db', tablename='ABC', connetorProperties='database.out.server.name=sample,snapshot.mode=initial_schema_only'}

The above error is being thrown from the validator service, The validation failure appears to be caused by the format of the URL specified for the CDC source. Upon investigation, we found that the '@' character in the JDBC URL (jdbc:oracle:thin:@localhost:1521/SAMPLEDB) is the source of the validation failure. While the provided JDBC URL is valid [1], SI shows that the provided URL is invalid.

Hence, this needs to be fixed for both SI and SI-Tooling.

[1] https://docs.oracle.com/en/database/oracle/oracle-database/21/jajdb/index.html

Thanks,
Abshan

Solution

Change the validation regex to support '@' character in Oracle JDBC URL.

Affected Component

SI

Version

4.1