From: Stephen C. <sc...@us...> - 2002-10-31 23:40:18
|
User: scoy Date: 02/10/31 15:40:17 Modified: src/etc/conf/default Tag: Branch_3_0 standardjbosscmp-jdbc.xml Log: Fix for bug 619969 "SQL Server substring syntax is wrong". Revision Changes Path No revision No revision 1.23.2.23 +3 -3 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml Index: standardjbosscmp-jdbc.xml =================================================================== RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v retrieving revision 1.23.2.22 retrieving revision 1.23.2.23 diff -u -r1.23.2.22 -r1.23.2.23 --- standardjbosscmp-jdbc.xml 31 Oct 2002 02:30:26 -0000 1.23.2.22 +++ standardjbosscmp-jdbc.xml 31 Oct 2002 23:40:16 -0000 1.23.2.23 @@ -7,7 +7,7 @@ <!-- --> <!-- ===================================================================== --> -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.22 2002/10/31 02:30:26 scoy Exp $ --> +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.23 2002/10/31 23:40:16 scoy Exp $ --> <jbosscmp-jdbc> @@ -1405,7 +1405,7 @@ </function-mapping> <function-mapping> <function-name>substring</function-name> - <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql> + <function-sql>substring(?1, ?2, ?3)</function-sql> </function-mapping> <function-mapping> <function-name>lcase</function-name> @@ -1531,7 +1531,7 @@ </function-mapping> <function-mapping> <function-name>substring</function-name> - <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql> + <function-sql>substring(?1, ?2, ?3)</function-sql> </function-mapping> <function-mapping> <function-name>lcase</function-name> |