package org.apache.jmeter.protocol.jdbc;

import java.io.IOException;

import java.io.UnsupportedEncodingException;

import java.lang.reflect.Field;

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.Collection;

import java.util.HashMap;

import java.util.LinkedHashMap;

import java.util.List;

import java.util.Map;

import org.apache.commons.lang.text.StrBuilder;

import org.apache.jmeter.samplers.SampleResult;

import org.apache.jmeter.save.CSVSaveService;

import org.apache.jmeter.testelement.AbstractTestElement;

import org.apache.jmeter.threads.JMeterVariables;

import org.apache.jmeter.util.JMeterUtils;

import org.apache.jorphan.logging.LoggingManager;

import org.apache.log.Logger;

/**

 * A base class for all JDBC test elements handling the basics of a SQL request.

 * 

 */

public abstract class AbstractJdbcTestElement extends AbstractTestElement {

    private static final long serialVersionUID = 235L;

    private static final Logger log = LoggingManager.getLoggerForClass();

    private static final String COMMA = ","; // $NON-NLS-1$

    private static final char COMMA_CHAR = ',';

    private static final String UNDERSCORE = "_"; // $NON-NLS-1$

    // This value is used for both the connection (perConnCache) and statement (preparedStatementMap) caches.

    // TODO - do they have to be the same size?

    private static final int MAX_ENTRIES =

        JMeterUtils.getPropDefault("jdbcsampler.cachesize",200); // $NON-NLS-1$

    // String used to indicate a null value

    private static final String NULL_MARKER =

        JMeterUtils.getPropDefault("jdbcsampler.nullmarker","]NULL["); // $NON-NLS-1$

    private static final String INOUT = "INOUT"; // $NON-NLS-1$

    private static final String OUT = "OUT"; // $NON-NLS-1$

    // TODO - should the encoding be configurable?

    protected static final String ENCODING = "UTF-8"; // $NON-NLS-1$

    // key: name (lowercase) from java.sql.Types; entry: corresponding int value

    private static final Map<String, Integer> mapJdbcNameToInt;

    // read-only after class init

    static {

        // based on e291. Getting the Name of a JDBC Type from javaalmanac.com

        // http://javaalmanac.com/egs/java.sql/JdbcInt2Str.html

        mapJdbcNameToInt = new HashMap<String, Integer>();

        //Get all fields in java.sql.Types and store the corresponding int values

        Field[] fields = java.sql.Types.class.getFields();

        for (int i=0; i<fields.length; i++) {

            try {

                String name = fields[i].getName();

                Integer value = (Integer)fields[i].get(null);

                mapJdbcNameToInt.put(name.toLowerCase(java.util.Locale.ENGLISH),value);

            } catch (IllegalAccessException e) {

                throw new RuntimeException(e); // should not happen

            }

        }

    }

    // Query types (used to communicate with GUI)

    // N.B. These must not be changed, as they are used in the JMX files

    static final String SELECT   = "Select Statement"; // $NON-NLS-1$

    static final String UPDATE   = "Update Statement"; // $NON-NLS-1$

    static final String CALLABLE = "Callable Statement"; // $NON-NLS-1$

    static final String PREPARED_SELECT = "Prepared Select Statement"; // $NON-NLS-1$

    static final String PREPARED_UPDATE = "Prepared Update Statement"; // $NON-NLS-1$

    static final String COMMIT   = "Commit"; // $NON-NLS-1$

    static final String ROLLBACK = "Rollback"; // $NON-NLS-1$

    static final String AUTOCOMMIT_FALSE = "AutoCommit(false)"; // $NON-NLS-1$

    static final String AUTOCOMMIT_TRUE  = "AutoCommit(true)"; // $NON-NLS-1$

    private String query = ""; // $NON-NLS-1$

    private String dataSource = ""; // $NON-NLS-1$

    private String queryType = SELECT;

    private String queryArguments = ""; // $NON-NLS-1$

