1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 // MARKER(update_precomp.py): autogen include statement, do not remove 25 #include "precompiled_connectivity.hxx" 26 #include "ado/ACallableStatement.hxx" 27 #include <connectivity/dbexception.hxx> 28 29 using namespace connectivity::ado; 30 using namespace com::sun::star::uno; 31 using namespace com::sun::star::lang; 32 using namespace com::sun::star::beans; 33 using namespace com::sun::star::sdbc; 34 using namespace com::sun::star::container; 35 using namespace com::sun::star::lang; 36 37 IMPLEMENT_SERVICE_INFO(OCallableStatement,"com.sun.star.sdbcx.ACallableStatement","com.sun.star.sdbc.CallableStatement"); 38 39 #define GET_PARAM() \ 40 ADOParameter* pParam = NULL; \ 41 m_pParameters->get_Item(OLEVariant(sal_Int32(columnIndex-1)),&pParam); \ 42 if(pParam) \ 43 pParam->get_Value(&m_aValue); 44 //************************************************************** 45 //************ Class: java.sql.CallableStatement 46 //************************************************************** 47 OCallableStatement::OCallableStatement( OConnection* _pConnection,const OTypeInfoMap& _TypeInfo,const ::rtl::OUString& sql ) 48 : OPreparedStatement( _pConnection, _TypeInfo, sql ) 49 { 50 m_Command.put_CommandType(adCmdStoredProc); 51 } 52 // ------------------------------------------------------------------------- 53 54 Any SAL_CALL OCallableStatement::queryInterface( const Type & rType ) throw(RuntimeException) 55 { 56 Any aRet = OPreparedStatement::queryInterface(rType); 57 return aRet.hasValue() ? aRet : ::cppu::queryInterface(rType,static_cast< XRow*>(this)); 58 } 59 // ------------------------------------------------------------------------- 60 61 62 sal_Bool SAL_CALL OCallableStatement::wasNull( ) throw(SQLException, RuntimeException) 63 { 64 return m_aValue.isNull(); 65 } 66 // ------------------------------------------------------------------------- 67 68 sal_Bool SAL_CALL OCallableStatement::getBoolean( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 69 { 70 GET_PARAM() 71 return m_aValue; 72 } 73 // ------------------------------------------------------------------------- 74 sal_Int8 SAL_CALL OCallableStatement::getByte( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 75 { 76 GET_PARAM() 77 return m_aValue; 78 } 79 // ------------------------------------------------------------------------- 80 Sequence< sal_Int8 > SAL_CALL OCallableStatement::getBytes( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 81 { 82 GET_PARAM() 83 return m_aValue; 84 } 85 // ------------------------------------------------------------------------- 86 ::com::sun::star::util::Date SAL_CALL OCallableStatement::getDate( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 87 { 88 GET_PARAM() 89 return m_aValue; 90 } 91 // ------------------------------------------------------------------------- 92 double SAL_CALL OCallableStatement::getDouble( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 93 { 94 GET_PARAM() 95 return m_aValue; 96 } 97 // ------------------------------------------------------------------------- 98 99 float SAL_CALL OCallableStatement::getFloat( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 100 { 101 GET_PARAM() 102 return m_aValue; 103 } 104 // ------------------------------------------------------------------------- 105 106 sal_Int32 SAL_CALL OCallableStatement::getInt( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 107 { 108 GET_PARAM() 109 return m_aValue; 110 } 111 // ------------------------------------------------------------------------- 112 113 sal_Int64 SAL_CALL OCallableStatement::getLong( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 114 { 115 GET_PARAM() 116 return (sal_Int64)m_aValue.getCurrency().int64; 117 } 118 // ------------------------------------------------------------------------- 119 120 Any SAL_CALL OCallableStatement::getObject( sal_Int32 /*columnIndex*/, const Reference< ::com::sun::star::container::XNameAccess >& /*typeMap*/ ) throw(SQLException, RuntimeException) 121 { 122 ::dbtools::throwFeatureNotImplementedException( "XRow::getObject", *this ); 123 return Any(); 124 } 125 // ------------------------------------------------------------------------- 126 127 sal_Int16 SAL_CALL OCallableStatement::getShort( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 128 { 129 GET_PARAM() 130 return m_aValue; 131 } 132 // ------------------------------------------------------------------------- 133 134 ::rtl::OUString SAL_CALL OCallableStatement::getString( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 135 { 136 GET_PARAM() 137 return m_aValue; 138 } 139 // ------------------------------------------------------------------------- 140 141 ::com::sun::star::util::Time SAL_CALL OCallableStatement::getTime( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 142 { 143 GET_PARAM() 144 return m_aValue; 145 } 146 // ------------------------------------------------------------------------- 147 148 ::com::sun::star::util::DateTime SAL_CALL OCallableStatement::getTimestamp( sal_Int32 columnIndex ) throw(SQLException, RuntimeException) 149 { 150 GET_PARAM() 151 return m_aValue; 152 } 153 // ------------------------------------------------------------------------- 154 155 void SAL_CALL OCallableStatement::registerOutParameter( sal_Int32 parameterIndex, sal_Int32 sqlType, const ::rtl::OUString& /*typeName*/ ) throw(SQLException, RuntimeException) 156 { 157 ADOParameter* pParam = NULL; 158 m_pParameters->get_Item(OLEVariant(sal_Int32(parameterIndex-1)),&pParam); 159 if(pParam) 160 { 161 pParam->put_Type(ADOS::MapJdbc2ADOType(sqlType,m_pConnection->getEngineType())); 162 pParam->put_Direction(adParamOutput); 163 } 164 } 165 // ------------------------------------------------------------------------- 166 void SAL_CALL OCallableStatement::registerNumericOutParameter( sal_Int32 parameterIndex, sal_Int32 sqlType, sal_Int32 scale ) throw(SQLException, RuntimeException) 167 { 168 ADOParameter* pParam = NULL; 169 m_pParameters->get_Item(OLEVariant(sal_Int32(parameterIndex-1)),&pParam); 170 if(pParam) 171 { 172 pParam->put_Type(ADOS::MapJdbc2ADOType(sqlType,m_pConnection->getEngineType())); 173 pParam->put_Direction(adParamOutput); 174 pParam->put_NumericScale((sal_Int8)scale); 175 } 176 } 177 // ------------------------------------------------------------------------- 178 179 180 Reference< ::com::sun::star::io::XInputStream > SAL_CALL OCallableStatement::getBinaryStream( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException) 181 { 182 ::dbtools::throwFeatureNotImplementedException( "XRow::getBinaryStream", *this ); 183 return NULL; 184 } 185 // ------------------------------------------------------------------------- 186 Reference< ::com::sun::star::io::XInputStream > SAL_CALL OCallableStatement::getCharacterStream( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException) 187 { 188 ::dbtools::throwFeatureNotImplementedException( "XRow::getCharacterStream", *this ); 189 return NULL; 190 } 191 // ------------------------------------------------------------------------- 192 193 Reference< XArray > SAL_CALL OCallableStatement::getArray( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException) 194 { 195 ::dbtools::throwFeatureNotImplementedException( "XRow::getArray", *this ); 196 return NULL; 197 } 198 // ------------------------------------------------------------------------- 199 200 Reference< XClob > SAL_CALL OCallableStatement::getClob( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException) 201 { 202 ::dbtools::throwFeatureNotImplementedException( "XRow::getClob", *this ); 203 return NULL; 204 } 205 // ------------------------------------------------------------------------- 206 Reference< XBlob > SAL_CALL OCallableStatement::getBlob( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException) 207 { 208 ::dbtools::throwFeatureNotImplementedException( "XRow::getBlob", *this ); 209 return NULL; 210 } 211 // ------------------------------------------------------------------------- 212 213 Reference< XRef > SAL_CALL OCallableStatement::getRef( sal_Int32 /*columnIndex*/) throw(SQLException, RuntimeException) 214 { 215 ::dbtools::throwFeatureNotImplementedException( "XRow::getRef", *this ); 216 return NULL; 217 } 218 // ------------------------------------------------------------------------- 219 // ----------------------------------------------------------------------------- 220 void SAL_CALL OCallableStatement::acquire() throw() 221 { 222 OPreparedStatement::acquire(); 223 } 224 // ----------------------------------------------------------------------------- 225 void SAL_CALL OCallableStatement::release() throw() 226 { 227 OPreparedStatement::release(); 228 } 229 // ----------------------------------------------------------------------------- 230 231 232