mcs/class/System.Data/System.Data.OleDb.jvm/OleDbParameter.cs

   1 //
   2 // System.Data.OleDb.OleDbParameter
   3 //
   4 // Authors:
   5 //      Konstantin Triger <kostat@mainsoft.com>
   6 //      Boris Kirzner <borisk@mainsoft.com>
   7 //
   8 // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
   9 //
  10
  11 //
  12 // Permission is hereby granted, free of charge, to any person obtaining
  13 // a copy of this software and associated documentation files (the
  14 // "Software"), to deal in the Software without restriction, including
  15 // without limitation the rights to use, copy, modify, merge, publish,
  16 // distribute, sublicense, and/or sell copies of the Software, and to
  17 // permit persons to whom the Software is furnished to do so, subject to
  18 // the following conditions:
  19 //
  20 // The above copyright notice and this permission notice shall be
  21 // included in all copies or substantial portions of the Software.
  22 //
  23 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  24 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  25 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  26 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  27 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  28 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  29 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  30 //
  31
  32
  33 using System;
  34 using System.Text;
  35 using System.Data;
  36 using System.Data.Common;
  37 using System.Data.ProviderBase;
  38
  39 using java.sql;
  40 using java.lang;
  41 using System.Globalization;
  42
  43 namespace System.Data.OleDb
  44 {
  45     public sealed class OleDbParameter : AbstractDbParameter
  46     {
  47
  48                 #region Fields
  49
  50         private OleDbType _oleDbType = OleDbType.VarWChar;
  51                 private bool _isOracleRefCursor = false;
  52
  53                 #endregion // Fields
  54
  55                 #region Constructors
  56
  57         public OleDbParameter()
  58         {
  59         }
  60
  61         public OleDbParameter(String parameterName, Object value)
  62                         : this (parameterName, OleDbType.VarWChar, 0, ParameterDirection.Input,
  63                                         false, 0, 0, String.Empty, DataRowVersion.Current, value)
  64         {
  65                         IsDbTypeSet = false;
  66         }
  67
  68         public OleDbParameter(String parameterName, OleDbType dbType)
  69                         : this (parameterName, dbType, 0, ParameterDirection.Input,
  70                                         false, 0, 0, String.Empty, DataRowVersion.Current, null)
  71         {
  72         }
  73
  74         public OleDbParameter(String parameterName, OleDbType dbType, int size)
  75                         : this (parameterName, dbType, size, ParameterDirection.Input,
  76                                         false, 0, 0, String.Empty, DataRowVersion.Current, null)
  77         {
  78         }
  79
  80         public OleDbParameter(String parameterName, OleDbType dbType, int size,
  81             String sourceColumn)
  82                         : this (parameterName, dbType, size, ParameterDirection.Input,
  83                                         false, 0, 0, sourceColumn, DataRowVersion.Current, null)
  84         {
  85         }
  86
  87
  88         public OleDbParameter(String parameterName,
  89                                                         OleDbType dbType,
  90                                                         int size,
  91                                                         ParameterDirection direction,
  92                                                         bool isNullable,
  93                                                         byte precision,
  94                                                         byte scale,
  95                                                         String sourceColumn,
  96                                                         DataRowVersion sourceVersion,
  97                                                         Object value)
  98         {
  99             ParameterName = parameterName;
 100             OleDbType = dbType;
 101             Size = size;
 102             Direction = direction;
 103             IsNullable = isNullable;
 104             Precision = precision;
 105             Scale = scale;
 106             SourceColumn = sourceColumn;
 107             SourceVersion = sourceVersion;
 108             Value = value;
 109         }
 110
 111                 #endregion // Constructors
 112
 113                 #region Properties
 114
 115                 public override DbType DbType
 116         {
 117             get { return OleDbConvert.OleDbTypeToDbType(_oleDbType); }
 118                         set { OleDbType = OleDbConvert.DbTypeToOleDbType(value); }
 119         }
 120
 121         public OleDbType OleDbType
 122         {
 123             get { return _oleDbType; }
 124                         set {
 125                 _oleDbType = value;
 126                                 IsDbTypeSet = true;
 127             }
 128         }
 129
 130 #if NET_2_0
 131                 public new byte Precision
 132                 {
 133                         get { return base.Precision; }
 134                         set { base.Precision = value; }
 135                 }
 136
 137                 public new byte Scale
 138                 {
 139                         get { return base.Scale; }
 140                         set { base.Scale = value; }
 141                 }
 142 #endif
 143
 144         public new Object Value
 145         {
 146             get { return base.Value; }
 147             set {
 148                 if (!IsDbTypeSet && (value != null) && (value != DBNull.Value)) {
 149                     _oleDbType = OleDbConvert.ValueTypeToOleDbType(value.GetType());
 150                                 }
 151                 base.Value = value;
 152             }
 153         }
 154
 155                 protected internal sealed override bool IsSpecial {
 156                         get {
 157                                 return (Direction == ParameterDirection.Output) && IsOracleRefCursor;
 158                         }
 159                 }
 160
 161
 162                 internal bool IsOracleRefCursor
 163                 {
 164                         get { return _isOracleRefCursor; }
 165                         set { _isOracleRefCursor = value; }
 166                 }
 167
 168                 #endregion // Properties
 169
 170                 #region Methods
 171
 172                 protected internal sealed override object ConvertValue(object value)
 173                 {
 174                         // can not convert null or DbNull to other types
 175                         if (value == null || value == DBNull.Value) {
 176                                 return value;
 177                         }
 178
 179                         // FIXME : some other way to do this?
 180                         if (OleDbType == OleDbType.Binary) {
 181                                 return value;
 182                         }
 183                         // .NET throws an exception to the user.
 184                         object convertedValue  = value;
 185
 186                         // note : if we set user parameter jdbc type inside prepare interbal, the db type is not set
 187                         if (value is IConvertible && (IsDbTypeSet || IsJdbcTypeSet)) {
 188                                 OleDbType oleDbType = (IsDbTypeSet) ? OleDbType : OleDbConvert.JdbcTypeToOleDbType((int)JdbcType);
 189                                 Type to = OleDbConvert.OleDbTypeToValueType(oleDbType);
 190                                 if (!(value is DateTime && to == DbTypes.TypeOfTimespan)) //anyway will go by jdbc type
 191                                         convertedValue = Convert.ChangeType(value,to);
 192                         }
 193                         return convertedValue;
 194                 }
 195
 196                 protected internal sealed override void SetParameterName(ResultSet res)
 197                 {
 198                         ParameterName = res.getString("COLUMN_NAME");
 199
 200                         if (ParameterName.StartsWith("@")) {
 201                                 ParameterName = ParameterName.Remove(0,1);
 202                         }
 203                 }
 204
 205                 protected internal sealed override void SetParameterDbType(ResultSet res)
 206                 {
 207                         int jdbcType = res.getInt("DATA_TYPE");
 208                         // FIXME : is that correct?
 209                         if (jdbcType == Types.OTHER) {
 210                                 string typeName = res.getString("TYPE_NAME");
 211                                 if (String.Compare ("BLOB", typeName, true, CultureInfo.InvariantCulture) == 0) {
 212                                         jdbcType = Types.BLOB;
 213                                 }
 214                                 else if (String.Compare ("CLOB", typeName, true, CultureInfo.InvariantCulture) == 0) {
 215                                         jdbcType = Types.CLOB;
 216                                 }
 217                                 else if (String.Compare ("FLOAT", typeName, true, CultureInfo.InvariantCulture) == 0) {
 218                                         jdbcType = Types.FLOAT;
 219                                 }
 220                                 else if (String.Compare ("NVARCHAR2", typeName, true, CultureInfo.InvariantCulture) == 0) {
 221                                         jdbcType = Types.VARCHAR;
 222                                 }
 223                                 else if (String.Compare ("NCHAR", typeName, true, CultureInfo.InvariantCulture) == 0) {
 224                                         jdbcType = Types.VARCHAR;
 225                                 }
 226                         }
 227                         OleDbType = OleDbConvert.JdbcTypeToOleDbType(jdbcType);
 228                         JdbcType = jdbcType;
 229                 }
 230
 231 #if NET_2_0
 232                 public void ResetOleDbType ()
 233                 {
 234                         IsDbTypeSet = false;
 235                 }
 236
 237                 public override void ResetDbType ()
 238                 {
 239                         ResetOleDbType ();
 240                 }
 241 #endif
 242
 243                 protected internal sealed override void SetSpecialFeatures(ResultSet res)
 244                 {
 245                         IsOracleRefCursor = (res.getString("TYPE_NAME") == "REF CURSOR");
 246                 }
 247
 248                 protected internal sealed override int JdbcTypeFromProviderType()
 249                 {
 250                         return OleDbConvert.OleDbTypeToJdbcType(OleDbType);
 251                 }
 252
 253                 #endregion // Methods
 254
 255     }
 256 }