Category Archives: Oracle

Call Oracle PL/SQL procedure with XMLType from Java using JDBC

Posted on March 11, 2011 by

Recently I needed to call a stored procedure which had Oracle’s XMLType as IN and OUT parameters. The first thing to do is add xdb.jar and xmlparserv2.jar file to your application lib. These contain the required class files for Oracle … Continue reading →

Posted in Database, Integration, Java, Oracle | Tagged , , , , , | 1 Comment

Connect to GlassFishMQ / OpenMQ from ActiveMQ using Camel configuration

Posted on December 6, 2010 by

I was working on a solution based on ActiveMQ where we required to pull messages from GlassFishMQ (based on OpenMQ) and put them on OracleAQ. Now, ActiveMQ uses Camel ESB for internal message routing, this proved useful. However try as … Continue reading →

Posted in Camel, Integration, Java, JMS, Oracle, SOA | Tagged , , , , , | Leave a comment