JarCasting
JarCasting JarCasting

Forms PL/SQL Extractor

Command-line that extracts PL/SQL code from Oracle Forms project

License

License
Categories

Categories

ORM Data
GroupId

GroupId

org.codehaus.sonar-plugins
ArtifactId

ArtifactId

sonar-forms-plsql-extractor
Last Version

Last Version

1.1
Release Date

Release Date
Type

Type

jar
Description

Description

Forms PL/SQL Extractor
Command-line that extracts PL/SQL code from Oracle Forms project
Project Organization

Project Organization

SonarSource
Source Code Management

Source Code Management

https://github.com/SonarCommunity/sonar-forms-plsql-extractor

Download sonar-forms-plsql-extractor

Filename Size
sonar-forms-plsql-extractor-1.1.pom
sonar-forms-plsql-extractor-1.1.jar 21 KB
sonar-forms-plsql-extractor-1.1-sources.jar 16 KB
sonar-forms-plsql-extractor-1.1-javadoc.jar 70 KB
sonar-forms-plsql-extractor-1.1-jar-with-dependencies.jar 509 KB
Browse

How to add to project

<!-- https://jarcasting.com/artifacts/org.codehaus.sonar-plugins/sonar-forms-plsql-extractor/ -->
<dependency>
    <groupId>org.codehaus.sonar-plugins</groupId>
    <artifactId>sonar-forms-plsql-extractor</artifactId>
    <version>1.1</version>
</dependency>
// https://jarcasting.com/artifacts/org.codehaus.sonar-plugins/sonar-forms-plsql-extractor/
implementation 'org.codehaus.sonar-plugins:sonar-forms-plsql-extractor:1.1'
// https://jarcasting.com/artifacts/org.codehaus.sonar-plugins/sonar-forms-plsql-extractor/
implementation ("org.codehaus.sonar-plugins:sonar-forms-plsql-extractor:1.1")
'org.codehaus.sonar-plugins:sonar-forms-plsql-extractor:jar:1.1'
<dependency org="org.codehaus.sonar-plugins" name="sonar-forms-plsql-extractor" rev="1.1">
  <artifact name="sonar-forms-plsql-extractor" type="jar" />
</dependency>
@Grapes(
@Grab(group='org.codehaus.sonar-plugins', module='sonar-forms-plsql-extractor', version='1.1')
)
libraryDependencies += "org.codehaus.sonar-plugins" % "sonar-forms-plsql-extractor" % "1.1"
[org.codehaus.sonar-plugins/sonar-forms-plsql-extractor "1.1"]

Dependencies

compile (3)

Group / Artifact Type Version
org.slf4j : slf4j-simple jar 1.7.6
commons-io : commons-io jar 2.4
commons-lang : commons-lang jar 2.6

provided (2)

Group / Artifact Type Version
com.oracle » frmjdapi jar 10.0
com.google.code.findbugs : jsr305 jar 1.3.9

test (3)

Group / Artifact Type Version
junit : junit jar 4.11
org.easytesting : fest-assert jar 1.4
org.mockito : mockito-all jar 1.9.5

Project Modules

There are no modules declared in this project.

Oracle Forms PL/SQL Extractor

Features

This command-line gives the ability to extract PL/SQL source code from Oracle Forms. You can then feed SonarQube with the extracted PL/SQL source code.

Download

Latest version is 1.1, released on 14 May 2014

http://downloads.sonarsource.com/plugins/org/codehaus/sonar-plugins/sonar-forms-plsql-extractor/1.1/sonar-forms-plsql-extractor-1.1-jar-with-dependencies.jar

Prerequisites

This extractor uses the Oracle JDAPI library that is included in the Oracle Developer Suite. Therefore a full installation of the Oracle Developer Suite is required. Once installed, check that the environment is correctly set:

The "PATH" environment variable must contain the Oracle Developer Suite paths, for example: PATH=C:/OracleDevSuite/jlib;C:/OracleDevSuite/bin;

Use Java 1.6 or higher to run Sonar Forms PLSQL Extractor.

How to Execute

Download the JAR file then execute:

set FORMS_PATH=C:\forms_project
java -DinputDir=C:\forms_project -DoutputDir=C:\extracted_plsql -cp C:\path\to\sonar-forms-plsql-extractor-1.1-jar-with-dependencies.jar;C:\path\to\oracle\forms\java\frmjdapi.jar org.sonar.oracleforms.plsql.PlSqlExtractor

Notes:

  • The optional property formsExtensions is a comma-separated list of extensions of Oracle Forms files to extract. Its default value is fmb,mmb,olb,pll.
  • The output directory, as set by the outputDir property, must exist and is not cleaned up. Generated files override existing ones.

FAQ

Q : I'm getting "Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class oracle.forms.jdapi.Jdapi" whilst my env variables and paths are correctly configured, why ?

A : Oracle Developer Suite used to perform the extraction is available only for x32 OS. As a consequence, the Oracle Forms PL/SQL Extractor will work only on x32 OS.

How to Build Sources Build Status

The Java library frmjdapi is provided by the Oracle Developer Suite (see forms/java/frmjdapi.jar) and must be installed into the Maven repository :

mvn install:install-file  -Dfile=/path/to/frmjdapi.jar -DgroupId=com.oracle -DartifactId=frmjdapi -Dversion=10.0 -Dpackaging=jar

Then simply execute the following command. It does not require Oracle Developer Suite on the box:

mvn clean install

Medium tests are executed when enabling the profile "runMediumTests". Note that it requires the Oracle Dev Suite on the box:

mvn clean install -PrunMediumTests

License

GNU LGPL v3

Versions

Version
1.1
1.0