SonarQLSQL

Reference = https://docs.sonarqube.org/display/PLUG/SonarPLSQL

사전조건

• SonarQube Scanner 설치/구성 및 경로 설정
  • https://docs.sonarqube.org/display/SCAN/Analyzing+with+SonarQube+Scanner

분석

1. SonarQube Scanner 환경 구성

   sonar-project.properties

   sonar.projectKey=myFirstSonarQubeProject
   sonar.projectName=My First SonarQube Project
   sonar.projectVersion=1.0
   sonar.sources=.

2. 추가 Data Directory 설정

   sonar-project.properties

   sonar.plsql.jdbc.url=dbc:oracle:thin:@my-oracle-server:1521/my-db
   sonar.plsql.jdbc.user=username
   sonar.plsql.jdbc.password=password
   sonar.plsql.jdbc.driver.path=lib/ojdbc8-12.2.0.1.0.jar
   sonar.plsql.jdbc.driver.class=oracle.jdbc.OracleDriver
   sonar.plsql.defaultSchema=MY_SCHEMA

   Based on such a configuration, SonarPLSQL queries data dictionary views such as SYS.ALL_TAB_COLUMNS.

3. SonarQube Scanner 실행

   sonar-scanner

4. 끝