    private String queryArgumentsTypes = ""; // $NON-NLS-1$

    private String variableNames = ""; // $NON-NLS-1$

    private String resultVariable = "";

    /**

     *  Cache of PreparedStatements stored in a per-connection basis. Each entry of this

     *  cache is another Map mapping the statement string to the actual PreparedStatement.

     *  The cache has a fixed size of MAX_ENTRIES and it will throw away all PreparedStatements

     *  from the least recently used connections.

     */

    private static final Map<Connection, Map<String, PreparedStatement>> perConnCache =

        new LinkedHashMap<Connection, Map<String, PreparedStatement>>(MAX_ENTRIES){

        private static final long serialVersionUID = 1L;

        @Override

        protected boolean removeEldestEntry(Map.Entry<Connection, Map<String, PreparedStatement>> arg0) {

            if (size() > MAX_ENTRIES) {

                final  Map<String, PreparedStatement> value = arg0.getValue();

                closeAllStatements(value.values());

                return true;

            }

            return false;

        }

    };

    /**

     * Creates a JDBCSampler.

     */

    protected AbstractJdbcTestElement() {

    }

    /**

     * Execute the test element.

     * 

     * @param res a {@link SampleResult} in case the test should sample; <code>null</code> if only execution is requested

     * @throws UnsupportedOperationException if the user provided incorrect query type 

     */

    protected byte[] execute(Connection conn) throws SQLException, UnsupportedEncodingException, IOException, UnsupportedOperationException {

        log.debug("executing jdbc");

        Statement stmt = null;

        try {

            // Based on query return value, get results

            String _queryType = getQueryType();

            if (SELECT.equals(_queryType)) {

                stmt = conn.createStatement();

                ResultSet rs = null;

                try {

                    rs = stmt.executeQuery(getQuery());

                    return getStringFromResultSet(rs).getBytes(ENCODING);

                } finally {

                    close(rs);

                }

            } else if (CALLABLE.equals(_queryType)) {

                CallableStatement cstmt = getCallableStatement(conn);

                int out[]=setArguments(cstmt);

                // A CallableStatement can return more than 1 ResultSets

                // plus a number of update counts.

                boolean hasResultSet = cstmt.execute();

                String sb = resultSetsToString(cstmt,hasResultSet, out);

                return sb.getBytes(ENCODING);

            } else if (UPDATE.equals(_queryType)) {

                stmt = conn.createStatement();

                stmt.executeUpdate(getQuery());

                int updateCount = stmt.getUpdateCount();

                String results = updateCount + " updates";

                return results.getBytes(ENCODING);

            } else if (PREPARED_SELECT.equals(_queryType)) {

                PreparedStatement pstmt = getPreparedStatement(conn);

                setArguments(pstmt);

                boolean hasResultSet = pstmt.execute();

                String sb = resultSetsToString(pstmt,hasResultSet,null);

                return sb.getBytes(ENCODING);

            } else if (PREPARED_UPDATE.equals(_queryType)) {

                PreparedStatement pstmt = getPreparedStatement(conn);

                setArguments(pstmt);

                pstmt.executeUpdate();

                String sb = resultSetsToString(pstmt,false,null);

                return sb.getBytes(ENCODING);

            } else if (ROLLBACK.equals(_queryType)){

                conn.rollback();

                return ROLLBACK.getBytes(ENCODING);

            } else if (COMMIT.equals(_queryType)){

                conn.commit();

                return COMMIT.getBytes(ENCODING);

            } else if (AUTOCOMMIT_FALSE.equals(_queryType)){

                conn.setAutoCommit(false);

                return AUTOCOMMIT_FALSE.getBytes(ENCODING);

            } else if (AUTOCOMMIT_TRUE.equals(_queryType)){

                conn.setAutoCommit(true);

                return AUTOCOMMIT_TRUE.getBytes(ENCODING);

            } else { // User provided incorrect query type

                throw new UnsupportedOperationException("Unexpected query type: "+_queryType);

            }

        } finally {

            close(stmt);

        }

    }

