Update of /cvsroot/springnet/Spring.Net/src/Spring/Spring.Data/Data/Common
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv9381
Modified Files:
dbproviders.xml
Log Message:
SPRNET-855 Update Oracle error code mapping to include ORA-2292 as a DataIntegrityViolationCodes
SPRNET-856 Add 03000 as BadSqlGrammarCode and 40001 as CannotSerializeTransactioncode for Postgress providers.
SPRNET-857 Improved MySql provider error code mappings for DataIntegrityViolationCodes
Index: dbproviders.xml
===================================================================
RCS file: /cvsroot/springnet/Spring.Net/src/Spring/Spring.Data/Data/Common/dbproviders.xml,v
retrieving revision 1.30
retrieving revision 1.31
diff -C2 -d -r1.30 -r1.31
*** dbproviders.xml 6 Dec 2007 20:14:30 -0000 1.30
--- dbproviders.xml 25 Jan 2008 21:37:51 -0000 1.31
***************
*** 64,72 ****
<constructor-arg name="parameterDbType" value="System.Data.SqlDbType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<constructor-arg name="parameterDbTypeProperty" value="SqlDbType"/>
! <constructor-arg name="parameterIsNullableProperty" value="IsNullable"/>
<constructor-arg name="parameterNamePrefix" value="@"/>
<constructor-arg name="exceptionType" value="System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<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
--- 64,72 ----
<constructor-arg name="parameterDbType" value="System.Data.SqlDbType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<constructor-arg name="parameterDbTypeProperty" value="SqlDbType"/>
! <constructor-arg name="parameterIsNullableProperty" value="IsNullable"/>
<constructor-arg name="parameterNamePrefix" value="@"/>
<constructor-arg name="exceptionType" value="System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<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
***************
*** 309,313 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1,1400,1722,2291</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 309,313 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1,1400,1722,2291,2292</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 358,362 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 358,362 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062,1169,1215,1216,1217,1451,1452,1557</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 400,404 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 400,404 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062,1169,1215,1216,1217,1451,1452,1557</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 446,450 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 446,450 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062,1169,1215,1216,1217,1451,1452</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 488,492 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 488,492 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062,1169,1215,1216,1217,1451,1452</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 533,537 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 533,537 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062,1169,1215,1216,1217,1451,1452,1557</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 575,579 ****
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
--- 575,579 ----
</property>
<property name="ErrorCodes.DataIntegrityViolationCodes">
! <value>1062,1169,1215,1216,1217,1451,1452,1557</value>
</property>
<property name="ErrorCodes.CannotAcquireLockCodes">
***************
*** 614,618 ****
<!-- error codes taken from http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html -->
<property name="ErrorCodes.badSqlGrammarCodes">
! <value>42000,42601,42602,42622,42804</value>
</property>
<property name="ErrorCodes.DataAccessResourceFailureCodes">
--- 614,618 ----
<!-- error codes taken from http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html -->
<property name="ErrorCodes.badSqlGrammarCodes">
! <value>03000,42000,42601,42602,42622,42804</value>
</property>
<property name="ErrorCodes.DataAccessResourceFailureCodes">
***************
*** 625,628 ****
--- 625,631 ----
<value>55P03</value>
</property>
+ <property name="ErrorCodes.CannotSerializeTransactionCodes">
+ <value>40001</value>
+ </property>
<property name="ErrorCodes.DeadlockLoserCodes">
<value>40P01</value>
***************
*** 656,660 ****
<!-- error codes taken from http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html -->
<property name="ErrorCodes.badSqlGrammarCodes">
! <value>42000,42601,42602,42622,42804</value>
</property>
<property name="ErrorCodes.DataAccessResourceFailureCodes">
--- 659,663 ----
<!-- error codes taken from http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html -->
<property name="ErrorCodes.badSqlGrammarCodes">
! <value>03000,42000,42601,42602,42622,42804</value>
</property>
<property name="ErrorCodes.DataAccessResourceFailureCodes">
***************
*** 667,670 ****
--- 670,676 ----
<value>55P03</value>
</property>
+ <property name="ErrorCodes.CannotSerializeTransactionCodes">
+ <value>40001</value>
+ </property>
<property name="ErrorCodes.DeadlockLoserCodes">
<value>40P01</value>
|