<dependency> <groupId>com.oracle.database.jdbc</groupId> <artifactId>ojdbc8</artifactId> <version>21.3.0.0</version> </dependency>

<configuration> <skipUtplsqlTests>true</skipUtplsqlTests> </configuration>

<configuration> <skipUtplsqlTests>true</skipUtplsqlTests> </configuration>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.my_org</groupId> <artifactId>my-artifact-name</artifactId> <version>1.0.0</version> <properties> <!-- URL of the connection to the database. --> <!-- Can also be passed as execution parameters. --> <!-- -DdbUrl="jdbc:oracle:thin:@127.0.0.1:1521:xe" --> <dbUrl>url_of_connection</dbUrl> <!-- Database connection user. --> <!-- -DdbUser="user" --> <dbUser>user</dbUser> <!-- Database connection password. --> <!-- -DdbPassword="password" --> <dbPass>password</dbPass> </properties> <build> <plugins> <plugin> <groupId>org.utplsql</groupId> <artifactId>utplsql-maven-plugin</artifactId> <version>3.1.11</version> <executions> <execution> <goals> <goal>test</goal> </goals> <configuration> <!-- REQUIRED PARAMETERS --> <!-- A list of tests suite paths. --> <!-- The path(s) can be in one of the following formats: --> <!-- schema[.package[.procedure]] --> <!-- schema:suite[.suite[.suite][...]][.procedure] --> <!-- Both formats can be mixed in the list. --> <!-- If only schema is provided, then all suites --> <!-- owned by that schema are executed. --> <paths> <path>schema_name</path> </paths> <sources> <source> <!-- Path to project source files. --> <directory>src/test/resources/scripts/sources</directory> <!-- File patterns to include. --> <includes> <include>**/*pkg</include> <include>**/*pkb</include> </includes> </source> </sources> <tests> <test> <!-- Path to project test files. --> <directory>src/test/resources/scripts/test</directory> <!-- File patterns to include. --> <includes> <include>**/*pkg</include> <include>**/*pkb</include> </includes> </test> </tests> <!-- OPTIONAL PARAMETERS --> <!-- Continue in case of failure. --> <!-- Defaults to: ${maven.test.failure.ignore} --> <ignoreFailure>false</ignoreFailure> <!-- Skip the utPLSQL version compatibility check. --> <!-- Defaults to: false --> <skipCompatibilityCheck>false</skipCompatibilityCheck> <!-- Skip the tests --> <!-- Defaults to: false --> <skipUtplsqlTests>false</skipUtplsqlTests> <!-- Enables DBMS_OUTPUT --> <!-- Defaults to: false --> <dbmsOutput>false</dbmsOutput> <!-- Sets a timeout around Reporter creation and retries when not ready after a while. --> <!-- 0 = no timeout. --> <oraStuckTimeout>0</oraStuckTimeout> <!-- A list of tags to run. --> <tags> <tag>test_tag</tag> </tags> <!-- Enables random order of test executions. --> <randomTestOrder>true</randomTestOrder> <!-- Sets the seed to use for random test execution order. If set, it sets -random to true. --> <randomTestOrderSeed>5</randomTestOrderSeed> <!-- Comma-separated object list to include in the coverage report. --> <!-- Format: [schema.]package[,[schema.]package ...]. --> <!-- See coverage reporting options in framework documentation. --> <includeObject>app.test1,app.test2</includeObject> <!-- Comma-separated object list to exclude from the coverage report. --> <!-- Format: [schema.]package[,[schema.]package ...]. --> <!-- See coverage reporting options in framework documentation. --> <excludeObject>app.test1,app.test2</excludeObject> <!-- Regular expression to match against schema name to include in coverage --> <includeSchemaExpr>app.test1,app.test2</includeSchemaExpr> <!-- Regular expression to match against schema name to exclude in coverage --> <excludeSchemaExpr>app.test1,app.test2</excludeSchemaExpr> <!-- Regular expression to match against schema name to include in coverage --> <includeObjectExpr>app.test1,app.test2</includeObjectExpr> <!-- Regular expression to match against object name to exclude in coverage --> <excludeObjectExpr>app.test1,app.test2</excludeObjectExpr> <!-- List of reporters. --> <!-- You can pass the name of the reporter and/or the output file --> <!-- of the reporter and/or if the report is logged to the console. --> <!-- If you don't pass any reporter, UT_DOCUMENTATION_REPORTER will be used. --> <!-- This is a current list of the names of the reporters, --> <!-- see UtPLSQL documentation in order to check the final list: --> <!-- UT_DOCUMENTATION_REPORTER --> <!-- UT_COVERAGE_HTML_REPORTER --> <!-- UT_TEAMCITY_REPORTER --> <!-- UT_XUNIT_REPORTER --> <!-- UT_COVERALLS_REPORTER --> <!-- UT_COVERAGE_SONAR_REPORTER --> <!-- UT_SONAR_TEST_REPORTER --> <reporters> <reporter> <name>UT_COVERAGE_SONAR_REPORTER</name> <!-- The file output path. --> <fileOutput>utplsql/coverage-sonar-reporter.xml</fileOutput> <!-- Indicates if should write to console. --> <consoleOutput>true</consoleOutput> </reporter> <reporter> <name>UT_SONAR_TEST_REPORTER</name> <fileOutput>utplsql/sonar-test-reporter.xml</fileOutput> <consoleOutput>false</consoleOutput> </reporter> <reporter> <name>UT_TEAMCITY_REPORTER</name> </reporter> </reporters> <!-- Custom source code mapping options. --> <!-- See coverage reporting options in framework documentation. --> <sourcesOwner>code_owner</sourcesOwner> <sourcesRegexExpression>.*/\w+/(\w+)/(\w+)\.\w{3}</sourcesRegexExpression> <sourcesOwnerSubexpression>app</sourcesOwnerSubexpression> <sourcesNameSubexpression>2</sourcesNameSubexpression> <sourcesTypeSubexpression>1</sourcesTypeSubexpression> <sourcesCustomTypeMapping> <customTypeMapping> <type>package body</type> <customMapping>package_bodies</customMapping> </customTypeMapping> </sourcesCustomTypeMapping> <!-- Custom test code mapping options. --> <!-- See coverage reporting options in framework documentation. --> <testsOwner>tests_owner</testsOwner> <testsRegexExpression>.*/\w+/(\w+)/(\w+)\.\w{3}</testsRegexExpression> <testsOwnerSubexpression>test</testsOwnerSubexpression> <testsNameSubexpression>2</testsNameSubexpression> <testsTypeSubexpression>1</testsTypeSubexpression> <testsCustomTypeMapping> <customTypeMapping> <type>package body</type> <customMapping>package_bodies</customMapping> </customTypeMapping> </testsCustomTypeMapping> </configuration> </execution> </executions> </plugin> </plugins> </build> </project>