    private String resultSetsToString(PreparedStatement pstmt, boolean result, int[] out) throws SQLException, UnsupportedEncodingException {

        StrBuilder sb = new StrBuilder();

        int updateCount = 0;

        if (!result) {

            updateCount = pstmt.getUpdateCount();

        }

        do {

            if (result) {

                ResultSet rs = null;

                try {

                    rs = pstmt.getResultSet();

                    sb.append(getStringFromResultSet(rs)).append("\n"); // $NON-NLS-1$

                } finally {

                    close(rs);

                }

            } else {

                sb.append(updateCount).append(" updates.\n");

            }

            result = pstmt.getMoreResults();

            if (!result) {

                updateCount = pstmt.getUpdateCount();

            }

        } while (result || (updateCount != -1));

        if (out!=null && pstmt instanceof CallableStatement){

            CallableStatement cs = (CallableStatement) pstmt;

            sb.append("Output variables by position:\n");

            for(int i=0; i < out.length; i++){

                if (out[i]!=java.sql.Types.NULL){

                    sb.append("[");

                    sb.append(i+1);

                    sb.append("] ");

                    sb.append(cs.getObject(i+1));

                    sb.append("\n");

                }

            }

        }

        return sb.toString();

    }

    private int[] setArguments(PreparedStatement pstmt) throws SQLException, IOException {

        if (getQueryArguments().trim().length()==0) {

            return new int[]{};

        }

        String[] arguments = CSVSaveService.csvSplitString(getQueryArguments(), COMMA_CHAR);

        String[] argumentsTypes = getQueryArgumentsTypes().split(COMMA);

        if (arguments.length != argumentsTypes.length) {

            throw new SQLException("number of arguments ("+arguments.length+") and number of types ("+argumentsTypes.length+") are not equal");

        }

        int[] outputs= new int[arguments.length];

        for (int i = 0; i < arguments.length; i++) {

            String argument = arguments[i];

            String argumentType = argumentsTypes[i];

            String[] arg = argumentType.split(" ");

            String inputOutput="";

            if (arg.length > 1) {

                argumentType = arg[1];

                inputOutput=arg[0];

            }

            int targetSqlType = getJdbcType(argumentType);

            try {

                if (!OUT.equalsIgnoreCase(inputOutput)){

                    if (argument.equals(NULL_MARKER)){

                        pstmt.setNull(i+1, targetSqlType);

                    } else {

                        pstmt.setObject(i+1, argument, targetSqlType);

                    }

                }

                if (OUT.equalsIgnoreCase(inputOutput)||INOUT.equalsIgnoreCase(inputOutput)) {

                    CallableStatement cs = (CallableStatement) pstmt;

                    cs.registerOutParameter(i+1, targetSqlType);

                    outputs[i]=targetSqlType;

                } else {

                    outputs[i]=java.sql.Types.NULL; // can't have an output parameter type null

                }

            } catch (NullPointerException e) { // thrown by Derby JDBC (at least) if there are no "?" markers in statement

                throw new SQLException("Could not set argument no: "+(i+1)+" - missing parameter marker?");

            }

        }

        return outputs;

    }

    private static int getJdbcType(String jdbcType) throws SQLException {

        Integer entry = mapJdbcNameToInt.get(jdbcType.toLowerCase(java.util.Locale.ENGLISH));

        if (entry == null) {

            try {

                entry = Integer.decode(jdbcType);

            } catch (NumberFormatException e) {

                throw new SQLException("Invalid data type: "+jdbcType);

            }

        }

        return (entry).intValue();

    }

    private CallableStatement getCallableStatement(Connection conn) throws SQLException {

        return (CallableStatement) getPreparedStatement(conn,true);

    }

    private PreparedStatement getPreparedStatement(Connection conn) throws SQLException {

        return getPreparedStatement(conn,false);

    }

