Configuring database access of JasperReportsIntegration

[Eyesmagicx]

Hi. I am new to JasperReportsIntegration tool. I followed the quick start guide https://github.com/daust/JasperReportsIntegration/blob/main/src/doc/github/installation-quickstart.md but I faced

a problem configuring the database access.

I have Oracle database 18c xe. And I have a pluggable db named xepdb1 which has my schemas.

When trying to configure the "default" variable for database access in "application.properties" file, it did not work and I got error says that it does not know of an SID with the name xepdb1.

So, now I know that it uses SID not service name. But SID is assigned to the container database CDB not the pluggable database.

Here is the "default" variable configuration part in the file:

[datasource:default]
type=jdbc
url=jdbc:oracle:thin:@localhost:1521:XE
username=hr
password=hr

How can I connect with service name instead of SID? Or how should I handle that situation?

[Eyesmagicx]

Found it. Replace ":XE" with "/XEPDB1". SO,

 url=jdbc:oracle:thin:@localhost:1521:XE

will become 

url=jdbc:oracle:thin:@localhost:1521/XEPDB1

[Eyesmagicx]

Where to select that?