Cruise Control & ANT to build my Oracle scripts in an oracle database

Utsav Datta <[email protected]> Sun, 28 Aug 2011 18:17:55 -0700 (PDT)

Newsgroups	gmane.comp.java.cruise-control.user
Message-ID	<[email protected]>

Hi Team,
 
I am using Cruise Control & ANT to build my Oracle scripts in an oracle database. Cruise Control is identifying changes in a Tortoise SVN local working copy and triggering the build once modifications are found.
 
The problem I am facing is that I need to compile/execute only the modified files to the database and not all files of the repository. Is there any way to do that?
 
The config and build files are attached.
 
Regards,
 
Utsav

------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev

_______________________________________________
Cruisecontrol-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/cruisecontrol-user

config.xml (application/octet-stream, 1.6 KB)

<cruisecontrol>
  <project name="Parrot" buildafterfailed="true">
  <plugin name="svn" classname="net.sourceforge.cruisecontrol.sourcecontrols.SVN"/>
  <bootstrappers> 
    <svnbootstrapper localWorkingCopy="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\projects\Parrot"/>
  </bootstrappers>
    <!-- Defines where cruise looks for changes, to decide whether to run the build -->
    <modificationset quietperiod="180">
      <svn localWorkingCopy="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\projects\Parrot"/>
    </modificationset>

    <!-- Configures the actual build loop, how often and which build file/target -->
    <schedule interval="60">
      <ant antscript="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\apache-ant-1.7.0\bin\ant.bat"
           buildfile="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\apache-ant-1.7.0\bin\build.xml"
           target="build"
           uselogger="true"
           usedebug="false"/>
    </schedule>

    <!-- directory to write build logs to -->
    <log dir="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\Logs\Parrot"/>

    <!-- more recent versions of CC should use the listener below, instead of the
         currentbuildstatusbootstrapper, currentbuildstatuspublisher combination.
         NOTE: Must match filename in CC reporting/jsp - override.properties: user.build.status.file -->

    <listeners>
        <currentbuildstatuslistener file="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\Logs\buildstatus.txt"/>
    </listeners>

    <!-- Publishers are run *after* a build completes -->
    <publishers>
    </publishers>
  </project>
</cruisecontrol>

build.xml (application/octet-stream, 535 B)

<project name="Parrot" default="build">
<target name="build">
<sql  
driver="oracle.jdbc.OracleDriver" 
url="jdbc:oracle:thin:@localhost:1521:xe" 
userid="hr" 
password="hr" 
delimiter="/"
keepformat="true"
>
<classpath>
	<pathelement location="C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar"/>
</classpath> 
<path>
    <fileset dir="D:\cruisecontrol-bin-2.8.4\cruisecontrol-bin-2.8.4\projects\Parrot\Third">
      <include name="data*.sql"/>
    </fileset>
</path> 
</sql>  
</target>
</project>