    private PreparedStatement getPreparedStatement(Connection conn, boolean callable) throws SQLException {

        Map<String, PreparedStatement> preparedStatementMap = perConnCache.get(conn);

        if (null == preparedStatementMap ) {

            // MRU PreparedStatements cache.

            preparedStatementMap = new LinkedHashMap<String, PreparedStatement>(MAX_ENTRIES) {

                private static final long serialVersionUID = 240L;

                @Override

                protected boolean removeEldestEntry(Map.Entry<String, PreparedStatement> arg0) {

                    final int theSize = size();

                    if (theSize > MAX_ENTRIES) {

                        Object value = arg0.getValue();

                        if (value instanceof PreparedStatement) {

                            PreparedStatement pstmt = (PreparedStatement) value;

                            close(pstmt);

                        }

                        return true;

                    }

                    return false;

                }

            };

            perConnCache.put(conn, preparedStatementMap);

        }

        PreparedStatement pstmt = preparedStatementMap.get(getQuery());

        if (null == pstmt) {

            if (callable) {

                pstmt = conn.prepareCall(getQuery());

            } else {

                pstmt = conn.prepareStatement(getQuery());

            }

            preparedStatementMap.put(getQuery(), pstmt);

        }

        pstmt.clearParameters();

        return pstmt;

    }

    private static void closeAllStatements(Collection<PreparedStatement> collection) {

        for (PreparedStatement pstmt : collection) {

            close(pstmt);

        }

    }

    /**

     * Gets a Data object from a ResultSet.

     *

     * @param rs

     *            ResultSet passed in from a database query

     * @return a Data object

     * @throws java.sql.SQLException

     * @throws UnsupportedEncodingException

     */

    private String getStringFromResultSet(ResultSet rs) throws SQLException, UnsupportedEncodingException {

        ResultSetMetaData meta = rs.getMetaData();

        StrBuilder sb = new StrBuilder();

        int numColumns = meta.getColumnCount();

        for (int i = 1; i <= numColumns; i++) {

            sb.append(meta.getColumnName(i));

            if (i==numColumns){

                sb.append('\n');

            } else {

                sb.append('\t');

            }

        }

        JMeterVariables jmvars = getThreadContext().getVariables();

        String varnames[] = getVariableNames().split(COMMA);

        String resultVariable = getResultVariable().trim();

        List<Map<String, Object> > results = null;

        if(resultVariable.length() > 0) {

            results = new ArrayList<Map<String,Object> >();

            jmvars.putObject(resultVariable, results);

        }

        int j = 0;

        while (rs.next()) {

            Map<String, Object> row = null;

            j++;

            for (int i = 1; i <= numColumns; i++) {

                Object o = rs.getObject(i);

                if(results != null) {

                    if(row == null) {

                        row = new HashMap<String, Object>(numColumns);

                        results.add(row);

                    }

                    row.put(meta.getColumnName(i), o);

                }

                if (o instanceof byte[]) {

                    o = new String((byte[]) o, ENCODING);

                }

                sb.append(o);

                if (i==numColumns){

                    sb.append('\n');

                } else {

                    sb.append('\t');

                }

                if (i <= varnames.length) { // i starts at 1

                    String name = varnames[i - 1].trim();

                    if (name.length()>0){ // Save the value in the variable if present

                        jmvars.put(name+UNDERSCORE+j, o == null ? null : o.toString());

                    }

                }

            }

        }

        // Remove any additional values from previous sample

        for(int i=0; i < varnames.length; i++){

            String name = varnames[i].trim();

            if (name.length()>0 && jmvars != null){

                final String varCount = name+"_#"; // $NON-NLS-1$

                // Get the previous count

                String prevCount = jmvars.get(varCount);

                if (prevCount != null){

                    int prev = Integer.parseInt(prevCount);

                    for (int n=j+1; n <= prev; n++ ){

                        jmvars.remove(name+UNDERSCORE+n);

                    }

                }

                jmvars.put(varCount, Integer.toString(j)); // save the current count

            }

        }

        return sb.toString();

    }

