DerbySqlValidator.java

/*
 *  Copyright 2009-2012 Michael Dalton
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */
package jtaint;

import java.sql.Connection;

/* Apache Derby - Supports 10.0 - 10.4 
 * Lexical changes between 10.0 and 10.4:
 *
 *   Feature: Support for nested block comments   
 *   Added: 10.4
 */

public final class DerbySqlValidator extends SqlValidator
{
    private final boolean blockComments;

    public void validateSqlQuery(String s)
    {
        if (!s.@internal@isTainted()) return;

        Taint t = s.@internal@taint();
        int len = s.length();

        for (int i = 0; i < len; i++) {
            char c = s.charAt(i);

            if (t.get(i)) {
                i = SqlParseUtil.parseTaintedValue(s, i, this);
                continue;
            }

            switch(c) {
                case '-':
                    /* Possibly a line comment */
                    if (i < len - 1 && s.charAt(i+1) == '-') 
                        i = SqlParseUtil.parseLineComment(s, i, "--");
                    break;

                case '/':
                    /* Possibly a block comment  */
                    if (blockComments && i < len - 1 && s.charAt(i+1) == '*') 
                        i = SqlParseUtil.parseNestedBlockComment(s, i);
                    break;

                case '\'':
                    /* String Literal */
                    i = SqlParseUtil.parseStringLiteral(s, i, false);
                    break;

                case '"':
                    /* Quoted identifier */
                    i = SqlParseUtil.parseQuotedIdentifier(s, i);
                    break;

                default:
                    break;
            }
        }
    }

    public DerbySqlValidator(Connection c, int dbMajor, int dbMinor) { 
        this.blockComments = dbMajor >= 10 && dbMinor >= 4;
    }

    public DerbySqlValidator(boolean blockComments) { 
        this.blockComments = blockComments; 
    }
}