Querying XML CLOB Data Directly in Oracle

Querying XML CLOB Data Directly in Oracle

Oracle 9i introduced a new datatype – XMLType- specifically designed for handling XML naively in the database. However, we may find we have a database that stores XML directly in a CLOB/NCLOB datatype (either because of legacy data, or because

Data Pumper – Migrating Data from MySQL to PostgreSQL

Data Pumper – Migrating Data from MySQL to PostgreSQL

I recently made the decision to migrate from MySQL to PostgreSQL (the reasons why to be covered later). I thought I’d just jot down my notes on a tool I tried which helped with the migration – SQL Workbench/J Data

MongoDB in 3 Easy Steps!

MongoDB in 3 Easy Steps!

If  you’re entirely new to MongoDB – this is just a very gentle introduction that gets you up and running with a sample database in just a few easy steps. It’s really easy to get started. The steps are: 1.

JPA Searching Using Lucene – A Working Example with Spring and DBUnit

JPA Searching Using Lucene – A Working Example with Spring and DBUnit

Working Example on Github There’s a small, self contained mavenised example project over on Github to accompany this post – check it out here: https://github.com/adrianmilne/jpa-lucene-spring-demo   Running the Demo See the README file over on GitHub for details of running

502 Proxy Error Using CometD, Apache and Camel

502 Proxy Error Using CometD, Apache and Camel

We recently hit an issue during testing with Apache returning “502 Proxy Errors” to clients who were connecting via CometD (using Apache as a proxy server in front of a Camel/Jetty CometD server).   Our Setup We are using a

Analysing REST Web Services with Squid and AWStats

Analysing REST Web Services with Squid and AWStats

Background I’ve got a Java application running on Tomcat on Amazon EC2, which exposes RESTful web services delivering JSON to a variety of mobile apps and web sites. I’m running a Squid server as a reverse proxy caching in front

CometD and Camel in the Enterprise – A Working Example

CometD and Camel in the Enterprise – A Working Example

Full code is available on GitHub All the Java code for the project is available in Github – requires Maven to run. See the README for more details – link here. The Key Tech Players The demo shows these various

Spring ActiveMQ Producer Client Template

Spring ActiveMQ Producer Client Template

Available on GitHub Demo available on GitHub Overview This is just a very small, very simple template project for sending messages to JMS queues. In my current role we have a lot of different components and systems glued together by

Complex Event Processing Made Easy (using Esper)

Complex Event Processing Made Easy (using Esper)

The following is a very simple example of event stream processing (using the ESPER engine). Note – a full working example is available over on GitHub:  https://github.com/adrianmilne/esper-demo-nuclear What is Complex Event processing (CEP)? Complex Event Processing (CEP), or Event Stream

InstagramPlease check your feed, the data was entered incorrectly.