Skip to content

Instantly share code, notes, and snippets.

@sachin-handiekar
sachin-handiekar / dequeue_jms_msg_oracle_aq.sql
Created October 15, 2011 11:46
Dequeue JMS type message in Oracle AQ
declare
queue_options DBMS_AQ.DEQUEUE_OPTIONS_T;
message_properties DBMS_AQ.MESSAGE_PROPERTIES_T;
message_id RAW(2000);
my_message SYS.AQ$_JMS_TEXT_MESSAGE;
msg_text varchar2(32767);
begin
DBMS_AQ.DEQUEUE(
queue_name => 'my_queue',
dequeue_options => queue_options,
@sachin-handiekar
sachin-handiekar / TheTrip.cpp
Created October 16, 2011 20:04
10137:The Trip
/*
* 10137 The Trip
*/
#include <iostream>
using namespace std;
int main()
{
int no_of_trips;
@sachin-handiekar
sachin-handiekar / bitwise_operators.cpp
Created October 16, 2011 20:07
Bitwise Operators
/* * Operator 4 : Bitwise Operators. */
#include "iostream"
#define PRINT(int) printf("%d\n",int)
using namespace std;
int main()
{
int x,y,z;
x = 03, y = 02, z= 01;
@sachin-handiekar
sachin-handiekar / logic_increment_operators.cpp
Created October 16, 2011 20:09
Logic and Increment Operators
/* * Operator 3 : Logic and Increment Operators. */
#include "iostream"
#define PRINT(int) printf("%d\n",int)
using namespace std;
int main()
{
int x,y,z;
x = 2;
@sachin-handiekar
sachin-handiekar / xml_formatter.java
Created October 16, 2011 20:37
XML Formatter/Pretty Printer Java
import org.xml.sax.InputSource;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Source;
import javax.xml.transform.Transformer;
import javax.xml.transform.sax.SAXSource;
import javax.xml.transform.sax.SAXTransformerFactory;
@sachin-handiekar
sachin-handiekar / aq-qtbl-xmlpayload.sql
Created November 3, 2011 21:31
Create a Oracle AQ Queue Table with XMLType payload
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE( Queue_table => 'QT_SAMPLE', Queue_payload_type => 'SYS.XMLTYPE', Sort_list => 'ENQ_TIME', COMMENT => 'A sample queue table');
END;
@sachin-handiekar
sachin-handiekar / aq-queue.sql
Created November 3, 2011 21:32
Create a Oracle AQ Queue
BEGIN
DBMS_AQADM.CREATE_QUEUE( Queue_name => 'Q_SAMPLE', Queue_table => 'QT_SAMPLE', Queue_type => 0, Max_retries => 5, Retry_delay => 10);
END;
@sachin-handiekar
sachin-handiekar / OracleAQQueueConnectionFactory.java
Created November 3, 2011 21:38
A custom Oracle AQ QueueConnectionFactory for Spring JMS
package com.sachinhandiekar.oracle.aq;
import javax.jms.ConnectionFactory;
import javax.sql.DataSource;
public class OracleAQQueueConnectionFactory {
private DataSource dataSource;
public ConnectionFactory createConnectionFactory() throws Exception {
@sachin-handiekar
sachin-handiekar / OracleAQQueueDestinationFactory.java
Created November 3, 2011 21:41
A custom Oracle AQ QueueDestinationFactory for Spring JMS
package com.sachinhandiekar.oracle.aq;
import org.springframework.beans.factory.FactoryBean;
import oracle.jms.AQjmsSession;
import javax.jms.Queue;
import javax.jms.QueueConnection;
import javax.jms.QueueConnectionFactory;
import javax.jms.Session;
@sachin-handiekar
sachin-handiekar / OracleMessageListener.java
Created November 3, 2011 21:43
A custom Oracle AQ MessageListener (XML Type payload) for Spring JMS
package com.sachinhandiekar.oracle.aq;
import javax.jms.Message;
import javax.jms.MessageListener;
import org.springframework.transaction.annotation.Transactional;
import oracle.jms.AQjmsAdtMessage;
import oracle.xdb.XMLType;