Jenkins

Useful Plugins:

• Audit Trail

• EnvInject

• Find Bugs

• Parameterized Trigger

• Task Scanner

• Active Directory

• build-name-setter

• Emma

• conditional-buildstep

• Hudson Locks and Latches

• Log Parser

• Next Build Number

• Node and Label parameter

• Parameterized Remote Trigger

• PMD

• Static Code Analysis

• Static Analysis Collector

• TextFinder

• Warnings

ORACLE TNS

PROBLEM:

Jenkins builds and developers using Oracle DB's need a tnsnames.ora file that can be easily updated, accessed and shared.

SOLUTION:

Share a copy of the tnsnames.ora using SVN control.

USAGE:

1. Create a SVN checkout of the SVN project.

2. Set the TNS_ADMIN environment variable to redirect the ORACLE client to this file:

set TNS_ADMIN=[checkout directory]

3. Add/commit newer database TNS entries to share the details quickly and easily.

FOR JENKINS:

1. Created a Jenkins job that monitors this SVN location and checks it out if a change is committed.

2. Add a global environment variable TNS_ADMIN that references the Jenkins Job workspace