/*****************************************************************
* 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.cayenne.dba.oracle;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import org.apache.cayenne.access.DataNode;
import org.apache.cayenne.access.OperationObserver;
import org.apache.cayenne.access.jdbc.SQLStatement;
import org.apache.cayenne.access.jdbc.SQLTemplateAction;
import org.apache.cayenne.query.SQLTemplate;
/**
* A SQLTemplateAction that addresses Oracle 8 driver limitations.
*
* @since 1.2
*/
class Oracle8SQLTemplateAction extends SQLTemplateAction {
Oracle8SQLTemplateAction(SQLTemplate query, DataNode dataNode) {
super(query, dataNode);
}
/**
* Overrides super implementation to guess whether the query is selecting or
* not and execute it appropriately. Super implementation relied on generic
* JDBC mechanism, common for selecting and updating statements that does
* not work in Oracle 8.* drivers.
*/
@Override
protected void execute(Connection connection, OperationObserver callback, SQLStatement compiled,
Collection updateCounts) throws SQLException, Exception {
String sql = compiled.getSql().trim();
boolean select = sql.length() > "SELECT".length()
&& sql.substring(0, "SELECT".length()).equalsIgnoreCase("SELECT");
long t1 = System.currentTimeMillis();
boolean iteratedResult = callback.isIteratedResult();
PreparedStatement statement = connection.prepareStatement(compiled.getSql());
try {
bind(statement, compiled.getBindings());
// start - code different from super
if (select) {
ResultSet resultSet = statement.executeQuery();
try {
processSelectResult(compiled, connection, statement, resultSet, callback, t1);
} finally {
if (!iteratedResult) {
resultSet.close();
}
}
} else {
int updateCount = statement.executeUpdate();
updateCounts.add(Integer.valueOf(updateCount));
dataNode.getJdbcEventLogger().logUpdateCount(updateCount);
}
// end - code different from super
} finally {
if (!iteratedResult) {
statement.close();
}
}
}
}