5 Replies Latest reply on Mar 16, 2020 5:03 PM by Jose Aróstegui

    JasperReportsIntegration with 18 XE pluggable database

    Jose Aróstegui

      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

        • 1. Re: JasperReportsIntegration with 18 XE pluggable database
          AndyH

          I think that the correct URL for a thin jdbc connection to a database service name is:

           

          jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME

          • 2. Re: JasperReportsIntegration with 18 XE pluggable database
            Jose Aróstegui

            Thanks for your help Andy.

            Changed but still not working:

             

            #====================================================================
            # JDBC datasource configuration
            # http://www.orafaq.com/wiki/JDBC#Thin_driver
            # type=jndi|jdbc
            #====================================================================
            [datasource:default]
            type=jdbc
            name=default
            url=jdbc:oracle:thin:@//localhost:1521/xepdb1
            username=myuser
            password=mypass
            

             

            [oracle@apextest ~]$ lsnrctl status
            LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 16-MAR-2020 16:37:46
            Copyright (c) 1991, 2018, Oracle.  All rights reserved.
            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apextest)(PORT=1521)))
            STATUS of the LISTENER
            ------------------------
            Alias                     LISTENER
            Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
            Start Date                06-NOV-2019 21:21:04
            Uptime                    130 days 19 hr. 16 min. 42 sec
            Trace Level               off
            Security                  ON: Local OS Authentication
            SNMP                      OFF
            Default Service           XE
            Listener Parameter File   /opt/oracle/product/18c/dbhomeXE/network/admin/listener.ora
            Listener Log File         /opt/oracle/diag/tnslsnr/apextest/listener/alert/log.xml
            Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apextest)(PORT=1521)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
            Services Summary...
            Service "96b46eb66d27da05e053e3cde3d46505" has 1 instance(s).
              Instance "XE", status READY, has 1 handler(s) for this service...
            Service "XE" has 1 instance(s).
              Instance "XE", status READY, has 1 handler(s) for this service...
            Service "XEXDB" has 1 instance(s).
              Instance "XE", status READY, has 1 handler(s) for this service...
            Service "xepdb1" has 1 instance(s).
              Instance "XE", status READY, has 1 handler(s) for this service...
            The command completed successfully
            
            • 3. Re: JasperReportsIntegration with 18 XE pluggable database
              Jose Aróstegui

              Hi all,

               

              Activating log4j logs I've noticed this error: ORA-28040: No matching authentication protocol exception

               

              Substituing in JasperReportsIntegration.war\WEB-INF\lib

              ojdbc6.jar

              with

              ojdbc8.jar

               

              Now it works fine!

              • 4. Re: JasperReportsIntegration with 18 XE pluggable database
                Oleh Tyshchenko

                Jose Aróstegui wrote:

                 

                But I'm getting this error:

                 

                Can you please repost this error as a text and not as a cropped image? There may be some valuable information.

                • 5. Re: JasperReportsIntegration with 18 XE pluggable database
                  Jose Aróstegui

                  Thanks Oleh, my issue is already solved.

                  Regards,

                  Jose.