Skip to content

Feature/bump dependencies #171

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
PhilippSalvisberg merged 6 commits into from
Jun 16, 2026
Merged

Feature/bump dependencies #171

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
6 commits
Select commit Hold shift + click to select a range
8e57195
bump dependencies to JDK 17, SQLDev 23.3.1 and more
PhilippSalvisberg Jun 16, 2026
f0e44a0
update test JDBC properties for local OracleDB 26ai
PhilippSalvisberg Jun 16, 2026
97775af
need to pass types array with updated database dependencies
PhilippSalvisberg Jun 16, 2026
313cd5a
increase tolerance to reduce test flakiness
PhilippSalvisberg Jun 16, 2026
c390f7d
update how to build section of README.md
PhilippSalvisberg Jun 16, 2026
6667a18
consistent translation of failures, fixes #161
PhilippSalvisberg Jun 16, 2026
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
35 changes: 18 additions & 17 deletions README.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,11 +2,11 @@

## Introduction

utPLSQL for SQL Developer extends Oracle's SQL Developer to
utPLSQL for SQL Developer extends Oracle's SQL Developer to

* run utPLSQL unit tests
* debug utPLSQL unit tests
* run utPLSQL code coverage reports
* run utPLSQL code coverage reports
* generate utPLSQL unit tests (skeletons)
* provide utPLSQL annotations and expectations as snippets

Expand All @@ -18,7 +18,7 @@ In the Connections window, select a connection or one or more packages or packag

### Debug utPLSQL test

Select the tests to debug, the same way you would if you were just running them, but select `Debug utPLSQL test...` in the context menu.
Select the tests to debug, the same way you would if you were just running them, but select `Debug utPLSQL test...` in the context menu.

And then the PL/SQL Debugger is called for the generated, anonymous PL/SQL block.

Expand All @@ -32,11 +32,11 @@ The initialization timeout for the realtime reporter is increased to 1 hour. The

In the Connections window, select a connection or one or more packages for a code coverage report.

In the dialog you can set some parameters. If you run code coverage for a few chosen packages or from the PL/SQL editor the objects to be included are determined according the object dependencies in the Oracle data dictionary.
In the dialog you can set some parameters. If you run code coverage for a few chosen packages or from the PL/SQL editor the objects to be included are determined according the object dependencies in the Oracle data dictionary.

![Code coverage dialog](images/code_coverage_dialog.png)

Press `Run` to produce the code coverage process in the background. You may minimize or close the dialog. To abort the process, press `Cancel`.
Press `Run` to produce the code coverage process in the background. You may minimize or close the dialog. To abort the process, press `Cancel`.

The HTML report is shown in your default browser.

Expand Down Expand Up @@ -89,7 +89,7 @@ utPLSQL for SQL Developer implements the [OddgenGenerator2 interface](https://ww
* run existing utPLSQL test suitepaths and test suites
* bulk generate new utPLSQL unit tests into dedicated files

The use of [oddgen for SQL Developer](https://www.oddgen.org/) is optional.
The use of [oddgen for SQL Developer](https://www.oddgen.org/) is optional.

#### Run utPLSQL test

Expand Down Expand Up @@ -128,6 +128,7 @@ Binary releases are published [here](https://github.com/utPLSQL/utPLSQL-SQLDevel
4. Use the ```Search Update Center``` option and select the ```salvis.com``` update center to install the lastest version of ```utPLSQL for SQL Developer```.

## Issues

Please file your bug reports, enhancement requests, questions and other support requests within [Github's issue tracker](https://help.github.com/articles/about-issues/).

* [Questions](https://github.com/utPLSQL/utPLSQL-SQLDeveloper/issues?q=is%3Aissue+label%3Aquestion)
Expand All @@ -142,23 +143,23 @@ Please file your bug reports, enhancement requests, questions and other support
3. [Create a branch](https://help.github.com/articles/creating-and-deleting-branches-within-your-repository/), commit and publish your changes and enhancements
4. [Create a pull request](https://help.github.com/articles/creating-a-pull-request/)

## How to Build
## How to Build

1. [Download](http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html) and install SQL Developer 21.4.3
2. [Download](https://maven.apache.org/download.cgi) and install Apache Maven 3.8.6
3. [Download](https://git-scm.com/downloads) and install a git command line client
4. Clone the utPLSQL-SQLDeveloper repository
5. Open a terminal window in the utPLSQL-SQLDeveloper root folder and type
1. [Download](http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html) and install SQL Developer 24.3.1
2. Download and install a JDK 17 or newer
3. [Download](https://maven.apache.org/download.cgi) and install Apache Maven 3.9.16
4. [Download](https://git-scm.com/downloads) and install a git command line client
5. Clone the utPLSQL-SQLDeveloper repository
6. Open a terminal window in the utPLSQL-SQLDeveloper root folder and type

cd sqldev
cd sqldev

6. Run maven build by the following command
7. Run maven build by the following command

mvn -Dsqldev.basedir=/Applications/SQLDeveloper21.4.3.app/Contents/Resources/sqldeveloper -DskipTests=true clean package
mvn -Dsqldev.basedir=/Applications/SQLDeveloper24.3.1.app/Contents/Resources/sqldeveloper -DskipTests=true clean package

Amend the parameter sqldev.basedir to match the path of your SQL Developer installation. This folder is used to reference Oracle jar files which are not available in public Maven repositories
7. The resulting file ```utplsql_for_SQLDev_x.x.x-SNAPSHOT.zip``` in the ```target``` directory can be installed within SQL Developer
Amend the parameter sqldev.basedir to match the path of your SQL Developer installation. This folder is used to reference Oracle jar files which are not available in public Maven repositories
8. The resulting file ```utplsql_for_SQLDev_x.x.x-SNAPSHOT.zip``` in the ```target``` directory can be installed within SQL Developer

## License

Expand Down
Loading