cvs commit: xml-cocoon2/src/java/org/apache/cocoon/transformation SQLTransformer.java

[cziegeler]

cziegeler    02/04/08 05:47:50

  Modified:    src/java/org/apache/cocoon/transformation
                        SQLTransformer.java
  Log:
  Added auto-checking for update statements
  
  Revision  Changes    Path
  1.10      +8 -2      
xml-cocoon2/src/java/org/apache/cocoon/transformation/SQLTransformer.java
  
  Index: SQLTransformer.java
  ===================================================================
  RCS file: 
/home/cvs/xml-cocoon2/src/java/org/apache/cocoon/transformation/SQLTransformer.java,v
  retrieving revision 1.9
  retrieving revision 1.10
  diff -u -r1.9 -r1.10
  --- SQLTransformer.java       5 Apr 2002 10:59:12 -0000       1.9
  +++ SQLTransformer.java       8 Apr 2002 12:47:50 -0000       1.10
  @@ -85,7 +85,7 @@
    * @author <a href="mailto:[EMAIL PROTECTED]";>Giacomo Pati</a>
    *         (PWR Organisation & Entwicklung)
    * @author <a href="mailto:[EMAIL PROTECTED]";>Sven Beauprez</a>
  - * @version CVS $Id: SQLTransformer.java,v 1.9 2002/04/05 10:59:12 cziegeler Exp $
  + * @version CVS $Id: SQLTransformer.java,v 1.10 2002/04/08 12:47:50 cziegeler Exp $
    */
   
   public class SQLTransformer
  @@ -1049,7 +1049,13 @@
                       sb.append( query.getColumnValue( av.name ) );
                   }
               }
  -            String query = sb.toString();
  +            String query = sb.toString().trim();
  +            // Test, if this is an update (by comparing with select)
  +            if ( !isstoredprocedure && !isupdate) {
  +                if (query.length() > 6 && 
!query.substring(0,6).equalsIgnoreCase("SELECT")) {
  +                    isupdate = true;
  +                }
  +            }
               if (transformer.getTheLogger().isDebugEnabled()) {
                   transformer.getTheLogger().debug( "EXECUTING " + query );
               }
  
  
  

----------------------------------------------------------------------
In case of troubles, e-mail:     [EMAIL PROTECTED]
To unsubscribe, e-mail:          [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]