protected void cancelExecution() throws OntopQueryEvaluationException { try { sqlStatement.cancel(); } catch (SQLException e) { throw new OntopQueryEvaluationException(e); } }
protected void cancelExecution() throws OntopQueryEvaluationException { try { sqlStatement.cancel(); } catch (SQLException e) { throw new OntopQueryEvaluationException(e); } }
/** * Returns the number of tuples returned by the query */ @Override public int getTupleCount(InputQuery inputQuery) throws OntopReformulationException, OntopQueryEvaluationException { SQLExecutableQuery targetQuery = checkAndConvertTargetQuery(getExecutableQuery(inputQuery)); String sql = targetQuery.getSQL(); String newsql = "SELECT count(*) FROM (" + sql + ") t1"; if (!isCanceled()) { try { java.sql.ResultSet set = sqlStatement.executeQuery(newsql); if (set.next()) { return set.getInt(1); } else { //throw new OBDAException("Tuple count failed due to empty result set."); return 0; } } catch (SQLException e) { throw new OntopQueryEvaluationException(e); } } else { throw new OntopQueryEvaluationException("Action canceled."); } }
/** * Returns the number of tuples returned by the query */ @Override public int getTupleCount(InputQuery inputQuery) throws OntopReformulationException, OntopQueryEvaluationException { SQLExecutableQuery targetQuery = checkAndConvertTargetQuery(getExecutableQuery(inputQuery)); String sql = targetQuery.getSQL(); String newsql = "SELECT count(*) FROM (" + sql + ") t1"; if (!isCanceled()) { try { java.sql.ResultSet set = sqlStatement.executeQuery(newsql); if (set.next()) { return set.getInt(1); } else { //throw new OBDAException("Tuple count failed due to empty result set."); return 0; } } catch (SQLException e) { throw new OntopQueryEvaluationException(e); } } else { throw new OntopQueryEvaluationException("Action canceled."); } }
@Override protected BooleanResultSet executeBooleanQuery(ExecutableQuery executableQuery) throws OntopQueryEvaluationException { SQLExecutableQuery sqlTargetQuery = checkAndConvertTargetQuery(executableQuery); String sqlQuery = sqlTargetQuery.getSQL(); if (sqlQuery.equals("")) { return new PredefinedBooleanResultSet(false); } try { java.sql.ResultSet set = sqlStatement.executeQuery(sqlQuery); return new SQLBooleanResultSet(set); } catch (SQLException e) { throw new OntopQueryEvaluationException(e.getMessage()); } }
@Override protected BooleanResultSet executeBooleanQuery(ExecutableQuery executableQuery) throws OntopQueryEvaluationException { SQLExecutableQuery sqlTargetQuery = checkAndConvertTargetQuery(executableQuery); String sqlQuery = sqlTargetQuery.getSQL(); if (sqlQuery.equals("")) { return new PredefinedBooleanResultSet(false); } try { java.sql.ResultSet set = sqlStatement.executeQuery(sqlQuery); return new SQLBooleanResultSet(set); } catch (SQLException e) { throw new OntopQueryEvaluationException(e.getMessage()); } }
throw new OntopQueryEvaluationException(ex); throw new OntopQueryEvaluationException("Query execution was cancelled");
@Override protected SimpleGraphResultSet executeGraphQuery(ConstructQuery inputQuery, ExecutableQuery executableQuery, boolean collectResults) throws OntopQueryEvaluationException, OntopResultConversionException, OntopConnectionException { SQLExecutableQuery sqlTargetQuery = checkAndConvertTargetQuery(executableQuery); String sqlQuery = sqlTargetQuery.getSQL(); TupleResultSet tuples; if (sqlQuery.equals("") ) { tuples = new EmptyTupleResultSet(executableQuery.getSignature()); } else { try { ResultSet set = sqlStatement.executeQuery(sqlQuery); tuples = new DelegatedIriSQLTupleResultSet(set, executableQuery.getSignature(), dbMetadata, iriDictionary, termFactory, typeFactory, rdfFactory); } catch (SQLException e) { throw new OntopQueryEvaluationException(e.getMessage()); } } return new DefaultSimpleGraphResultSet(tuples, inputQuery.getConstructTemplate(), collectResults, termFactory, rdfFactory); }
@Override protected SimpleGraphResultSet executeGraphQuery(ConstructQuery inputQuery, ExecutableQuery executableQuery, boolean collectResults) throws OntopQueryEvaluationException, OntopResultConversionException, OntopConnectionException { SQLExecutableQuery sqlTargetQuery = checkAndConvertTargetQuery(executableQuery); String sqlQuery = sqlTargetQuery.getSQL(); TupleResultSet tuples; if (sqlQuery.equals("") ) { tuples = new EmptyTupleResultSet(executableQuery.getSignature()); } else { try { ResultSet set = sqlStatement.executeQuery(sqlQuery); tuples = new DelegatedIriSQLTupleResultSet(set, executableQuery.getSignature(), dbMetadata, iriDictionary); } catch (SQLException e) { throw new OntopQueryEvaluationException(e.getMessage()); } } return new DefaultSimpleGraphResultSet(tuples, inputQuery.getConstructTemplate(), collectResults); }
@Override protected TupleResultSet executeSelectQuery(ExecutableQuery executableQuery) throws OntopQueryEvaluationException { SQLExecutableQuery sqlTargetQuery = checkAndConvertTargetQuery(executableQuery); String sqlQuery = sqlTargetQuery.getSQL(); if (sqlQuery.equals("") ) { return new EmptyTupleResultSet(executableQuery.getSignature()); } try { java.sql.ResultSet set = sqlStatement.executeQuery(sqlQuery); return settings.isDistinctPostProcessingEnabled() ? new SQLDistinctTupleResultSet(set, executableQuery.getSignature(), dbMetadata, iriDictionary) : new DelegatedIriSQLTupleResultSet(set, executableQuery.getSignature(), dbMetadata, iriDictionary); } catch (SQLException e) { throw new OntopQueryEvaluationException(e); } }
@Override protected TupleResultSet executeSelectQuery(ExecutableQuery executableQuery) throws OntopQueryEvaluationException { SQLExecutableQuery sqlTargetQuery = checkAndConvertTargetQuery(executableQuery); String sqlQuery = sqlTargetQuery.getSQL(); if (sqlQuery.equals("") ) { return new EmptyTupleResultSet(executableQuery.getSignature()); } try { java.sql.ResultSet set = sqlStatement.executeQuery(sqlQuery); return settings.isDistinctPostProcessingEnabled() ? new SQLDistinctTupleResultSet(set, executableQuery.getSignature(), dbMetadata, iriDictionary, termFactory, typeFactory, rdfFactory) : new DelegatedIriSQLTupleResultSet(set, executableQuery.getSignature(), dbMetadata, iriDictionary, termFactory, typeFactory, rdfFactory); } catch (SQLException e) { throw new OntopQueryEvaluationException(e); } }