Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Warning
titleDeprecated

This plugins is deprecated.

 

 

Wiki Markup
{iframe:src=http://update.sonarsource.org/plugins/plsqltoad.html|width=700|height=250|frameborder=0}
Your browser does not support iframes.
{iframe}

Description / Features

The Toad CodeXpert This plugin is an extension of the SonarSource PL/SQL plugin (commercial) and can only be used with it.

...

  • It scans source code from files on disk. This mode is generally used in enterprise environments with configuration management strategies (use tools like Subversion or Clearcase).
  • It connects to the database and analyzes all the objects stored in that database. This mode is NOT supported by SonarSonarQube.

Installation

  1. Install the Toad CodeXpert plugin through the Update Center or download it into the SONAR_HOME/extensions/plugins directory
  2. Restart the Sonar server

Include Page
Include - Plugin Installation
Include - Plugin Installation

Usage

Prerequisites

  • Dell (previously Quest Software) Toad 9.5 or higher with the CodeXpert module (included into in Toad for Oracle Xpert, Toad for Oracle Professional, and Toad Development Suite for Oracle).
  • A connection to an Oracle database if you use Toad 9.x or 10.x. This It is a limitation of Toad that it needs to be connected to the database even if it the connection is not used by the CodeXpert module. So you can set a “fake” connection to an empty database.

Configuration

The following properties have to be set (at project level through the 'sonar-project.properties' file or at instance level through the 'sonar-runner.properties' file or web interface):

Code Block
languagehtml/xml
sonar.plsql.toad.exePath=C:/Program Files/Quest Software/Toad for Oracle 10.5/Toad.exe
sonar.plsql.toad.login=USER@XE
sonar.plsql.toad.password=user_password

Run an Analysis

Activate some rules from Toad CodeXpert in your project quality profile and run an analysis of your project.

Sonar SonarQube automatically configures and launches Toad CodeXpert to check your code against the Toad CodeXpert's rules.

Troubleshooting

...

  • If the analysis is triggered by a process that runs as a

...

  • Windows Service (from a Continuous Integration server such as Jenkins), the analysis will fail. This issue is

...

  • supposed to be fixed in Toad 12 but was not tested.
  • Toad CodeXpert 9.x is unable to start from the command-line when the month of the current date contains an accent ("Décembre" in French for example). The workaround for this is to change the regional settings on the machine.

Change Log

JIRA Issues
anonymoustrue
titleRelease 1.0
renderModestatic
width900
columnstype;key;summary;priority
urlhttp://jira.codehaus.org/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?fixfor=18896&pid=11911&sorter/field=priority&sorter/order=DESC&tempMax=1000