Uploaded image for project: 'Spring.NET'
  1. Spring.NET
  2. SPRNET-1136

Add firebird db provider

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.3.0
    • Component/s: Spring-NET-DA
    • Labels:
      None

      Description

      user Aaron Chancey create a firebird provider, see http://forum.springframework.net/showthread.php?t=5175:

      <object id="Firebird-2.1" type="Spring.Data.Common.DbProvider, Spring.Data" singleton="false">
      <constructor-arg name="dbMetaData">
      <object type="Spring.Data.Common.DbMetadata">
      <constructor-arg name="productName" value="Firebird Server, provider V2.1.0.0 in framework .NET V2.0" />
      <constructor-arg name="assemblyName" value="FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="connectionType" value="FirebirdSql.Data.FirebirdClient.FbConnection, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="commandType" value="FirebirdSql.Data.FirebirdClient.FbCommand, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="parameterType" value="FirebirdSql.Data.FirebirdClient.FbParameter, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="dataAdapterType" value="FirebirdSql.Data.FirebirdClient.FbDataAdapter, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="commandBuilderType" value="FirebirdSql.Data.FirebirdClient.FbCommandBuilder, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="commandBuilderDeriveParametersMethod" value="DeriveParameters"/>
      <constructor-arg name="parameterDbType" value="FirebirdSql.Data.FirebirdClient.FbDbType, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="parameterDbTypeProperty" value="FbDbType"/>
      <constructor-arg name="parameterIsNullableProperty" value="IsNullable"/>
      <constructor-arg name="parameterNamePrefix" value="@"/>
      <constructor-arg name="exceptionType" value="FirebirdSql.Data.FirebirdClient.FbException, FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
      <constructor-arg name="useParameterNamePrefixInParameterCollection" value="true"/>
      <constructor-arg name="useParameterPrefixInSql" value="true"/>
      <constructor-arg name="bindByName" value="true"/>
      <!-- this is only true for .net 1.1 kept it here just in case we want to revert back to this strategy for
      obtaining error codes-->
      <constructor-arg name="errorCodeExceptionExpression" value="Errors[0].Number.ToString()"/>

      <!-- TODO select form system db all errors that have 'incorrect syntax' at the start of the error string-->
      <property name="ErrorCodes.BadSqlGrammarCodes">
      <value>-104</value>
      </property>
      <property name="ErrorCodes.PermissionDeniedCodes">
      <value>-901</value>
      </property>
      <property name="ErrorCodes.DataIntegrityViolationCodes">
      <value>-530</value>
      </property>
      <property name="ErrorCodes.DeadlockLoserCodes">
      <value>-913</value>
      </property>
      </object>
      </constructor-arg>
      </object>

      <alias name="Firebird-2.1" alias="FirebirdSql.Data.FirebirdClient"/>

        Attachments

          Activity

            People

            Assignee:
            mark.pollack Mark Pollack
            Reporter:
            oakinger Erich Eichinger
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: