In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In the previous two Blogs I have described the tools and techniques used to create and install migration scripts. In this Blog I will describe the ‘(un)happy flow’ for a database […]
Gert-Jan Paulissen
Continuous Delivery and the Oracle database (II)
In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In this Blog I will describe how to create migration scripts (automagically). DML scripts This is the more simple case because you need them less often. There are various data compare […]
Continuous Delivery and the Oracle database (I)
In this Blog I will explore the possibilities to apply Continuous Delivery (CD) for the Oracle database. What is Continuous Delivery? The introduction on Wikipedia Continuous Delivery says: “Continuous delivery (CD) is a software engineering approach in which teams produce software in short cycles, ensuring that the software can be […]
Profiling PL/SQL met het package dbms_profiler (dutch)
Oracle biedt sinds Oracle 8i via het package DBMS_PROFILER ondersteuning voor profiling. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden en zal het pldbg package geoptimaliseerd worden waarbij het gebruik van dynamisch PL/SQL wordt verbeterd en conditionele compilatie wordt gebruikt om […]
Debugging PL/SQL met DBMS_DEBUG (dutch)
Oracle biedt sinds Oracle 8i via het package DBMS_DEBUG ondersteuning voor debugging. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden en zullen de volgende toepassingen gepresenteerd worden: een interactieve debugger in SQL*Plus en het automatisch tonen van waardes van in en […]
Optimising Oracle (Performance by Design) – Day 1
From 21 February till 23 February the OakTable seminar Optimising Oracle (Performance by Design) by Jonathan Lewis was held. The seminar had been organised by Lex de Haan, who recently died, and his wife, Juliette Nuijten, from Naturaljoin (http://www.naturaljoin.nl). Despite his death the seminar continued, just as Lex wanted. Naturaljoin […]
Improve your Web Forms deployment using the Java JDAPI library
Did you (or one of your customers) ever encounter ORA-00942 (table or view does not exist) while working in a (Web) form? No, then you can skip this post.
DB utilities – splitting generated DDL scripts
Have you ever tried to split the DDL scripts generated by Designer? Pretty tough, isn’t it? Well, I have a nice solution for you: the Perl script sql_split.pl splits the input DDL script(s) as if you had chosen to generate just one object in Designer. For example: if you generate […]
DB utilities – Oracle JPublisher enables you to easily access PL/SQL from Java
The tool JPublisher is a little bit unknown. But it is a very handy tool for accessing PL/SQL stored procedures, packages, functions as well as object, collection or reference types from Java. There is no need for writing error prone Java code when you need to access those objects: JPublisher […]
Integrating Ant and Checkstyle
The Open Source Java code checker Checkstyle can be easily used by Ant to check your Java code. This is an excerpt from an Ant build.xml file using the Sun Java coding checks: <property name=”checkstyle.home” location=”…”/> <taskdef resource=”checkstyletask.properties” classpath=”${checkstyle.home}/checkstyle-all-3.5.jar”/> <target name=”checkstyle”> <checkstyle config=”${checkstyle.home}/sun_checks.xml” failOnViolation=”false” classpathref=”classpath”> <fileset dir=”${src.dir}” includes=”**/*.java”/> </checkstyle> </target> […]
DB utilities – updating sequences the elegant way
Ever needed to update a sequence so the next value is greater than the maximum value of a table? Well, the quick and dirty ways are select SEQ.nextval from dual; (ever did this a million times?) drop sequence SEQ; create sequence SEQ start with MAX+1; (never had problems with grants […]
XML DB basic demo experience
Introduction Last week I have been investigating the XML DB basic demo at OTN (http://www.oracle.com/technology/tech/xml/xmldb/9.2.0.2.0/index.html, Downloadable Demo). Unfortunately there is also a similar but older demo at http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html (Oracle9i R2 XML DB Demonstration). The demo shows a lot of XML DB stuff. It is quite comprehensive with a few installation […]