search

daust / JasperReportsIntegration

JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX).
BSD 3-Clause "New" or "Revised" License
55 stars 23 forks source link

Unable to connect to Pluggable Database #83

Closed daxlai closed 2 years ago

daxlai commented 2 years ago

I configured JasperReportIntegration on tomcat 10. When i connect it go pluggable database it not connect but when i connect it root container than it connected i checked password and every thing many times but not it not connected. please guide me. when i connected with my pluggable database my conf/application.property have [datasource:default] type=jdbc name=default url=jdbc:oracle:thin:@192.168.1.84:1521:xepdb1 username=hll password=hll

WHEN I CONNECTED ROOT CONTAINER (WHICH IS WORKING) [datasource:default] type=jdbc name=default url=jdbc:oracle:thin:@192.168.1.84:1521:xe username=system password=oracle

mikaelkael13 commented 2 years ago

Change your url . For pdb, it is not a SID so you have to use '/' instead of ':' for connecting to a service_name

[datasource:default] type=jdbc name=default url=jdbc:oracle:thin:@192.168.1.84:1521/xepdb1 username=hll password=hll

daust commented 2 years ago

Thank you, @mikaelkael13 .

Yes, this is correct. I simply use the standard jdbc url syntax for connecting the database. Does it work now?