What’s in a name? A title is important and I hope that it describes well what I do want to share with you in this series of articles. It is not so much about how to use the back-end part (Oracle Database) or the front-end (Oracle APEX, Java, Node, React […]
Gert-Jan Paulissen
Senior Oracle architect / developer (PL/SQL & Apex) / DevOps engineer.I am happy to be able to combine work and hobby. Software engineer since 1989. Bridge player since 1977 and dutch champion more than 10 times.
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (6)
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)”, I told you about Git, Subversion, Maven and Flyway. In this final article, I will discuss the following tools & methods: Oracle SQL Developer, utPLSQL, SonarQube, Perl, Ant and DevOps. Oracle […]
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)”, I told you about the Oracle SQL Developer Data Modeler. This time I will discuss the following tools: Git, Subversion, Maven and Flyway. Flyway The first tool I would like to […]
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)”, I told you about the Oracle Database and Oracle APEX. This time I will discuss Oracle SQL Developer Data Modeler. Oracle SQL Developer Data Modeler A book I can recommend is Oracle […]
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)”, I did show you the database structure. This time I will elaborate on the base tools, the Oracle Database and Oracle APEX. Oracle Database How to use it? I can tell […]
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)”, I gave you an introduction. This time I will elaborate on the database structure. Project folder layout The following top level directories may exist for every database application project: Directory Description […]
Continuous Delivery and the Oracle database (III)
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 […]
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 […]