    public static void close(Connection c) {

        try {

            if (c != null) {

                c.close();

            }

        } catch (SQLException e) {

            log.warn("Error closing Connection", e);

        }

    }

    public static void close(Statement s) {

        try {

            if (s != null) {

                s.close();

            }

        } catch (SQLException e) {

            log.warn("Error closing Statement " + s.toString(), e);

        }

    }

    public static void close(ResultSet rs) {

        try {

            if (rs != null) {

                rs.close();

            }

        } catch (SQLException e) {

            log.warn("Error closing ResultSet", e);

        }

    }

    public String getQuery() {

        return query;

    }

    @Override

    public String toString() {

        StrBuilder sb = new StrBuilder(80);

        sb.append("["); // $NON-NLS-1$

        sb.append(getQueryType());

        sb.append("] "); // $NON-NLS-1$

        sb.append(getQuery());

        sb.append("\n");

        sb.append(getQueryArguments());

        sb.append("\n");

        sb.append(getQueryArgumentsTypes());

        return sb.toString();

    }

    /**

     * @param query

     *            The query to set.

     */

    public void setQuery(String query) {

        this.query = query;

    }

    /**

     * @return Returns the dataSource.

     */

    public String getDataSource() {

        return dataSource;

    }

    /**

     * @param dataSource

     *            The dataSource to set.

     */

    public void setDataSource(String dataSource) {

        this.dataSource = dataSource;

    }

    /**

     * @return Returns the queryType.

     */

    public String getQueryType() {

        return queryType;

    }

    /**

     * @param queryType The queryType to set.

     */

    public void setQueryType(String queryType) {

        this.queryType = queryType;

    }

    public String getQueryArguments() {

        return queryArguments;

    }

    public void setQueryArguments(String queryArguments) {

        this.queryArguments = queryArguments;

    }

    public String getQueryArgumentsTypes() {

        return queryArgumentsTypes;

    }

    public void setQueryArgumentsTypes(String queryArgumentsType) {

        this.queryArgumentsTypes = queryArgumentsType;

    }

    /**

     * @return the variableNames

     */

    public String getVariableNames() {

        return variableNames;

    }

    /**

     * @param variableNames the variableNames to set

     */

    public void setVariableNames(String variableNames) {

        this.variableNames = variableNames;

    }

    /**

     * @return the resultVariable

     */

    public String getResultVariable() {

        return resultVariable ;

    }

    /**

     * @param resultVariable the variable name in which results will be stored

     */

    public void setResultVariable(String resultVariable) {

        this.resultVariable = resultVariable;

    }

}

/*

 * Licensed to the Apache Software Foundation (ASF) under one or more

 * contributor license agreements.  See the NOTICE file distributed with

 * this work for additional information regarding copyright ownership.

 * The ASF licenses this file to You 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.

 *

 */

/*

 * Created on May 16, 2004

 *

 */

package org.apache.jmeter.protocol.jdbc;

import java.beans.PropertyDescriptor;

import org.apache.jmeter.testbeans.BeanInfoSupport;

import org.apache.jmeter.testbeans.gui.TextAreaEditor;

public abstract class JDBCBeanInfoSupport extends BeanInfoSupport {

    /**

     *

     */

