[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

[Stephen C. <sc...@us...>]

  User: scoy    
  Date: 02/10/31 15:38:02

  Modified:    src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Fix for bug 619969 "SQL Server substring syntax is wrong".
  
  Revision  Changes    Path
  1.52      +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.51
  retrieving revision 1.52
  diff -u -r1.51 -r1.52
  --- standardjbosscmp-jdbc.xml	31 Oct 2002 06:37:46 -0000	1.51
  +++ standardjbosscmp-jdbc.xml	31 Oct 2002 23:38:01 -0000	1.52
  @@ -7,7 +7,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.51 2002/10/31 06:37:46 scoy Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.52 2002/10/31 23:38:01 scoy Exp $ -->
   
   <jbosscmp-jdbc>
      
  @@ -1499,7 +1499,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>
  @@ -1625,7 +1625,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>