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

Define Data Source in case of database container #104

Closed daxlai closed 2 years ago

daxlai commented 2 years ago

i installed oracle 21c XE and integrate JasperReportsIntegration on tomcat. my user in database in container (xepdb1). when i define xepdb1 than data source not work. when i user in root than it worked. my listener status is LSNRCTL for 64-bit Windows: Version 21.0.0.0.0 - Production on 06-APR-2022 21:19:51

Copyright (c) 1991, 2021, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=daxmlai)(PORT=1521))) STATUS of the LISTENER

Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 21.0.0.0.0 - Production Start Date 05-APR-2022 13:08:17 Uptime 1 days 8 hr. 11 min. 34 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File D:\OracleXE\homes\OraDB21Home1\network\admin\listener.ora Listener Log File D:\OracleXE\diag\tnslsnr\daxmlai\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=daxmlai)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1521ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my_wallet_directory=D:\ORACLEXE\admin\XE\xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "05676f1385e443439aa107bdadc6ac77" has 1 instance(s). Instance "xe", status READY, has 2 handler(s) for this service... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "XE" has 1 instance(s). Instance "xe", status READY, has 2 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 2 handler(s) for this service... The command completed successfully

and i define data source is [datasource:default] type=jdbc name=default url=jdbc:oracle:thin:@daxmlai:1521:xepdb1 username=ligitime password=ligitime

is not working but when i define system/oracle on root instance XE than it work [datasource:default] type=jdbc name=default url=jdbc:oracle:thin:@daxmlai:1521:xe username=system password=oracle

it is working. please guide me how i connect to db container

daxlai commented 2 years ago

Problem solved please close it

daxlai commented 2 years ago

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

when using container /service then after port using [/] and service name and case of instance use [:] and instance name