Return-Path: 
 <dev-return-29625-apmail-activemq-dev-archive=activemq.apache.org@activemq.apache.org>
X-Original-To: apmail-activemq-dev-archive@www.apache.org
Delivered-To: apmail-activemq-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 2C5DC7EED
	for <apmail-activemq-dev-archive@www.apache.org>;
 Tue, 29 Nov 2011 16:46:02 +0000 (UTC)
Received: (qmail 65357 invoked by uid 500); 29 Nov 2011 16:46:01 -0000
Delivered-To: apmail-activemq-dev-archive@activemq.apache.org
Received: (qmail 65324 invoked by uid 500); 29 Nov 2011 16:46:01 -0000
Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@activemq.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@activemq.apache.org>
List-Post: <mailto:dev@activemq.apache.org>
List-Id: <dev.activemq.apache.org>
Reply-To: dev@activemq.apache.org
Delivered-To: mailing list dev@activemq.apache.org
Received: (qmail 65316 invoked by uid 99); 29 Nov 2011 16:46:01 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Nov 2011 16:46:01 +0000
X-ASF-Spam-Status: No, hits=-2001.2 required=5.0
	tests=ALL_TRUSTED,RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Nov 2011 16:46:00 +0000
Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116])
	by hel.zones.apache.org (Postfix) with ESMTP id 8A374A6C27
	for <dev@activemq.apache.org>; Tue, 29 Nov 2011 16:45:40 +0000 (UTC)
Date: Tue, 29 Nov 2011 16:45:40 +0000 (UTC)
From: "Gary Tully (Created) (JIRA)" <jira@apache.org>
To: dev@activemq.apache.org
Message-ID: 
 <2146962216.22269.1322585140567.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Created] (AMQ-3611) Revert the Oracle jdbc adapter to a
 variant of the default jdbc adapter in place of the one supporting blobs
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

Revert the Oracle jdbc adapter to a variant of the default jdbc adapter in place of the one supporting blobs
------------------------------------------------------------------------------------------------------------

                 Key: AMQ-3611
                 URL: https://issues.apache.org/jira/browse/AMQ-3611
             Project: ActiveMQ
          Issue Type: Improvement
          Components: Message Store
    Affects Versions: 5.5.0
            Reporter: Gary Tully
            Assignee: Gary Tully
             Fix For: 5.6.0


The blob support does non atomic updates on a message add and is a little inefficient due to the need to insert and update the blob. With the latest ojdbc6.jar oracle drivers, blobs can  be used under the hood so the default jdbc adapter can work with oracle.
Currently the following configuration will achieve this:
{code}<persistenceAdapter>
            <jdbcPersistenceAdapter dataSource="#oracle-ds">
                <adapter>
                   <defaultJDBCAdapter>
                     <statements>
                       <statements longDataType="NUMBER" sequenceDataType="NUMBER" />
                      </statements>
                   </defaultJDBCAdapter>
                 </adapter>
            </jdbcPersistenceAdapter>
        </persistenceAdapter>
{code} where oracle-ds is a bean:{code}<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
     <property name="driverClassName" value="oracle.jdbc.OracleDriver" />
     <property name="url" value="jdbc:oracle:thin:@localhost:1521:amq" />
     <property name="username" value="user" />
     <property name="password" value="pass" />
     </bean>{code}

This enhancement will make the Oracle adapter behave like this by default such that the following configuration will work{code}<jdbcPersistenceAdapter dataSource="#oracle-ds" />{code} and will not manipulate blobs directly.
If blob support is necessary for backward compatibility for earlier drivers the blob adapter can be specified using the {{adapter}} element:{code}<persistenceAdapter>
            <jdbcPersistenceAdapter dataSource="#oracle-ds">
                <adapter>
                   <oracleBlobJDBCAdapter />
                 </adapter>
            </jdbcPersistenceAdapter>
        </persistenceAdapter>{code}


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira