Hi experts,
I'm trying to configure JasperReportsIntegration with 18 XE pluggable database, in order to create Jasper reports from Apex 19.2
I can connect correctly to my pluggable database like this:
> sqlplus myuser/mypass@//localhost:1521/xepdb1
SQL*Plus: Release 18.0.0.0.0 - Production on Mon Mar 16 13:46:52 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Last Successful login time: Mon Mar 16 2020 13:33:09 +01:00
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL>
This is my configuration file (/conf/application.properties), where I'm using the "/" to indicate the pluggable database service name:
#====================================================================
# JDBC datasource configuration
# http://www.orafaq.com/wiki/JDBC#Thin_driver
# type=jndi|jdbc
#====================================================================
[datasource:default]
type=jdbc
name=default
#url=jdbc:oracle:thin:@127.0.0.1:1521:XE
url=jdbc:oracle:thin:@127.0.0.1:1521/xepdb1
username=myuser
password=mypass
But I'm getting this error:
Is anybody configured JasperReportsIntegration with a pluggable database?
Thanks a lot,
Jose.
Message was edited by: Jose Aróstegui: Meant to say pluggable instead of container