search

utPLSQL / utPLSQL-cli

Command line client for invoking utPLSQL
Apache License 2.0
40 stars 15 forks source link

Using Oracle Editions Based - EBR #224

Open milheiros opened 6 months ago

milheiros commented 6 months ago

Hi eveyone,

It is possible to connect to DB when calling utplsql-cli run command using a specific Edition name/number? Something like this:

utplsql run username/password@service EDITION=ora$base -source_path=Packages -test_path=UnitTestPackages --failure-exit-code=0 -f=ut_coverage_cobertura_reporter -o=cobertura_reporter.xml -f=ut_coverage_sonar_reporter -o=coverage.xml -f=ut_sonar_test_reporter -o=test_results.xml

felipebz commented 2 months ago

As far as I know, there's no explicit support for EBR in utPLSQL-cli, but the Oracle JDBC Driver includes a property that can be set to specify the edition.

In Windows cmd:

set JAVA_OPTS=-Doracle.jdbc.editionName=MY_EDITION
utplsql run (...)

In Linux:

export JAVA_OPTS=-Doracle.jdbc.editionName=MY_EDITION
utplsql run (...)
jgebal commented 2 months ago

Yes, @felipebz is correct, utPLSQL-cli does not provide any setting for editions. The tup with JAVA_OPTS is a really neat workaround for the missing feature.