    public JDBCBeanInfoSupport(Class<?> beanClass) {

        super(beanClass);

        createPropertyGroup("varName", // $NON-NLS-1$

                new String[]{"dataSource" }); // $NON-NLS-1$

        createPropertyGroup("diagnostics", // $NON-NLS-1$

                new String[] { "collectDiagnostics" }); // $NON-NLS-1$

        createPropertyGroup("sql", // $NON-NLS-1$

                new String[] {

                "queryType", // $NON-NLS-1$

                "query", // $NON-NLS-1$

                "queryArguments", // $NON-NLS-1$

                "queryArgumentsTypes", // $NON-NLS-1$

                "variableNames", // $NON-NLS-1$

                "resultVariable", // $NON-NLS-1$

                });

        PropertyDescriptor p = property("collectDiagnostics"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, Boolean.FALSE);

        p = property("dataSource"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, "");

        p = property("queryArguments"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, "");

        p = property("queryArgumentsTypes"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, "");

        p = property("variableNames"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, "");

        p = property("resultVariable"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, "");

        p = property("queryType"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, AbstractJdbcTestElement.SELECT);

        p.setValue(NOT_OTHER,Boolean.TRUE);

        p.setValue(TAGS,new String[]{

                AbstractJdbcTestElement.SELECT,

                AbstractJdbcTestElement.UPDATE,

                AbstractJdbcTestElement.CALLABLE,

                AbstractJdbcTestElement.PREPARED_SELECT,

                AbstractJdbcTestElement.PREPARED_UPDATE,

                AbstractJdbcTestElement.COMMIT,

                AbstractJdbcTestElement.ROLLBACK,

                AbstractJdbcTestElement.AUTOCOMMIT_FALSE,

                AbstractJdbcTestElement.AUTOCOMMIT_TRUE,

                });

        p = property("query"); // $NON-NLS-1$

        p.setValue(NOT_UNDEFINED, Boolean.TRUE);

        p.setValue(DEFAULT, "");

        p.setPropertyEditorClass(TextAreaEditor.class);

    }

}

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

displayName=JDBC Request

varName.displayName=Variable Name Bound to Pool

sql.displayName=SQL Query

query.displayName=Query

query.shortDescription=SQL Query to send to database

queryType.displayName=Query Type

queryType.shortDescription=Determines if the SQL statement should be run as a select statement or an update statement.

dataSource.displayName=Variable Name

dataSource.shortDescription=Name of the JMeter variable that the connection pool is bound to.

queryArguments.displayName=Parameter values

queryArguments.shortDescription=SQL parameter values (comma separated)

queryArgumentsTypes.displayName=Parameter types

queryArgumentsTypes.shortDescription=JDBC Type names from java.sql.Types. VARCHAR, INTEGER, etc. (comma separated)

variableNames.displayName=Variable names

variableNames.shortDescription=Output variable names for each column  (comma separated)

resultVariable.displayName=Result variable name

resultVariable.shortDescription=Name of the JMeter variable that stores the result set objects in a list of maps for looking up results by column name.

diagnostics.displayName=Diagnostics

collectDiagnostics.displayName=Collect diagnostic messages

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

#Stored by I18NEdit, may be edited!

dataSource.displayName=Nombre de Variable

dataSource.shortDescription=Nombre de la variable JMeter a la cual est\u00E1 ligado el pool de conexiones

query.displayName=Query

query.shortDescription=Query SQL a enviar a la base de datos

queryType.displayName=Solo Query

queryType.shortDescription=is true, se lanzar\u00E1 como una query y no como un update/inser. Si no, se lanza como update.

sql.displayName=Query SQL

varName.displayName=Nombre de Variable Ligada al Pool

queryArguments.displayName=Argumentos

queryArguments.shortDescription=los valores de los argumentos separados por comas

queryArgumentsTypes.displayName=Tipos de los argumentos

queryArgumentsTypes.shortDescription=los valores de los argumentos separados por comas

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

#Stored by I18NEdit, may be edited!

dataSource.displayName=Nom de liaison 

dataSource.shortDescription=Nom de la variable JMeter qui sera li\u00E9e au pool de connexion

query.displayName=Requ\u00EAte 

query.shortDescription=Requ\u00EAte SQL \u00E0 envoyer \u00E0 la base de donn\u00E9es

queryArguments.displayName=Valeurs des param\u00E8tres 

queryArguments.shortDescription=Valeurs des param\u00E8tres SQL

queryArgumentsTypes.displayName=Types des param\u00E8tres 

