001/** 002 * Licensed to the Apache Software Foundation (ASF) under one or more 003 * contributor license agreements. See the NOTICE file distributed with 004 * this work for additional information regarding copyright ownership. 005 * The ASF licenses this file to You under the Apache License, Version 2.0 006 * (the "License"); you may not use this file except in compliance with 007 * the License. You may obtain a copy of the License at 008 * 009 * http://www.apache.org/licenses/LICENSE-2.0 010 * 011 * Unless required by applicable law or agreed to in writing, software 012 * distributed under the License is distributed on an "AS IS" BASIS, 013 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 014 * See the License for the specific language governing permissions and 015 * limitations under the License. 016 */ 017package org.apache.activemq.store.jdbc.adapter; 018 019import java.sql.Blob; 020import java.sql.ResultSet; 021import java.sql.SQLException; 022import org.apache.activemq.store.jdbc.Statements; 023 024/** 025 * Implements all the default JDBC operations that are used 026 * by the JDBCPersistenceAdapter. 027 * <p/> 028 * Subclassing is encouraged to override the default 029 * implementation of methods to account for differences 030 * in JDBC Driver implementations. 031 * <p/> 032 * The JDBCAdapter inserts and extracts BLOB data using the 033 * getBytes()/setBytes() operations. 034 * <p/> 035 * The databases/JDBC drivers that use this adapter are: 036 * <ul> 037 * <li></li> 038 * </ul> 039 * 040 * @org.apache.xbean.XBean element="oracleBlobJDBCAdapter" 041 * 042 * 043 */ 044public class OracleBlobJDBCAdapter extends BlobJDBCAdapter { 045 046 @Override 047 public void setStatements(Statements statements) { 048 statements.setLongDataType("NUMBER"); 049 statements.setSequenceDataType("NUMBER"); 050 051 String addMessageStatement = "INSERT INTO " 052 + statements.getFullMessageTableName() 053 + "(ID, MSGID_PROD, MSGID_SEQ, CONTAINER, EXPIRATION, PRIORITY, MSG) VALUES (?, ?, ?, ?, ?, ?, empty_blob())"; 054 statements.setAddMessageStatement(addMessageStatement); 055 056 String findMessageByIdStatement = "SELECT MSG FROM " + 057 statements.getFullMessageTableName() + " WHERE ID=? FOR UPDATE"; 058 statements.setFindMessageByIdStatement(findMessageByIdStatement); 059 060 super.setStatements(statements); 061 } 062 063 @Override 064 protected byte[] getBinaryData(ResultSet rs, int index) throws SQLException { 065 // Get as a BLOB 066 Blob aBlob = rs.getBlob(index); 067 if (aBlob == null) { 068 return null; 069 } 070 return aBlob.getBytes(1, (int) aBlob.length()); 071 } 072}