/*
Derby - Class org.apache.derby.impl.sql.execute.CallStatementResultSet
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.
*/
package org.apache.derby.impl.sql.execute;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.derby.iapi.error.StandardException;
import org.apache.derby.iapi.jdbc.ConnectionContext;
import org.apache.derby.iapi.services.loader.GeneratedMethod;
import org.apache.derby.iapi.sql.Activation;
import org.apache.derby.iapi.sql.conn.LanguageConnectionContext;
/**
* Call a Java procedure. This calls a generated method in the
* activation which sets up the parameters and then calls the
* Java method that the procedure resolved to.
* <P>
* Valid dynamic results returned by the procedure will be closed
* as inaccessible when this is closed (e.g. a CALL within a trigger).
*
* <BR>
* Any code that requires the dynamic results to be accessible
* (such as the JDBC Statement object executing the CALL) must
* obtain the dynamic results from Activation.getDynamicResults()
* and remove each ResultSet it will be handling by clearing the
* reference in the object returned.
*
* @see Activation#getDynamicResults()
*/
class CallStatementResultSet extends NoRowsResultSetImpl
{
private final GeneratedMethod methodCall;
/*
* class interface
*
*/
CallStatementResultSet(
GeneratedMethod methodCall,
Activation a)
{
super(a);
this.methodCall = methodCall;
}
/**
* Just invoke the method.
@exception StandardException Standard Derby error policy
*/
public void open() throws StandardException
{
setup();
methodCall.invoke(activation);
}
/**
* Need to explicitly close any dynamic result sets.
* <BR>
* If the dynamic results are not accessible then they
* need to be destroyed (ie. closed) according the the
* SQL Standard.
* <BR>
* An execution of a CALL statement through JDBC makes the
* dynamic results accessible, in this case the closing
* of the dynamic result sets is handled by the JDBC
* statement object (EmbedStatement) that executed the CALL.
* We cannot unify the closing of dynamic result sets to
* this close, as in accessible case it is called during
* the Statement.execute call, thus it would close the
* dynamic results before the application has a change
* to use them.
*
* <BR>
* With an execution of a CALL
* statement as a trigger's action statement the dynamic
* result sets are not accessible. In this case this close
* method is called after the execution of the trigger's
* action statement.
* <BR>
* <BR>
* Section 4.27.5 of the TECHNICAL CORRIGENDUM 1 to the SQL 2003
* Standard details what happens to dynamic result sets in detail,
* the SQL 2003 foundation document is missing these details.
*/
public void close() throws StandardException
{
super.close();
ResultSet[][] dynamicResults = getActivation().getDynamicResults();
if (dynamicResults != null)
{
// Need to ensure all the result sets opened by this
// CALL statement for this connection are closed.
// If any close() results in an exception we need to keep going,
// save any exceptions and then throw them once we are complete.
StandardException errorOnClose = null;
ConnectionContext jdbcContext = null;
for (int i = 0; i < dynamicResults.length; i++)
{
ResultSet[] param = dynamicResults[i];
ResultSet drs = param[0];
// Can be null if the procedure never set this parameter
// or if the dynamic results were processed by JDBC (EmbedStatement).
if (drs == null)
continue;
if (jdbcContext == null)
jdbcContext = (ConnectionContext)
lcc.getContextManager().getContext(ConnectionContext.CONTEXT_ID);
try {
// Is this a valid, open dynamic result set for this connection?
if (!jdbcContext.processInaccessibleDynamicResult(drs))
{
// If not just ignore it, not Derby's problem.
continue;
}
drs.close();
} catch (SQLException e) {
// Just report the first error
if (errorOnClose == null)
{
StandardException se = StandardException.plainWrapException(e);
errorOnClose = se;
}
}
finally {
// Remove any reference to the ResultSet to allow
// it and any associated resources to be garbage collected.
param[0] = null;
}
}
if (errorOnClose != null)
throw errorOnClose;
}
}
/**
* @see org.apache.derby.iapi.sql.ResultSet#cleanUp
*/
public void cleanUp() throws StandardException
{
close();
}
}