public StoredProcedureInfo getStoredProcedureInfoForProcedure( String fullyQualifiedProcedureName) throws TeiidComponentException, QueryMetadataException { return actualMetadata .getStoredProcedureInfoForProcedure(fullyQualifiedProcedureName); }
public StoredProcedureInfo getStoredProcedureInfoForProcedure( String fullyQualifiedProcedureName) throws TeiidComponentException, QueryMetadataException { return actualMetadata .getStoredProcedureInfoForProcedure(fullyQualifiedProcedureName); }
public StoredProcedureInfo getStoredProcedureInfoForProcedure( String fullyQualifiedProcedureName) throws TeiidComponentException, QueryMetadataException { return actualMetadata .getStoredProcedureInfoForProcedure(fullyQualifiedProcedureName); }
@Override public Procedure getProcedure(String fullName) throws TranslatorException { try { StoredProcedureInfo sp = metadata.getStoredProcedureInfoForProcedure(fullName); return getProcedure(sp); } catch (QueryMetadataException e) { throw new TranslatorException(QueryPlugin.Event.TEIID30468, e); } catch (TeiidComponentException e) { throw new TranslatorException(QueryPlugin.Event.TEIID30469, e); } }
@Override public Procedure getProcedure(String fullName) throws TranslatorException { try { StoredProcedureInfo sp = metadata.getStoredProcedureInfoForProcedure(fullName); return getProcedure(sp); } catch (QueryMetadataException e) { throw new TranslatorException(QueryPlugin.Event.TEIID30468, e); } catch (TeiidComponentException e) { throw new TranslatorException(QueryPlugin.Event.TEIID30469, e); } }
@Override public Procedure getProcedure(String fullName) throws TranslatorException { try { StoredProcedureInfo sp = metadata.getStoredProcedureInfoForProcedure(fullName); return getProcedure(sp); } catch (QueryMetadataException e) { throw new TranslatorException(QueryPlugin.Event.TEIID30468, e); } catch (TeiidComponentException e) { throw new TranslatorException(QueryPlugin.Event.TEIID30469, e); } }
/** * @throws QueryResolverException * @see org.teiid.query.resolver.ProcedureContainerResolver#getPlan(org.teiid.query.metadata.QueryMetadataInterface, org.teiid.query.sql.symbol.GroupSymbol) */ protected String getPlan(QueryMetadataInterface metadata, GroupSymbol group) throws TeiidComponentException, QueryMetadataException, QueryResolverException { StoredProcedureInfo storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(group.getName()); //if there is a query plan associated with the procedure, get it. QueryNode plan = storedProcedureInfo.getQueryPlan(); if (plan.getQuery() == null) { throw new QueryResolverException(QueryPlugin.Event.TEIID30146, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30146, group)); } return plan.getQuery(); } }
public static void sampleData1(FakeDataManager dataMgr, QueryMetadataInterface metadata) throws TeiidException { addTable("pm1.g1", dataMgr, metadata); addTable("pm1.g2", dataMgr, metadata); addTable("pm1.g3", dataMgr, metadata); addTable("pm2.g1", dataMgr, metadata); addTable("pm2.g2", dataMgr, metadata); addTable("pm2.g3", dataMgr, metadata); //addTable("tm1.g1", dataMgr, metadata); //stored procedure pm1.sp1 StoredProcedureInfo procInfo = metadata.getStoredProcedureInfoForProcedure("pm1.sp1"); //$NON-NLS-1$ dataMgr.registerProcTuples( procInfo.getProcedureCallableName().toUpperCase(), new List[] { Arrays.asList(new Object[] { "a", new Integer(0) }), //$NON-NLS-1$ Arrays.asList(new Object[] { null, new Integer(1)}), Arrays.asList(new Object[] { "a", new Integer(3) }), //$NON-NLS-1$ Arrays.asList(new Object[] { "c", new Integer(1)}), //$NON-NLS-1$ Arrays.asList(new Object[] { "b", new Integer(2)}), //$NON-NLS-1$ Arrays.asList(new Object[] { "a", new Integer(0) }) //$NON-NLS-1$ } ); }
/** * @throws QueryResolverException * @see org.teiid.query.resolver.ProcedureContainerResolver#getPlan(org.teiid.query.metadata.QueryMetadataInterface, org.teiid.query.sql.symbol.GroupSymbol) */ protected String getPlan(QueryMetadataInterface metadata, GroupSymbol group) throws TeiidComponentException, QueryMetadataException, QueryResolverException { StoredProcedureInfo storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(group.getName()); //if there is a query plan associated with the procedure, get it. QueryNode plan = storedProcedureInfo.getQueryPlan(); if (plan.getQuery() == null) { throw new QueryResolverException(QueryPlugin.Event.TEIID30146, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30146, group)); } return plan.getQuery(); } }
/** * @throws QueryResolverException * @see org.teiid.query.resolver.ProcedureContainerResolver#getPlan(org.teiid.query.metadata.QueryMetadataInterface, org.teiid.query.sql.symbol.GroupSymbol) */ protected String getPlan(QueryMetadataInterface metadata, GroupSymbol group) throws TeiidComponentException, QueryMetadataException, QueryResolverException { StoredProcedureInfo storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(group.getName()); //if there is a query plan associated with the procedure, get it. QueryNode plan = storedProcedureInfo.getQueryPlan(); if (plan.getQuery() == null) { throw new QueryResolverException(QueryPlugin.Event.TEIID30146, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30146, group)); } return plan.getQuery(); } }
storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(storedProcedureCommand.getProcedureName()); } catch (QueryMetadataException e) { String[] parts = storedProcedureCommand.getProcedureName().split("\\.", 2); //$NON-NLS-1$ if (parts.length > 1 && parts[0].equalsIgnoreCase(metadata.getVirtualDatabaseName())) { try { storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(parts[1]); storedProcedureCommand.setProcedureName(parts[1]); } catch(QueryMetadataException e1) {
cupc.setVirtualGroup(container); if (type == Command.TYPE_STORED_PROCEDURE) { StoredProcedureInfo info = metadata.getStoredProcedureInfoForProcedure(container.getName());
StoredProcedureInfo storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(potentialID); symbol.setProcedure(true); groupID = storedProcedureInfo.getProcedureID();
StoredProcedureInfo storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(potentialID); symbol.setProcedure(true); groupID = storedProcedureInfo.getProcedureID();
StoredProcedureInfo storedProcedureInfo = metadata.getStoredProcedureInfoForProcedure(potentialID); symbol.setProcedure(true); groupID = storedProcedureInfo.getProcedureID();
cupc.setVirtualGroup(container); if (type == Command.TYPE_STORED_PROCEDURE) { StoredProcedureInfo info = metadata.getStoredProcedureInfoForProcedure(container.getName());
cupc.setVirtualGroup(container); if (type == Command.TYPE_STORED_PROCEDURE) { StoredProcedureInfo info = metadata.getStoredProcedureInfoForProcedure(container.getName());
@Override public void visit(AlterProcedure obj) { GroupSymbol gs = obj.getTarget(); validateAlterTarget(obj); try { if (!gs.isProcedure() || !getMetadata().isVirtualModel(getMetadata().getModelID(gs.getMetadataID()))) { handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.not_a_procedure", gs), gs); //$NON-NLS-1$ return; } Validator.validate(obj.getDefinition(), getMetadata(), this); StoredProcedureInfo info = getMetadata().getStoredProcedureInfoForProcedure(gs.getName()); for (SPParameter param : info.getParameters()) { if (param.getParameterType() == SPParameter.RESULT_SET) { QueryResolver.validateProjectedSymbols(gs, param.getResultSetColumns(), obj.getDefinition().getProjectedSymbols()); break; } } } catch (QueryValidatorException e) { handleValidationError(e.getMessage(), obj.getDefinition().getBlock()); } catch (TeiidComponentException e) { handleException(e); } }
@Override public void visit(AlterProcedure obj) { GroupSymbol gs = obj.getTarget(); try { validateAlterTarget(obj); if (!gs.isProcedure() || !getMetadata().isVirtualModel(getMetadata().getModelID(gs.getMetadataID()))) { handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.not_a_procedure", gs), gs); //$NON-NLS-1$ return; } Validator.validate(obj.getDefinition(), getMetadata(), this); StoredProcedureInfo info = getMetadata().getStoredProcedureInfoForProcedure(gs.getName()); for (SPParameter param : info.getParameters()) { if (param.getParameterType() == SPParameter.RESULT_SET) { QueryResolver.validateProjectedSymbols(gs, param.getResultSetColumns(), obj.getDefinition().getProjectedSymbols()); break; } } } catch (QueryValidatorException e) { handleValidationError(e.getMessage(), obj.getDefinition().getBlock()); } catch (TeiidComponentException e) { handleException(e); } }
@Override public void visit(AlterProcedure obj) { GroupSymbol gs = obj.getTarget(); try { validateAlterTarget(obj); if (!gs.isProcedure() || !getMetadata().isVirtualModel(getMetadata().getModelID(gs.getMetadataID()))) { handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.not_a_procedure", gs), gs); //$NON-NLS-1$ return; } Validator.validate(obj.getDefinition(), getMetadata(), this); StoredProcedureInfo info = getMetadata().getStoredProcedureInfoForProcedure(gs.getName()); for (SPParameter param : info.getParameters()) { if (param.getParameterType() == SPParameter.RESULT_SET) { QueryResolver.validateProjectedSymbols(gs, param.getResultSetColumns(), obj.getDefinition().getProjectedSymbols()); break; } } } catch (QueryValidatorException e) { handleValidationError(e.getMessage(), obj.getDefinition().getBlock()); } catch (TeiidComponentException e) { handleException(e); } }