Announcement Announcement Module
Collapse
No announcement yet.
Question re. "sql-error-codes.xml" Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Question re. "sql-error-codes.xml"

    How come this file contains so few properties for error types?
    For instance Oracle (shown below) has only six, surely this is not sufficient to deal with all possible exceptions that could occur?
    And also:why is DatabaseProductName not included as a property in every bean?
    How can it find the code for the correct db without this information?

    Code:
    <bean id="Oracle" class="org.springframework.jdbc.support.SQLErrorCodes">
    		<property name="badSqlGrammarCodes">
    			<value>900,903,904,917,936,942,17006</value>
    		</property>
    		<property name="invalidResultSetAccessCodes">
    			<value>17003</value>
    		</property>
    		<property name="dataAccessResourceFailureCodes">
    			<value>17002,17447</value>
    		</property>
    		<property name="dataIntegrityViolationCodes">
    			<value>1,1400,1722,2291</value>
    		</property>
    		<property name="cannotAcquireLockCodes">
    			<value>54</value>
    		</property>
    		<property name="deadlockLoserCodes">
    			<value>60</value>
    		</property>
    	</bean>
    Last edited by leesider; Mar 13th, 2007, 05:43 AM. Reason: extra question
Working...
X