/*
* JBoss, Home of Professional Open Source.
* See the COPYRIGHT.txt file distributed with this work for information
* regarding copyright ownership. Some portions may be licensed
* to Red Hat, Inc. under one or more contributor license agreements.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*/
package org.teiid.translator.jdbc;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.teiid.language.Argument;
import org.teiid.language.Call;
import org.teiid.language.Command;
import org.teiid.translator.DataNotAvailableException;
import org.teiid.translator.ExecutionContext;
import org.teiid.translator.ProcedureExecution;
import org.teiid.translator.TranslatorException;
/**
*/
public class JDBCProcedureExecution extends JDBCQueryExecution implements ProcedureExecution {
/**
* @param connection
* @param sqlTranslator
* @param logger
* @param props
* @param id
*/
public JDBCProcedureExecution(Command command, Connection connection, ExecutionContext context, JDBCExecutionFactory env) {
super(command, connection, context, env);
}
@Override
public void execute() throws TranslatorException {
Call procedure = (Call)command;
columnDataTypes = procedure.getResultSetColumnTypes();
//translate command
TranslatedCommand translatedComm = translateCommand(procedure);
//create statement or CallableStatement and execute
String sql = translatedComm.getSql();
try{
//create parameter index map
CallableStatement cstmt = getCallableStatement(sql);
this.results = this.executionFactory.executeStoredProcedure(cstmt, translatedComm.getPreparedValues(), procedure.getReturnType());
addStatementWarnings();
}catch(SQLException e){
throw new TranslatorException(JDBCPlugin.Event.TEIID11004, e, JDBCPlugin.Util.gs(JDBCPlugin.Event.TEIID11004, sql));
}
}
@Override
public List<?> next() throws TranslatorException, DataNotAvailableException {
if (results == null) {
return null;
}
return super.next();
}
@Override
public List<?> getOutputParameterValues() throws TranslatorException {
try {
Call proc = (Call)this.command;
List<Object> result = new ArrayList<Object>();
int paramIndex = 1;
if (proc.getReturnType() != null) {
if (proc.getReturnParameter() != null) {
addParameterValue(result, paramIndex, proc.getReturnType());
}
paramIndex++;
}
for (Argument parameter : proc.getArguments()) {
switch (parameter.getDirection()) {
case IN:
paramIndex++;
break;
case INOUT:
case OUT:
addParameterValue(result, paramIndex++, parameter.getType());
break;
}
}
return result;
} catch (SQLException e) {
throw new TranslatorException(JDBCPlugin.Event.TEIID11005, e);
}
}
private void addParameterValue(List<Object> result, int paramIndex,
Class<?> type) throws SQLException {
Object value = this.executionFactory.retrieveValue((CallableStatement)this.statement, paramIndex, type);
result.add(value);
}
}