Support SQL exception translation for ORA-06550

philwebb · philwebb · commit a0745c0c0a6d · 2012-10-24T10:46:06.000-07:00
Oracle error ORA-06550 will now raise a BadSqlGrammarException. Issue: SPR-9853 Backport-Commit: ba5a148
diff --git a/org.springframework.jdbc/src/main/resources/org/springframework/jdbc/support/sql-error-codes.xml b/org.springframework.jdbc/src/main/resources/org/springframework/jdbc/support/sql-error-codes.xml
@@ -166,7 +166,7 @@
 
 	<bean id="Oracle" class="org.springframework.jdbc.support.SQLErrorCodes">
 		<property name="badSqlGrammarCodes">
-			<value>900,903,904,917,936,942,17006</value>
+			<value>900,903,904,917,936,942,17006,6550</value>
 		</property>
 		<property name="invalidResultSetAccessCodes">
 			<value>17003</value>
diff --git a/org.springframework.jdbc/src/test/java/org/springframework/jdbc/support/SQLErrorCodesFactoryTests.java b/org.springframework.jdbc/src/test/java/org/springframework/jdbc/support/SQLErrorCodesFactoryTests.java
@@ -57,8 +57,9 @@ public void testDefaultInstanceWithOracle() {
 	private void assertIsOracle(SQLErrorCodes sec) {
 		assertTrue(sec.getBadSqlGrammarCodes().length > 0);
 		assertTrue(sec.getDataIntegrityViolationCodes().length > 0);
-		// This had better be a Bad SQL Grammar code
+		// These had better be a Bad SQL Grammar code
 		assertTrue(Arrays.binarySearch(sec.getBadSqlGrammarCodes(), "942") >= 0);
+		assertTrue(Arrays.binarySearch(sec.getBadSqlGrammarCodes(), "6550") >= 0);
 		// This had better NOT be
 		assertFalse(Arrays.binarySearch(sec.getBadSqlGrammarCodes(), "9xx42") >= 0);
 	}
