DZone
Database Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Database Zone > Continuous Integration for Database Developers

Continuous Integration for Database Developers

Here's demo on Developer Cloud Service with some additional sample code.

Shay Shmeltzer user avatar by
Shay Shmeltzer
·
Jul. 16, 16 · Database Zone · Tutorial
Like (4)
Save
Tweet
2.68K Views

Join the DZone community and get the full member experience.

Join For Free

About a year ago I posted a demo showing how to manage the full development lifecycle of your database code with the help of Developer Cloud Service. Since then, we released new versions of both Developer Cloud Service and JDeveloper that make the experience even smoother and add more features — so I figured I'd record a small, updated demo.

In this demo, I'm starting from an existing project that has a list of tasks being tracked in a development sprint in the new Agile tab in Developer Cloud Service — which gives you a great view of your development effort and progress. 

(If you want to see how you create the initial project and add issues to it check out the previous demo). 

A few new things you'll see in this demo:

  • The new Agile/Sprint management dashboard in Developer Cloud Service.
  • Task tracking integration in JDeveloper.
  • Updating definition of database objects in JDeveloper and generating SQL scripts.
  • Branching Git repositories.
  • Code review for SQL files.
  • Build automation for DB changes with Ant — including deployment to a cloud database.


Note that in this video I'm using a cloud instance of an Oracle database where port 1521 is open for SQLNet communication. The instructions for opening this port for communication on an Oracle Cloud Database are here.


Another approach that you can take is to use scripts that execute commands using SSH on the Database Cloud Service - you can see this approach in action in this video showing Developer Cloud Service managing an Oracle APEX Lifecycle.  

The Ant script used in the sample is:

<?xml version="1.0" encoding="UTF-8" ?>
<project xmlns="antlib:org.apache.tools.ant" default="init">
    <target name="init">
        <tstamp/>
    </target>
    <path id="antclasspath">
        <fileset dir=".">
            <include name="ojdbc7.jar"/>
        </fileset>
    </path>
    <target name="deploy">
    <sql driver="oracle.jdbc.OracleDriver" userid="C##xxxx" password="xxxx"
         url="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:ORCL" src="./database/DATABASE1/dbcreate.sql"
         classpathref="antclasspath" onerror="continue"/>
  </target>
</project>

Note that you need the Oracle JDBC jar file to be accessible from the Ant script - I just included it in my Git repository.

If you like to try this out with your own database development project - get a trial of Oracle Developer Cloud Service here. 

Cloud database dev CI/CD Integration

Published at DZone with permission of Shay Shmeltzer, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • JUnit 5 Tutorial: Nice and Easy [Video]
  • Using Unsupervised Learning to Combat Cyber Threats
  • The Evolution of Configuration Management: IaC vs. GitOps
  • Kafka Fail-Over Using Quarkus Reactive Messaging

Comments

Database Partner Resources

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo