Posts

Showing posts with the label command line

My experience as an Oracle developer running Ubuntu

Image
If you have been following my blog, you may have noticed the desktop environment I use is the Ubuntu distribution of Linux. Growing up, I always tried Linux here and there, but never stuck with it - it was more just to try out. As with anything, if you are going to use something new, you really have to commit to it - pick a period of time you are willing to use it for, and see how you go. If you still don't like it at the end, go back into your old ways. (I will add that I did once upon a time own a Mac. Actually, I purchased a Powerbook right before Apple made the switch to the Intel CPU architecture. I know Mac OS X seems quite popular in the development community nowadays, however I still prefer to be able to select my hardware, and I believe I get that freedom and also get a bit of Software freedom by running Linux.) At around 2008 - actually, soon after I started working with APEX - I had a couple of colleagues that were running Ubuntu. Since I started developing with Or...

Building an Oracle 11G XE Server with APEX 5, ORDS and SQLcl in 30 minutes

Image
Pre-requisites 1. You have VirtualBox installed 2. You have the necessary Oracle installation files (oracle-xe, apex5, ords3 and sqlcl) Oracle XE - download from:  http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Apex 5 - download from:  http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html ORDS 3 - download from: http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html SQLcl - download from:  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 3. You have the installation image for CentOS - I just grabbed the Minimal image from a local mirror -  http://centos.mirror.digitalpacific.com.au/7/isos/x86_64/ Set up the virtual machine Give the Virtual machine an appropriate name, and since CentOS is based off Red Hat, specify the type as Red Hat (64-bit). Allocate 1GB RAM Create a new virtual hard drive...

Building ORDS plugins

Image
Oracle Request Data Services (ORDS) released version 3 recently. If you didn't notice, this version allows you to develop plugins (with Java) that can be imported into your ORDS instance, and provide extended functionality. You want to refer to the Oracle REST Data Services Plugin API, located here:  http://download.oracle.com/otndocs/java/javadocs/3.0/plugin-api/index.html , which itself includes a couple of nice documents: Getting started guide Developer guide This post just re-iterates a lot of what has already been covered in the getting started guide, with a focus on using IntelliJ IDEA. Setting the project up in IntelliJ IDEA So the first step is to set up a new project. First however, you will want to verify what version of Java you are using on your server (assuming you are developing on a separate workstation). This can be verified with the command java -version. [user@host ~]# java -version java version "1.7.0_79" OpenJDK Runtime Environment (rh...