queryArgumentsTypes.shortDescription=Noms des types JDBC depuis java.sql.Types. Ex. VARCHAR, INTEGER, etc. (s\u00E9par\u00E9s par des virgules)

queryType.displayName=Type de requ\u00EAte 

queryType.shortDescription=D\u00E9termine si l'instruction SQL doit \u00EAtre ex\u00E9cut\u00E9e comme une commande SELECT ou une commande UPDATE.

resultVariable.displayName=Nom de la variable des R\u00E9sultats

resultVariable.shortDescription=Nom de la variable JMeter qui stocke les r\u00E9sultats sous forme d'objets dans une liste de type 'maps' permettant la recherche des r\u00E9sultats par nom de colonne.

sql.displayName=Requ\u00EAte SQL

varName.displayName=Nom de liaison avec le pool

variableNames.displayName=Noms des variables 

variableNames.shortDescription=Noms des variables en sortie pour chaque colonne (s\u00E9par\u00E9s par des virgules)

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

dataSource.displayName=Nome da Vari\u00E1vel

dataSource.shortDescription=Nome da vari\u00E1vel do JMeter que referencia o grupo de conex\u00F5es.

query.displayName=Consulta

query.shortDescription=Consulta SQL que ser\u00E1 enviada ao banco de dados

queryArguments.displayName=Valores dos par\u00E2metros

queryArguments.shortDescription=Valores dos par\u00E2metros do SQL (separados por v\u00EDrgula)

queryArgumentsTypes.displayName=Tipos dos par\u00E2metros

queryArgumentsTypes.shortDescription=Nomes dos tipos do JDBC de java.sql.Types. VARCHAR, INTEGER, etc. (separados por v\u00EDrgula)

queryType.displayName=Tipo da Consulta

queryType.shortDescription=Determina se a instru\u00E7\u00E3o SQL dever\u00E1 ser executada como uma instru\u00E7\u00E3o de consulta ou de atualiza\u00E7\u00E3o.

sql.displayName=Consulta SQL

varName.displayName=Nome da vari\u00E1vel que referencia o grupo de conex\u00F5es.

variableNames.displayName=Nomes das vari\u00E1veis

variableNames.shortDescription=Nomes das vari\u00E1veis de sa\u00EDda para cada coluna (separado por v\u00EDrgula)

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

#Stored by I18NEdit, may be edited!

dataSource.displayName=De\u011Fi\u015Fken \u0130smi

dataSource.shortDescription=Ba\u011Flant\u0131 havuzunun ili\u015Fkilendirilece\u011Fi JMeter de\u011Fi\u015Fkeninin ismi.

query.displayName=Sorgu

query.shortDescription=Veritaban\u0131na g\u00F6nderilecek SQL sorgusu

queryArguments.displayName=Parametre de\u011Ferleri

queryArguments.shortDescription=SQL parametresi de\u011Ferleri

queryArgumentsTypes.displayName=Parametre tipleri

queryArgumentsTypes.shortDescription=java.sql.Types'tan JDBC Tip isimleri. VARCHAR, INTEGER, gibi.

queryType.displayName=Sorgu Tipi

queryType.shortDescription=SQL ifadesinin select veya update ifadesi olarak \u00E7al\u0131\u015Ft\u0131r\u0131laca\u011F\u0131n\u0131 belirler.

sql.displayName=SQL Sorgusu

varName.displayName=Havuzla ili\u015Fkilendirilecek De\u011Fi\u015Fkenin \u0130smi

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

#Stored by I18NEdit, may be edited!

dataSource.displayName=\u8B8A\u6578\u540D\u7A31

dataSource.shortDescription=\u8CC7\u6599\u5EAB\u9023\u7DDA\u6C60\u8B8A\u6578\u540D\u7A31

query.displayName=\u67E5\u8A62

query.shortDescription=\u50B3\u9001\u7D66\u8CC7\u6599\u5EAB\u7684 SQL \u654D\u8FF0

