- Using SonarQube EE 8.6 Server.
- Builds are performed on Jenkins 2.263.1.
- Our PL/SQL project currently uses SonarQube Scanner 188.8.131.523 (ie, SonarScanner CLI).
We are receiving
The Data Dictionary is not configured analysis warnings within SonarQube itself and, before making changes, wish to understand a couple of things that are not made clear in the PL/SQL documentation
Where is the database connection made from? I am sure that would be within our Jenkins (otherwise I cannot imagine that things would work to well if using SonarCloudOne). One developer’s initial response was “There is no realistic or reliable way to allow SonarQube to ‘connect’ to a database”, so obviously it is possible to interpret the documentation in more than one way.
What are the criteria for
sonar.plsql.jdbc.url? For Oracle, can it be a local Oracle XE rather than a full-blown Oracle server? Exact same version of the database that server that the PL/SQL will eventually be used on? Must the server be running a valid test database? I am reckoning that the answer to this very last one is “no” because the documented parameters make no mention of database name.
I ask all this to emphasise that the documentation should not assume that the reader has specific skills or knowledge.
This post is a question linked to the reply I made today to Data Dictionary is not configured warning