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 */ 017 package org.apache.activemq.store.jdbc.adapter; 018 019 import java.sql.Blob; 020 import java.sql.ResultSet; 021 import java.sql.SQLException; 022 023 import org.apache.activemq.store.jdbc.Statements; 024 025 /** 026 * Implements all the default JDBC operations that are used 027 * by the JDBCPersistenceAdapter. 028 * <p/> 029 * Subclassing is encouraged to override the default 030 * implementation of methods to account for differences 031 * in JDBC Driver implementations. 032 * <p/> 033 * The JDBCAdapter inserts and extracts BLOB data using the 034 * getBytes()/setBytes() operations. 035 * <p/> 036 * The databases/JDBC drivers that use this adapter are: 037 * <ul> 038 * <li></li> 039 * </ul> 040 * 041 * @org.apache.xbean.XBean element="oracleJDBCAdapter" 042 * 043 * 044 */ 045 public class OracleJDBCAdapter extends BlobJDBCAdapter { 046 047 public void setStatements(Statements statements) { 048 statements.setLongDataType("NUMBER"); 049 statements.setSequenceDataType("NUMBER"); 050 super.setStatements(statements); 051 } 052 053 protected byte[] getBinaryData(ResultSet rs, int index) throws SQLException { 054 // Get as a BLOB 055 Blob aBlob = rs.getBlob(index); 056 if (aBlob == null) { 057 return null; 058 } 059 return aBlob.getBytes(1, (int) aBlob.length()); 060 } 061 }