sql.displayName=SQL \u654D\u8FF0

varName.displayName=\u8CC7\u6599\u5EAB\u9023\u7DDA\u6C60\u8B8A\u6578\u540D\u7A31

package org.apache.jmeter.protocol.jdbc.processor;

import java.io.IOException;

import java.sql.Connection;

import java.sql.SQLException;

import org.apache.jmeter.protocol.jdbc.AbstractJdbcTestElement;

import org.apache.jmeter.protocol.jdbc.config.DataSourceElement;

import org.apache.jorphan.logging.LoggingManager;

import org.apache.log.Logger;

/**

 * As pre- and post-processors essentially do the same this class provides the implmentation.

 */

public abstract class AbstractJDBCProcessor extends AbstractJdbcTestElement {

    private static final Logger log = LoggingManager.getLoggerForClass();

    private static final long serialVersionUID = 232L;

    /**

     * Calls the JDBC code to be executed.

     */

    protected void process() {

        Connection conn = null;

        try {

            conn = DataSourceElement.getConnection(getDataSource());

            execute(conn);

        } catch (SQLException ex) {

            log.warn("SQL Problem in  "+ getName() + ": " + ex.toString());

        } catch (IOException ex) {

            log.warn("IO Problem in  "+ getName() + ": " + ex.toString());

        } catch (UnsupportedOperationException ex) {

            log.warn("Execution Problem in "+ getName() + ": " + ex.toString());

        } finally {

            close(conn);

        }

    }

}

package org.apache.jmeter.protocol.jdbc.processor;

import org.apache.jmeter.processor.PostProcessor;

import org.apache.jmeter.testbeans.TestBean;

/**

 * Post processor handling JDBC Requests

 */

public class JDBCPostProcessor extends AbstractJDBCProcessor implements TestBean, PostProcessor {

    @Override

    public void process() {

        super.process();

    }

}

/*

 * Licensed to the Apache Software Foundation (ASF) under one or more

 * contributor license agreements.  See the NOTICE file distributed with

 * this work for additional information regarding copyright ownership.

 * The ASF licenses this file to You 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.

 *

 */

/*

 * Created on May 16, 2004

 *

 */

package org.apache.jmeter.protocol.jdbc.processor;

import org.apache.jmeter.protocol.jdbc.JDBCBeanInfoSupport;

public class JDBCPostProcessorBeanInfo extends JDBCBeanInfoSupport {

    /**

     *

     */

    public JDBCPostProcessorBeanInfo() {

        super(JDBCPostProcessor.class);

    }

}

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

displayName=JDBC PostProcessor Request

package org.apache.jmeter.protocol.jdbc.processor;

import org.apache.jmeter.processor.PreProcessor;

import org.apache.jmeter.testbeans.TestBean;

/**

 * Preprocessor handling JDBC Requests

 */

public class JDBCPreProcessor extends AbstractJDBCProcessor implements TestBean, PreProcessor {

    @Override

    public void process() {

        super.process();

    }

}

/*

 * Licensed to the Apache Software Foundation (ASF) under one or more

 * contributor license agreements.  See the NOTICE file distributed with

 * this work for additional information regarding copyright ownership.

 * The ASF licenses this file to You 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.

 *

 */

/*

 * Created on May 16, 2004

 *

 */

package org.apache.jmeter.protocol.jdbc.processor;

import org.apache.jmeter.protocol.jdbc.JDBCBeanInfoSupport;

public class JDBCPreProcessorBeanInfo extends JDBCBeanInfoSupport {

    /**

     *

     */

    public JDBCPreProcessorBeanInfo() {

        super(JDBCPreProcessor.class);

    }

}

#   Licensed to the Apache Software Foundation (ASF) under one or more

#   contributor license agreements.  See the NOTICE file distributed with

#   this work for additional information regarding copyright ownership.

#   The ASF licenses this file to You 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.

displayName=JDBC PreProcessor Request

            res.setResponseData(execute(conn));