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
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!
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
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
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
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
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
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)
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