[teiid-commits] teiid SVN: r3214 - in branches/7.4.x: engine/src/main/java/org/teiid/query/metadata and 12 other directories.

Author: shawkins Date: 2011-06-03 15:07:41 -0400 (Fri, 03 Jun 2011) New Revision: 3214 Added: branches/7.4.x/test-integration/common/src/test/java/org/teiid/dqp/internal/process/TestRelate.java branches/7.4.x/test-integration/common/src/test/resources/relate/ branches/7.4.x/test-integration/common/src/test/resources/relate/VehicleRentalsVDB.vdb branches/7.4.x/test-integration/common/src/test/resources/relate/rentals.sql branches/7.4.x/test-integration/common/src/test/resources/relate/test.h2.db branches/7.4.x/test-integration/common/src/test/resources/relate/test.trace.db branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_compoundCritNestedTgt.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_crit.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrc.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcCombinationContext.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcContext.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedTgt.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDoc.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocEspaceQuestion3.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgt.expected branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgtContext.expected Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/MappingVisitor.java branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/ResultSetInfo.java branches/7.4.x/engine/src/main/java/org/teiid/query/metadata/TempMetadataAdapter.java branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/CriteriaPlanner.java branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLNodeMappingVisitor.java branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLPlanToProcessVisitor.java branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLProjectionMinimizer.java branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLQueryPlanner.java branches/7.4.x/engine/src/main/java/org/teiid/query/processor/xml/XMLContext.java branches/7.4.x/engine/src/main/java/org/teiid/query/resolver/command/XMLQueryResolver.java branches/7.4.x/engine/src/main/java/org/teiid/query/rewriter/QueryRewriter.java branches/7.4.x/engine/src/main/java/org/teiid/query/sql/visitor/PredicateCollectorVisitor.java branches/7.4.x/engine/src/main/resources/org/teiid/query/i18n.properties branches/7.4.x/engine/src/test/java/org/teiid/query/processor/xml/TestXMLProcessor.java branches/7.4.x/test-integration/common/pom.xml branches/7.4.x/test-integration/common/src/test/java/org/teiid/jdbc/FakeServer.java Log: TEIID-1615 Adding a rough relate implementation and refining the handling of xml subqueries Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/MappingVisitor.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/MappingVisitor.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/MappingVisitor.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -40,6 +40,9 @@ return abort; } + /** + * @param node + */ public void visit(MappingNode node) {} public void visit(MappingDocument doc) { @@ -80,14 +83,14 @@ */ protected void walkChildNodes(MappingNode element) { - List children = element.getNodeChildren(); - for(Iterator i=children.iterator(); i.hasNext();) { + List<MappingNode> children = element.getNodeChildren(); + for(Iterator<MappingNode> i=children.iterator(); i.hasNext();) { if (shouldAbort()) { break; } - MappingNode node = (MappingNode)i.next(); + MappingNode node = i.next(); node.acceptVisitor(this); } } Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/ResultSetInfo.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/ResultSetInfo.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/mapping/xml/ResultSetInfo.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -57,7 +57,7 @@ private Criteria criteria; - private Set criteriaResultSets = new HashSet(); + private Set<MappingSourceNode> criteriaResultSets = new HashSet<MappingSourceNode>(); private boolean criteriaRaised = false; @@ -125,11 +125,11 @@ this.orderBy = orderBy; } - public Set getCriteriaResultSets() { + public Set<MappingSourceNode> getCriteriaResultSets() { return this.criteriaResultSets; } - public void addToCriteriaResultSets(Set criteriaResultSets) { + public void addToCriteriaResultSets(Set<MappingSourceNode> criteriaResultSets) { this.criteriaResultSets.addAll(criteriaResultSets); } Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/metadata/TempMetadataAdapter.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/metadata/TempMetadataAdapter.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/metadata/TempMetadataAdapter.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -37,6 +37,7 @@ import org.teiid.query.QueryPlugin; import org.teiid.query.mapping.relational.QueryNode; import org.teiid.query.mapping.xml.MappingNode; +import org.teiid.query.metadata.TempMetadataID.Type; /** @@ -497,7 +498,7 @@ throws TeiidComponentException, QueryMetadataException { if(groupID instanceof TempMetadataID) { - return false; + return ((TempMetadataID)groupID).getMetadataType() == Type.XML; } return this.actualMetadata.isXMLGroup(groupID); } Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/CriteriaPlanner.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/CriteriaPlanner.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/CriteriaPlanner.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -101,7 +101,7 @@ context = planEnv.mappingDoc; } - Set<MappingNode> sourceNodes = collectSourceNodesInConjunct(conjunct, context, planEnv.mappingDoc); + Set<MappingSourceNode> sourceNodes = collectSourceNodesInConjunct(conjunct, context, planEnv.mappingDoc); //TODO: this can be replaced with method on the source node? MappingSourceNode criteriaRs = findRootResultSetNode(context, sourceNodes, criteria); @@ -117,11 +117,11 @@ /** * This method collects all the MappingSourceNode(s) at or below the context given. */ - private static Set<MappingNode> collectSourceNodesInConjunct(Criteria conjunct, MappingNode context, MappingDocument mappingDoc) + private static Set<MappingSourceNode> collectSourceNodesInConjunct(Criteria conjunct, MappingNode context, MappingDocument mappingDoc) throws QueryPlannerException { Collection<ElementSymbol> elements = ElementCollectorVisitor.getElements(conjunct, true); - Set<MappingNode> resultSets = new HashSet<MappingNode>(); + Set<MappingSourceNode> resultSets = new HashSet<MappingSourceNode>(); String contextFullName = context.getFullyQualifiedName().toUpperCase(); @@ -131,7 +131,7 @@ MappingNode node = MappingNode.findNode(mappingDoc, elementFullName); - MappingNode elementRsNode = node.getSourceNode(); + MappingSourceNode elementRsNode = node.getSourceNode(); if (elementRsNode == null) { throw new QueryPlannerException(QueryPlugin.Util.getString("CriteriaPlanner.invalid_element", elementSymbol)); //$NON-NLS-1$ } @@ -155,7 +155,7 @@ return resultSets; } - private static MappingSourceNode findRootResultSetNode(MappingNode context, Set<MappingNode> resultSets, Criteria criteria) + private static MappingSourceNode findRootResultSetNode(MappingNode context, Set<MappingSourceNode> resultSets, Criteria criteria) throws QueryPlannerException { if (context instanceof MappingSourceNode) { Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLNodeMappingVisitor.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLNodeMappingVisitor.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLNodeMappingVisitor.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -33,8 +33,6 @@ import org.teiid.query.mapping.xml.MappingNode; import org.teiid.query.mapping.xml.MappingSourceNode; import org.teiid.query.metadata.QueryMetadataInterface; -import org.teiid.query.metadata.TempMetadataID; -import org.teiid.query.resolver.util.ResolverVisitor; import org.teiid.query.sql.LanguageObject; import org.teiid.query.sql.lang.Criteria; import org.teiid.query.sql.navigator.PreOrPostOrderNavigator; @@ -63,6 +61,11 @@ this.metadata = metadata; } + @Override + protected boolean createAliases() { + return false; //xml style selects do not have aliases + } + /** * @see AbstractSymbolMappingVisitor#getMappedSymbol(Symbol) */ @@ -80,7 +83,7 @@ groupId = element.getGroupSymbol().getMetadataID(); } boolean xml = metadata.isXMLGroup(groupId); - if (!xml && !((groupId instanceof TempMetadataID) && ((TempMetadataID)groupId).getMetadataType() == TempMetadataID.Type.XML)) { + if (!xml) { return symbol; } String path = metadata.getFullName(metadataId).toUpperCase(); @@ -96,9 +99,6 @@ } if (symbol instanceof GroupSymbol) { GroupSymbol gs = msn.getMappedSymbol(new GroupSymbol(msn.getResultName())); - if (!xml && gs.getMetadataID() == null) { - ResolverVisitor.resolveLanguageObject(gs, metadata); - } return gs; } // Construct a new element node based on mapping node reference @@ -107,14 +107,6 @@ return null; } ElementSymbol es = msn.getMappedSymbol(new ElementSymbol(symbolName)); - if (!xml) { - if (((ElementSymbol)symbol).isExternalReference()) { - es.setIsExternalReference(true); - } - if (es.getMetadataID() == null) { - ResolverVisitor.resolveLanguageObject(es, metadata); - } - } return es; } catch (TeiidException err) { throw new TeiidRuntimeException(err); @@ -140,7 +132,7 @@ //Don't want to do deep visiting XMLNodeMappingVisitor mappingVisitor = new XMLNodeMappingVisitor(rootNode, metadata); try { - PreOrPostOrderNavigator.doVisit(object, mappingVisitor, PreOrPostOrderNavigator.PRE_ORDER, deep); + PreOrPostOrderNavigator.doVisit(object, mappingVisitor, PreOrPostOrderNavigator.POST_ORDER, deep); } catch (TeiidRuntimeException e) { Throwable child = e.getChild(); Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLPlanToProcessVisitor.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLPlanToProcessVisitor.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLPlanToProcessVisitor.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -67,7 +67,7 @@ */ public class XMLPlanToProcessVisitor implements MappingInterceptor { - Stack programStack = new Stack(); + Stack<Program> programStack = new Stack<Program>(); XMLPlannerEnvironment planEnv; Program originalProgram ; Program cleanupProgram = new Program(); @@ -83,14 +83,14 @@ public void end(MappingDocument doc, Map context) { // remove the current program from the stack; we no longer need this - originalProgram=(Program)this.programStack.pop(); + originalProgram=this.programStack.pop(); // cleanup program will have instructions to unload the staging table. originalProgram.addInstructions(cleanupProgram); } public void start(MappingAttribute attribute, Map context){ - Program currentProgram = (Program)this.programStack.peek(); + Program currentProgram = this.programStack.peek(); ProcessorInstruction tagInst = TagBuilderVisitor.buildTag(attribute); if (tagInst != null) { currentProgram.addInstruction(tagInst); @@ -101,7 +101,7 @@ } public void start(MappingCommentNode comment, Map context){ - Program currentProgram = (Program)this.programStack.peek(); + Program currentProgram = this.programStack.peek(); ProcessorInstruction tagInst = TagBuilderVisitor.buildTag(comment); if (tagInst != null) { currentProgram.addInstruction(tagInst); @@ -136,7 +136,7 @@ // process the node as others (if see we have not done anything for this node yet..) commonStart(choice, context); - Program currentProgram = (Program)this.programStack.peek(); + Program currentProgram = this.programStack.peek(); currentProgram.addInstruction(ifInst); } @@ -195,10 +195,10 @@ private void endRootRecursive(MappingBaseNode node, Map context) { // add the recursive program to the main program. - Program recursiveProgram = (Program)programStack.pop(); + Program recursiveProgram = programStack.pop(); // this is the main program - Program currentProgram = (Program)this.programStack.peek(); + Program currentProgram = this.programStack.peek(); currentProgram.addInstructions(recursiveProgram); context.remove(node.getRecursionId()); @@ -213,7 +213,7 @@ public void start(MappingElement element, Map context){ //commonStart(element, context); - Program currentProgram = (Program)programStack.peek(); + Program currentProgram = programStack.peek(); // if we are dealing with multiple documents startFragment(currentProgram, element); @@ -226,13 +226,13 @@ // If there are more children under this node move the cursor down if (!element.getChildren().isEmpty()) { // update the program pointer - currentProgram = (Program)programStack.peek(); + currentProgram = programStack.peek(); currentProgram.addInstruction(new MoveDocInstruction(MoveDocInstruction.DOWN)); } } public void end(MappingElement element, Map context){ - Program currentProgram = (Program)this.programStack.peek(); + Program currentProgram = this.programStack.peek(); // If there were more children under this node move the cursor up if (!element.getChildren().isEmpty()) { @@ -242,14 +242,14 @@ commonEnd(element, context); // update the program pointer - currentProgram = (Program)programStack.peek(); + currentProgram = programStack.peek(); // if we are dealing with multiple documents endFragment(currentProgram, element); } public void start(MappingSourceNode node, Map context) { - Program currentProgram = (Program)programStack.peek(); + Program currentProgram = programStack.peek(); commonStart(node, context); @@ -286,7 +286,7 @@ } public void end(MappingSourceNode node, Map context) { - Program currentProgram = (Program)programStack.peek(); + Program currentProgram = programStack.peek(); String source = node.getActualResultSetName(); ResultSetInfo info= node.getResultSetInfo(); @@ -328,7 +328,7 @@ List<String> stagingTables = node.getStagingTables(); for (String table : stagingTables) { - Program currentProgram = (Program)programStack.peek(); + Program currentProgram = programStack.peek(); // load staging currentProgram.addInstruction(new ExecStagingTableInstruction(table, planEnv.getStagingTableResultsInfo(table))); @@ -347,7 +347,7 @@ } public void start(final MappingRecursiveElement element, Map context){ - Program currentProgram = (Program)programStack.peek(); + Program currentProgram = programStack.peek(); // if we are dealing with multiple documents startFragment(currentProgram, element); @@ -367,7 +367,7 @@ } public void end(final MappingRecursiveElement element, Map context){ - Program currentProgram = (Program)programStack.peek(); + Program currentProgram = programStack.peek(); // if we are dealing with multiple documents endFragment(currentProgram, element); Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLProjectionMinimizer.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLProjectionMinimizer.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLProjectionMinimizer.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -101,13 +101,13 @@ Collection<ElementSymbol> bindings = QueryUtil.getBindingElements(node); MappingSourceNode parent = element.getParentSourceNode(); - parent = collectElementSymbols(element, bindings, parent); + collectElementSymbols(element, bindings, parent); } catch (TeiidException e) { throw new TeiidRuntimeException(e); } } - private MappingSourceNode collectElementSymbols( + private void collectElementSymbols( MappingSourceNode element, Collection<ElementSymbol> bindings, MappingSourceNode parent) { for (ElementSymbol elementSymbol : bindings) { @@ -122,7 +122,6 @@ parent = parent.getParentSourceNode(); } } - return parent; } @Override Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLQueryPlanner.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLQueryPlanner.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/optimizer/xml/XMLQueryPlanner.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -68,18 +68,39 @@ import org.teiid.query.sql.lang.Limit; import org.teiid.query.sql.lang.Query; import org.teiid.query.sql.lang.QueryCommand; +import org.teiid.query.sql.lang.SubqueryContainer; import org.teiid.query.sql.lang.SubqueryFromClause; import org.teiid.query.sql.lang.UnaryFromClause; import org.teiid.query.sql.symbol.Constant; import org.teiid.query.sql.symbol.ElementSymbol; import org.teiid.query.sql.symbol.GroupSymbol; import org.teiid.query.sql.symbol.Reference; +import org.teiid.query.sql.visitor.ElementCollectorVisitor; +import org.teiid.query.sql.visitor.GroupsUsedByElementsVisitor; +import org.teiid.query.sql.visitor.PredicateCollectorVisitor; import org.teiid.query.sql.visitor.StaticSymbolMappingVisitor; public class XMLQueryPlanner { - static void prePlanQueries(MappingDocument doc, final XMLPlannerEnvironment planEnv) + private static final class MappingSourceNodeFinder extends MappingVisitor { + private final GroupSymbol gs; + MappingSourceNode msn; + + private MappingSourceNodeFinder(GroupSymbol gs) { + this.gs = gs; + } + + @Override + public void visit(MappingSourceNode element) { + if (element.getAliasResultName() == null && element.getResultSetInfo().getResultSetName().equalsIgnoreCase(gs.getNonCorrelationName())) { + msn = element; + setAbort(true); + } + } + } + + static void prePlanQueries(MappingDocument doc, final XMLPlannerEnvironment planEnv) throws QueryPlannerException, QueryMetadataException, TeiidComponentException { MappingVisitor queryPlanVisitor = new MappingVisitor() { @@ -221,12 +242,12 @@ /** * The Criteria Source nodes are source nodes underneath the context Node. */ - private static boolean getResultSets(MappingSourceNode contextNode, Set criteriaSourceNodes, LinkedHashSet<MappingSourceNode> allResultSets) { + private static boolean getResultSets(MappingSourceNode contextNode, Set<MappingSourceNode> criteriaSourceNodes, LinkedHashSet<MappingSourceNode> allResultSets) { boolean singleParentage = true; - for (Iterator i = criteriaSourceNodes.iterator(); i.hasNext();) { - MappingSourceNode node = (MappingSourceNode)i.next(); + for (Iterator<MappingSourceNode> i = criteriaSourceNodes.iterator(); i.hasNext();) { + MappingSourceNode node = i.next(); List<MappingSourceNode> rsStack = getResultSetStack(contextNode, node); @@ -364,8 +385,80 @@ GroupSymbol groupSymbol = QueryUtil.createResolvedGroup(rsInfo.getResultSetName(), planEnv.getGlobalMetadata()); planEnv.addQueryNodeToMetadata(groupSymbol.getMetadataID(), modifiedNode); } + + for (Criteria crit : PredicateCollectorVisitor.getPredicates(userCrit)) { + handleXmlSubqueries(planEnv, crit); + } } + private static void handleXmlSubqueries(XMLPlannerEnvironment planEnv, + Criteria userCrit) throws QueryPlannerException { + if (!(userCrit instanceof SubqueryContainer<?>)) { + return; + } + SubqueryContainer<?> subquery = (SubqueryContainer<?>)userCrit; + if (!(subquery.getCommand() instanceof Query)) { + return; + } + Query q = (Query)subquery.getCommand(); + if (q.getFrom() == null || q.getCriteria() == null) { + return; + } + List<GroupSymbol> groups = q.getFrom().getGroups(); + if (groups.size() != 1) { + return; + } + final GroupSymbol gs = groups.get(0); + LinkedHashSet<GroupSymbol> allGroups = new LinkedHashSet<GroupSymbol>(); + allGroups.add(gs); + //TODO: this group should have been marked as xml, or could attempt this step prior to place user criteria + if (planEnv.getGlobalMetadata().getMetadataStore().getTempGroupID(gs.getNonCorrelationName().toUpperCase()) == null) { + return; + } + MappingSourceNode parentMsn = findMappingSourceNode(planEnv, gs); + for (Criteria crit : PredicateCollectorVisitor.getPredicates(q.getCriteria())) { + Collection<ElementSymbol> elems = ElementCollectorVisitor.getElements(crit, false); + Collection<GroupSymbol> critGroups = new LinkedList<GroupSymbol>(); + for (ElementSymbol elementSymbol : elems) { + if (!elementSymbol.isExternalReference()) { + critGroups.add(elementSymbol.getGroupSymbol()); + } + } + for (GroupSymbol groupSymbol : critGroups) { + if (allGroups.contains(groupSymbol)) { + continue; + } + MappingSourceNode childMsn = findMappingSourceNode(planEnv, groupSymbol); + while (childMsn != parentMsn) { + if (childMsn == null) { + throw new QueryPlannerException(QueryPlugin.Util.getString("XMLQueryPlanner.invalid_relationship", crit, parentMsn)); //$NON-NLS-1$ + } + if (!childMsn.getResultSetInfo().isCriteriaRaised()) { + throw new QueryPlannerException(QueryPlugin.Util.getString("XMLQueryPlanner.non_simple_relationship", crit, childMsn)); //$NON-NLS-1$ + } + Query parentQuery = (Query)childMsn.getResultSetInfo().getCommand(); + if (parentQuery.getCriteria() != null + && allGroups.addAll(GroupsUsedByElementsVisitor.getGroups(parentQuery.getCriteria()))) { + q.setCriteria(Criteria.combineCriteria(q.getCriteria(), (Criteria) parentQuery.getCriteria().clone())); + } + childMsn = childMsn.getParentSourceNode(); + } + } + q.getFrom().getClauses().clear(); + for (GroupSymbol groupSymbol : allGroups) { + q.getFrom().addClause(new UnaryFromClause(groupSymbol)); + } + handleXmlSubqueries(planEnv, crit); + } + } + + private static MappingSourceNode findMappingSourceNode( + XMLPlannerEnvironment planEnv, final GroupSymbol gs) { + MappingSourceNodeFinder finder = new MappingSourceNodeFinder(gs); + planEnv.mappingDoc.acceptVisitor(new Navigator(true, finder)); + return finder.msn; + } + private static void updateSymbolMap(Map symbolMap, String oldGroup, final String newGroup, QueryMetadataInterface metadata) throws QueryResolverException,QueryMetadataException,TeiidComponentException { Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/processor/xml/XMLContext.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/processor/xml/XMLContext.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/processor/xml/XMLContext.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -43,12 +43,12 @@ class XMLContext { // map between variables and their values - Map resultsMap = new HashMap(); + Map<String, PlanExecutor> resultsMap = new HashMap<String, PlanExecutor>(); // reference to the parent variable context XMLContext parentContext; - Map executorMap = new HashMap(); + Map<String, PlanExecutor> executorMap = new HashMap<String, PlanExecutor>(); VariableContext variableContext = new VariableContext(); @@ -56,14 +56,12 @@ * Constructor for VariableContext. */ public XMLContext() { - this.resultsMap = new HashMap(); } /** * Constructor for VariableContext. */ public XMLContext(XMLContext parent) { - this.resultsMap = new HashMap(); this.parentContext = parent; this.variableContext.setParentContext(parent.variableContext); } @@ -77,8 +75,8 @@ * @param aliasResultName * @return */ - public List getCurrentRow(String aliasResultName) throws TeiidComponentException, TeiidProcessingException { - PlanExecutor executor = (PlanExecutor)this.resultsMap.get(aliasResultName); + public List<?> getCurrentRow(String aliasResultName) throws TeiidComponentException, TeiidProcessingException { + PlanExecutor executor = this.resultsMap.get(aliasResultName); if (executor == null) { if (this.parentContext != null) { return this.parentContext.getCurrentRow(aliasResultName); @@ -94,8 +92,8 @@ * @return * @throws TeiidComponentException */ - public List getNextRow(String aliasResultName) throws TeiidComponentException, TeiidProcessingException { - PlanExecutor executor = (PlanExecutor)this.resultsMap.get(aliasResultName); + public List<?> getNextRow(String aliasResultName) throws TeiidComponentException, TeiidProcessingException { + PlanExecutor executor = this.resultsMap.get(aliasResultName); if (executor == null) { if (this.parentContext != null) { return this.parentContext.getNextRow(aliasResultName); @@ -119,7 +117,7 @@ * as there may be another resultset with same name. (recursive condition) */ public void removeResultSet(String resultName) throws TeiidComponentException { - PlanExecutor executor = (PlanExecutor)this.resultsMap.remove(resultName); + PlanExecutor executor = this.resultsMap.remove(resultName); if (executor != null) { executor.close(); } @@ -132,8 +130,8 @@ * @return * @throws TeiidComponentException */ - public List getOutputElements(String resultName) throws TeiidComponentException { - PlanExecutor executor = (PlanExecutor)this.resultsMap.get(resultName); + public List<?> getOutputElements(String resultName) throws TeiidComponentException { + PlanExecutor executor = this.resultsMap.get(resultName); if (executor == null) { if (this.parentContext != null) { return this.parentContext.getOutputElements(resultName); @@ -160,7 +158,7 @@ * @return */ public PlanExecutor getResultExecutor(String resultName) { - return (PlanExecutor)this.executorMap.get(resultName); + return this.executorMap.get(resultName); } /** @@ -186,7 +184,7 @@ void setVariableValues(String resultSetName, - List row) throws TeiidComponentException { + List<?> row) throws TeiidComponentException { List elements = getOutputElements(resultSetName); for (int index = 0; index < elements.size(); index++) { Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/resolver/command/XMLQueryResolver.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/resolver/command/XMLQueryResolver.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/resolver/command/XMLQueryResolver.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -25,23 +25,26 @@ import java.util.ArrayList; import java.util.Collection; import java.util.Collections; -import java.util.HashMap; import java.util.LinkedList; import java.util.List; -import java.util.Map; import java.util.TreeMap; import org.teiid.api.exception.query.QueryMetadataException; import org.teiid.api.exception.query.QueryResolverException; import org.teiid.core.TeiidComponentException; +import org.teiid.core.TeiidRuntimeException; +import org.teiid.core.util.StringUtil; import org.teiid.query.QueryPlugin; +import org.teiid.query.mapping.xml.MappingAttribute; +import org.teiid.query.mapping.xml.MappingBaseNode; import org.teiid.query.mapping.xml.MappingDocument; -import org.teiid.query.mapping.xml.MappingNode; -import org.teiid.query.mapping.xml.MappingSourceNode; +import org.teiid.query.mapping.xml.MappingElement; +import org.teiid.query.mapping.xml.MappingVisitor; +import org.teiid.query.mapping.xml.Navigator; import org.teiid.query.metadata.QueryMetadataInterface; import org.teiid.query.metadata.TempMetadataAdapter; +import org.teiid.query.metadata.TempMetadataStore; import org.teiid.query.metadata.TempMetadataID.Type; -import org.teiid.query.optimizer.xml.SourceNodeGenaratorVisitor; import org.teiid.query.resolver.CommandResolver; import org.teiid.query.resolver.QueryResolver; import org.teiid.query.resolver.util.ResolverUtil; @@ -61,7 +64,6 @@ import org.teiid.query.sql.symbol.ExpressionSymbol; import org.teiid.query.sql.symbol.GroupSymbol; import org.teiid.query.sql.symbol.SelectSymbol; -import org.teiid.query.sql.symbol.SingleElementSymbol; import org.teiid.query.sql.visitor.ElementCollectorVisitor; import org.teiid.query.sql.visitor.GroupCollectorVisitor; import org.teiid.query.sql.visitor.ValueIteratorProviderCollectorVisitor; @@ -71,6 +73,49 @@ */ public class XMLQueryResolver implements CommandResolver { + private final class SubSelectVisitor extends MappingVisitor { + private final List<ElementSymbol> selectElems; + private final ResolvingNode root; + private final String mc; + private String source; + + private SubSelectVisitor(List<ElementSymbol> selectElems, + ResolvingNode root, String mc) { + this.selectElems = selectElems; + this.root = root; + this.mc = mc; + } + + @Override + public void visit(MappingBaseNode baseNode) { + if (baseNode.getSource() != null && baseNode.getFullyQualifiedName().equalsIgnoreCase(mc)) { + source = baseNode.getSource(); + } + } + + @Override + public void visit(MappingElement element) { + visit((MappingBaseNode)element); + String nis = element.getNameInSource(); + getMappingClassColumn(nis, element.getFullyQualifiedName()); + } + + private void getMappingClassColumn(String nis, String fqn) { + if (nis == null || source == null) { + return; + } + String name = nis.substring(0, nis.lastIndexOf('.')); + if (source.equalsIgnoreCase(name)) { + selectElems.add(root.find(fqn)); + } + } + + @Override + public void visit(MappingAttribute attribute) { + getMappingClassColumn(attribute.getNameInSource(), attribute.getFullyQualifiedName()); + } + } + private static final class ResolvingNode { ElementSymbol elementSymbol; TreeMap<String, ResolvingNode> children = new TreeMap<String, ResolvingNode>(String.CASE_INSENSITIVE_ORDER); @@ -106,6 +151,31 @@ return values; } + public ElementSymbol find(String name) { + int index = name.lastIndexOf('.'); + String part = name; + if (index > 0) { + part = name.substring(index + 1, name.length()); + name = name.substring(0, index); + } else { + name = null; + } + ResolvingNode r = children.get(part); + if (r == null) { + return null; + } + if (name == null) { + return r.elementSymbol; + } + return r.find(name); + } + + public void addAll(Collection<ElementSymbol> elems) { + for (ElementSymbol es : elems) { + this.add(es.getName(), es); + } + } + public List<ElementSymbol> values() { return values(new LinkedList<ElementSymbol>()); } @@ -116,32 +186,53 @@ */ public void resolveCommand(Command command, TempMetadataAdapter metadata, boolean resolveNullLiterals) throws QueryMetadataException, QueryResolverException, TeiidComponentException { + resolveCommand((Query)command, null, metadata); + } - Query query = (Query) command; - + public void resolveCommand(Query query, GroupSymbol docGroup, TempMetadataAdapter metadata) + throws QueryMetadataException, QueryResolverException, TeiidComponentException { // set isXML flag - query.setIsXML(true); + query.setIsXML(docGroup == null); // get the group on this query Collection<GroupSymbol> groups = GroupCollectorVisitor.getGroups(query, true); GroupSymbol group = groups.iterator().next(); + boolean subQuery = true; + if (docGroup == null) { + docGroup = group; + subQuery = false; + } + + if (subQuery && group.getDefinition() != null) { + throw new QueryResolverException(QueryPlugin.Util.getString("XMLQueryResolver.aliased_subquery", group)); //$NON-NLS-1$ + } + //external groups GroupContext externalGroups = query.getExternalGroupContexts(); // valid elements for select - List<ElementSymbol> validSelectElems = ResolverUtil.resolveElementsInGroup(group, metadata); - ResolvingNode root = new ResolvingNode(); - for (ElementSymbol elementSymbol : validSelectElems) { - root.add(elementSymbol.getName(), elementSymbol); - } - resolveXMLSelect(query, group, root, metadata); + List<ElementSymbol> validElems = ResolverUtil.resolveElementsInGroup(docGroup, metadata); + final ResolvingNode root = new ResolvingNode(); + ResolvingNode selectRoot = root; + if (subQuery) { + validElems = getElementsUnderNode(group.getMetadataID(), validElems, metadata); + } + root.addAll(validElems); + if (subQuery) { + //the select can only be to the mapping class itself + MappingDocument doc = (MappingDocument) metadata.getMappingNode(docGroup.getMetadataID()); + final String mc = group.getNonCorrelationName(); + List<ElementSymbol> selectElems = new LinkedList<ElementSymbol>(); + doc.acceptVisitor(new Navigator(true, new SubSelectVisitor(selectElems, root, mc))); + selectRoot = new ResolvingNode(); + selectRoot.addAll(selectElems); + } + + resolveXMLSelect(subQuery, query, group, selectRoot, metadata); // valid elements for criteria and order by - Collection<ElementSymbol> validCriteriaElements = collectTempElements(group, metadata); - for (ElementSymbol elementSymbol : validCriteriaElements) { - root.add(elementSymbol.getName(), elementSymbol); - } + root.addAll(collectTempElements(group, metadata)); Criteria crit = query.getCriteria(); OrderBy orderBy = query.getOrderBy(); @@ -149,11 +240,17 @@ if(crit != null) { List<SubqueryContainer> commands = ValueIteratorProviderCollectorVisitor.getValueIteratorProviders(crit); if (!commands.isEmpty()) { - addPseudoSubqueryGroups(metadata, group, validSelectElems); + TempMetadataAdapter tma = new TempMetadataAdapter(metadata, new TempMetadataStore()); + if (!subQuery) { + addPseudoSubqueryGroups(tma, group, docGroup); + } for (SubqueryContainer subCommand : commands) { - QueryResolver.setChildMetadata(subCommand.getCommand(), command); - - QueryResolver.resolveCommand(subCommand.getCommand(), metadata.getMetadata()); + QueryResolver.setChildMetadata(subCommand.getCommand(), query); + if (subCommand.getCommand() instanceof Query && QueryResolver.isXMLQuery((Query)subCommand.getCommand(), tma)) { + resolveCommand((Query)subCommand.getCommand(), docGroup, tma); + } else { + QueryResolver.resolveCommand(subCommand.getCommand(), metadata.getMetadata()); + } } } @@ -177,60 +274,32 @@ } } - private void addPseudoSubqueryGroups(TempMetadataAdapter metadata, - GroupSymbol group, List<ElementSymbol> validSelectElems) - throws TeiidComponentException, QueryMetadataException, - QueryResolverException { + private void addPseudoSubqueryGroups(final TempMetadataAdapter metadata, + GroupSymbol group, GroupSymbol docGroup) + throws TeiidComponentException, QueryMetadataException { /* * The next section of resolving logic adds in pseduo groups that can be used * in subqueries */ - MappingDocument doc = (MappingDocument) metadata.getMappingNode(group.getMetadataID()); - doc = doc.clone(); - doc = SourceNodeGenaratorVisitor.extractSourceNodes(doc); + MappingDocument doc = (MappingDocument) metadata.getMappingNode(docGroup.getMetadataID()); - HashMap<String, List<ElementSymbol>> psuedoGroups = new HashMap<String, List<ElementSymbol>>(); - for (ElementSymbol elementSymbol : validSelectElems) { - MappingNode node = MappingNode.findNode(doc, elementSymbol.getCanonicalName()); - if (node == null) { - continue; - } - MappingSourceNode mappingSourceNode = node.getSourceNode(); - if (mappingSourceNode == null) { - continue; - } - String mappingClass = mappingSourceNode.getSource(); - String tableName = SingleElementSymbol.getShortName(mappingClass); - - String name = elementSymbol.getName(); - int index = name.lastIndexOf('.'); - String xmlTableName = name.substring(0, index); - if (!xmlTableName.endsWith(tableName)) { - continue; - } - List<ElementSymbol> elements = psuedoGroups.get(xmlTableName); - if (elements == null) { - elements = new ArrayList<ElementSymbol>(); - psuedoGroups.put(xmlTableName, elements); - } - ElementSymbol es = new ElementSymbol(name.substring(index+1, name.length())); - es.setType(elementSymbol.getType()); - es.setMetadataID(elementSymbol.getMetadataID()); - elements.add(es); - } - - for (Map.Entry<String, List<ElementSymbol>> entry : psuedoGroups.entrySet()) { - for (ElementSymbol elem : new ArrayList<ElementSymbol>(entry.getValue())) { - if (elem.getName().charAt(0) == '@') { - ElementSymbol alias = elem.clone(); - alias.setShortName(elem.getName().substring(1)); - if (!entry.getValue().contains(alias)) { - entry.getValue().add(alias); + final String prefix = group.getNonCorrelationName() + ElementSymbol.SEPARATOR; + + doc.acceptVisitor(new Navigator(true, new MappingVisitor() { + @Override + public void visit(MappingBaseNode baseNode) { + if (baseNode.getSource() == null) { + return; + } + if (StringUtil.startsWithIgnoreCase(baseNode.getFullyQualifiedName(), prefix)) { + try { + ResolverUtil.addTempGroup(metadata, new GroupSymbol(baseNode.getFullyQualifiedName()), Collections.EMPTY_LIST, false).setMetadataType(Type.XML); + } catch (QueryResolverException e) { + throw new TeiidRuntimeException(e); } - } - } - ResolverUtil.addTempGroup(metadata, new GroupSymbol(entry.getKey()), entry.getValue(), false).setMetadataType(Type.XML); - } + } + } + })); } /** @@ -244,7 +313,7 @@ * @throws QueryMetadataException if resolving fails * @throws TeiidComponentException if resolving fails */ - void resolveXMLSelect(Query query, GroupSymbol group, ResolvingNode validElements, QueryMetadataInterface metadata) + void resolveXMLSelect(boolean subquery, Query query, GroupSymbol group, ResolvingNode validElements, QueryMetadataInterface metadata) throws QueryMetadataException, TeiidComponentException, QueryResolverException { GroupContext externalGroups = null; @@ -269,7 +338,7 @@ // There are other cases of "xml", such as, element name = "xml", // but those are ok because those will be resolved later as normal elements String symbolName = ss.getName(); - if(symbolName.equalsIgnoreCase("xml") || symbolName.equalsIgnoreCase(group.getName() + ".xml")) { //$NON-NLS-1$ //$NON-NLS-2$ + if(!subquery && (symbolName.equalsIgnoreCase("xml") || symbolName.equalsIgnoreCase(group.getName() + ".xml"))) { //$NON-NLS-1$ //$NON-NLS-2$ if(elements.size() != 1) { throw new QueryResolverException(QueryPlugin.Util.getString("XMLQueryResolver.xml_only_valid_alone")); //$NON-NLS-1$ } @@ -302,7 +371,7 @@ resolveElement(elementSymbol, validElements, externalGroups, metadata); // now find all the elements under this node and set as elements. - List<ElementSymbol> elementsInNode = getElementsUnderNode(elementSymbol, validElements.values(), metadata); + List<ElementSymbol> elementsInNode = getElementsUnderNode(elementSymbol.getMetadataID(), validElements.values(), metadata); ((AllInGroupSymbol)ss).setElementSymbols(elementsInNode); } } else if (ss instanceof AllSymbol) { @@ -450,14 +519,14 @@ elem.setOutputName(name); } - static List<ElementSymbol> getElementsUnderNode(ElementSymbol node, Collection<ElementSymbol> validElements, QueryMetadataInterface metadata) + static List<ElementSymbol> getElementsUnderNode(Object mid, Collection<ElementSymbol> validElements, QueryMetadataInterface metadata) throws TeiidComponentException, QueryMetadataException { List<ElementSymbol> elements = new ArrayList<ElementSymbol>(); - String nodeName = metadata.getFullName(node.getMetadataID()); + String nodeName = metadata.getFullName(mid); for (ElementSymbol validElement : validElements) { String qualifiedName = validElement.getName(); - if (qualifiedName.equals(nodeName) || qualifiedName.startsWith(nodeName+ElementSymbol.SEPARATOR)) { + if (StringUtil.startsWithIgnoreCase(qualifiedName, nodeName) && (qualifiedName.length() == nodeName.length() || qualifiedName.charAt(nodeName.length()) == '.')) { elements.add(validElement); } } Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/rewriter/QueryRewriter.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/rewriter/QueryRewriter.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/rewriter/QueryRewriter.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -711,9 +711,9 @@ Query q = createInlineViewQuery(viewName, plannedResult.query, metadata, plannedResult.query.getSelect().getProjectedSymbols()); Iterator<SingleElementSymbol> iter = q.getSelect().getProjectedSymbols().iterator(); - HashMap<Expression, SingleElementSymbol> expressionMap = new HashMap<Expression, SingleElementSymbol>(); + HashMap<Expression, Expression> expressionMap = new HashMap<Expression, Expression>(); for (SingleElementSymbol symbol : plannedResult.query.getSelect().getProjectedSymbols()) { - expressionMap.put(SymbolMap.getExpression(symbol), iter.next()); + expressionMap.put(SymbolMap.getExpression(symbol), SymbolMap.getExpression(iter.next())); } for (int i = 0; i < plannedResult.leftExpressions.size(); i++) { plannedResult.nonEquiJoinCriteria.add(new CompareCriteria(SymbolMap.getExpression((Expression)plannedResult.leftExpressions.get(i)), CompareCriteria.EQ, (Expression)plannedResult.rightExpressions.get(i))); Modified: branches/7.4.x/engine/src/main/java/org/teiid/query/sql/visitor/PredicateCollectorVisitor.java =================================================================== --- branches/7.4.x/engine/src/main/java/org/teiid/query/sql/visitor/PredicateCollectorVisitor.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/java/org/teiid/query/sql/visitor/PredicateCollectorVisitor.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -45,14 +45,14 @@ */ public class PredicateCollectorVisitor extends LanguageVisitor { - private Collection predicates; + private Collection<Criteria> predicates; /** * Construct a new visitor with the default collection type, which is a * {@link java.util.ArrayList}. */ public PredicateCollectorVisitor() { - this.predicates = new ArrayList(); + this.predicates = new ArrayList<Criteria>(); } /** @@ -136,7 +136,7 @@ * Get a collection of predicates discovered while visiting. * @return Collection of {@link org.teiid.query.sql.lang.PredicateCriteria} subclasses. */ - public Collection getPredicates() { + public Collection<Criteria> getPredicates() { return this.predicates; } @@ -144,7 +144,7 @@ * Helper to quickly get the predicates from obj * @param obj Language object */ - public static final Collection getPredicates(LanguageObject obj) { + public static final Collection<Criteria> getPredicates(LanguageObject obj) { PredicateCollectorVisitor visitor = new PredicateCollectorVisitor(); if(obj != null) { PreOrderNavigator.doVisit(obj, visitor); Modified: branches/7.4.x/engine/src/main/resources/org/teiid/query/i18n.properties =================================================================== --- branches/7.4.x/engine/src/main/resources/org/teiid/query/i18n.properties 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/main/resources/org/teiid/query/i18n.properties 2011-06-03 19:07:41 UTC (rev 3214) @@ -131,6 +131,7 @@ ERR.015.008.0068= Could not find a common type to which all {0} expressions can be implicitly converted: {1} ERR.015.008.0070= Aliased Select Symbols are not valid in XML Queries. XMLQueryResolver.no_expressions_in_select=Expressions cannot be selected by XML Queries +XMLQueryResolver.aliased_subquery=Aliased subquery contexts are not allowed: {0} # sql (010) ERR.015.010.0001= Invalid compare operator: {0} @@ -779,6 +780,9 @@ TempTableStore.table_doesnt_exist_error=Temporary table "{0}" does not exist. XMLQueryPlanner.cannot_plan=Cannot create a query for MappingClass with user criteria {0} +XMLQueryPlanner.invalid_relationship=Conjunct "{0}" has no relationship with target context {1}. +XMLQueryPlanner.non_simple_relationship=Conjunct "{0}" has a non-simple relationship to its parent through context {1}. + CriteriaPlanner.staging_context=Staging table criteria cannot contian context functions CriteriaPlanner.multiple_staging=Staging table criteria {0} was not specified against a single staging table CriteriaPlanner.invalid_context=Element {0} is not in the scope of the context {1} Modified: branches/7.4.x/engine/src/test/java/org/teiid/query/processor/xml/TestXMLProcessor.java =================================================================== --- branches/7.4.x/engine/src/test/java/org/teiid/query/processor/xml/TestXMLProcessor.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/engine/src/test/java/org/teiid/query/processor/xml/TestXMLProcessor.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -11214,7 +11214,7 @@ QueryMetadataInterface metadata = RealMetadataFactory.exampleCase3225(); FakeDataManager dataMgr = exampleDataManagerCase3225(metadata); - helpTestProcess("select * from xmltest.playersDoc where context(manager, manager.firstname) > ALL (select firstname from player)", CARDS_MANAGER, metadata, dataMgr); //$NON-NLS-1$ + helpTestProcess("select * from xmltest.playersDoc where context(manager, manager.firstname) > ALL (select firstname from BaseballPlayers.player)", CARDS_MANAGER, metadata, dataMgr); //$NON-NLS-1$ } /** Modified: branches/7.4.x/test-integration/common/pom.xml =================================================================== --- branches/7.4.x/test-integration/common/pom.xml 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/test-integration/common/pom.xml 2011-06-03 19:07:41 UTC (rev 3214) @@ -15,6 +15,11 @@ <artifactId>postgresql</artifactId> <version>8.3-606.jdbc3</version> </dependency> + <dependency> + <groupId>com.h2database</groupId> + <artifactId>h2</artifactId> + <version>1.2.147</version> + </dependency> </dependencies> </project> \ No newline at end of file Added: branches/7.4.x/test-integration/common/src/test/java/org/teiid/dqp/internal/process/TestRelate.java =================================================================== --- branches/7.4.x/test-integration/common/src/test/java/org/teiid/dqp/internal/process/TestRelate.java (rev 0) +++ branches/7.4.x/test-integration/common/src/test/java/org/teiid/dqp/internal/process/TestRelate.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,413 @@ +/* + * 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.dqp.internal.process; + +import static org.junit.Assert.*; + +import java.io.BufferedReader; +import java.io.File; +import java.io.FileReader; +import java.io.IOException; +import java.io.PrintWriter; +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.SQLXML; +import java.sql.Statement; +import java.util.logging.ConsoleHandler; +import java.util.logging.Level; +import java.util.logging.Logger; + +import javax.sql.DataSource; + +import org.h2.jdbcx.JdbcConnectionPool; +import org.h2.jdbcx.JdbcDataSource; +import org.junit.BeforeClass; +import org.junit.Test; +import org.teiid.core.util.UnitTestUtil; +import org.teiid.dqp.internal.datamgr.ConnectorManager; +import org.teiid.dqp.internal.datamgr.ConnectorManagerRepository; +import org.teiid.jdbc.FakeServer; +import org.teiid.translator.ExecutionFactory; +import org.teiid.translator.TranslatorException; +import org.teiid.translator.jdbc.h2.H2ExecutionFactory; +@SuppressWarnings("nls") +public class TestRelate { + + private static boolean writeResults = false; + private static boolean DEBUG = false; + private static FakeServer server; + + @BeforeClass public static void oneTimeSetUp() throws Exception { + //DQPConfiguration config = new DQPConfiguration(); + //config.setUserRequestSourceConcurrency(1); + server = new FakeServer(); + JdbcDataSource h2ds = new JdbcDataSource(); + h2ds.setURL("jdbc:h2:src/test/resources/relate/test"); + final DataSource ds = JdbcConnectionPool.create(h2ds); + ExecutionFactory h2 = new H2ExecutionFactory(); + h2.start(); + ConnectorManagerRepository cmr = new ConnectorManagerRepository(); + ConnectorManager cm = new ConnectorManager("source", "bar") { + @Override + protected Object getConnectionFactory() throws TranslatorException { + return ds; + } + }; + cm.setExecutionFactory(h2); + cmr.addConnectorManager("source", cm); + server.setConnectorManagerRepository(cmr); + server.deployVDB("VehicleRentalsVDB", UnitTestUtil.getTestDataPath()+"/relate/VehicleRentalsVDB.vdb"); + if (DEBUG) { + Logger logger = Logger.getLogger("org.teiid"); + logger.setLevel(Level.FINER); + ConsoleHandler handler = new ConsoleHandler(); + handler.setLevel(Level.FINER); + logger.addHandler(handler); + } + } + + private void compareResults(SQLXML[] docs) + throws SQLException, IOException { + StackTraceElement ste = new Exception().getStackTrace()[1]; + String testName = ste.getMethodName(); + testName = "relate/" + testName; //$NON-NLS-1$ + File actual = new File(UnitTestUtil.getTestDataPath() + "/" +testName+".expected"); //$NON-NLS-1$ //$NON-NLS-2$ + if (writeResults) { + PrintWriter writer = new PrintWriter(actual); + for (SQLXML xml : docs) { + writer.write(xml.getString()); + writer.write('\n'); + } + writer.close(); + return; + } + BufferedReader br = new BufferedReader(new FileReader(actual)); + for (int i = 0; i < docs.length; i++) { + assertEquals(br.readLine(), docs[i].getString()); + } + } + + @Test public void testCase3365() throws Exception{ + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + null, + null, + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testCase3365_crit() throws Exception{ + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + "company.companyid = 'CID1'", + null, + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testCase3365_critNestedSrc() throws Exception { + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + "location = 'Pittsburgh'", + null, + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testCase3365_critNestedSrcContext() throws Exception { + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + null, + null, + null, + null, "context(location, location) = 'Pittsburgh'", null, + null, null, null); + compareResults(docs); + } + + @Test public void testCase3365_critNestedSrcCombinationContext() throws Exception { + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + "location = 'Pittsburgh'", + null, + null, + null, "context(location, location) = 'Pittsburgh'", null, + null, null, null); + compareResults(docs); + } + + @Test public void testCase3365_critNestedTgt() throws Exception { + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + null, + "color = 'Black'", + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testCase3365_compoundCritNestedTgt() throws Exception { + SQLXML[] docs = relate(false, null, null, null, + "rentals.rentsVehicle", "rentals.company", "rentals.vehicle", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.rentsVehicle.companyId", + "rentals.rentsVehicle.vehicleId", "'*:rentals/*:rentsVehicle/@vehicleID'", "STRING", "rentals.vehicle.vehicleId", + "VehicleRentalsDoc.rentalsDocumentWithLocation", + null, + null, + "color='Black' or color='Puce'", + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testSharesDoc() throws Exception { + SQLXML[] docs = relate(true, null, null, null, + "rentals.hasSharingAgreement", "rentals.company", "rentals.company", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.hasSharingAgreement.primaryPartyID", + "rentals.hasSharingAgreement.secondaryPartyID", "'*:rentals/*:hasSharingAgreement/@secondaryPartyID'", "STRING", "rentals.company.companyId", + "VehicleRentalsDoc.companiesDocument", + null, + null, + null, + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testSharesDocWithCritTgt() throws Exception { + SQLXML[] docs = relate(true, null, null, null, + "rentals.hasSharingAgreement", "rentals.company", "rentals.company", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.hasSharingAgreement.primaryPartyID", + "rentals.hasSharingAgreement.secondaryPartyID", "'*:rentals/*:hasSharingAgreement/@secondaryPartyID'", "STRING", "rentals.company.companyId", + "VehicleRentalsDoc.companiesDocument", + null, + null, + "rentals.company.name like 'B%'", + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testSharesDocWithCritTgtContext() throws Exception { + SQLXML[] docs = relate(true, null, null, null, + "rentals.hasSharingAgreement", "rentals.company", "rentals.company", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.hasSharingAgreement.primaryPartyID", + "rentals.hasSharingAgreement.secondaryPartyID", "'*:rentals/*:hasSharingAgreement/@secondaryPartyID'", "STRING", "rentals.company.companyId", + "VehicleRentalsDoc.companiesDocument", + null, + null, + "rentals.company.name like 'B%'", + "rentals.company.name like 'B%'", + null, null, null, + null, null, null); + compareResults(docs); + } + + @Test public void testSharesDocEspaceQuestion3() throws Exception { + SQLXML[] docs = relate(true, null, null, null, + "rentals.hasSharingAgreement", "rentals.company", "rentals.company", + "rentals.company.companyId", "'*:rentals/*:company/@companyID'", "STRING", "rentals.hasSharingAgreement.primaryPartyID", + "rentals.hasSharingAgreement.secondaryPartyID", "'*:rentals/*:hasSharingAgreement/@secondaryPartyID'", "STRING", "rentals.company.companyId", + "VehicleRentalsDoc.companiesDocument", + null, + "company.locations.location = 'Pittsburgh'", + null, + null, + null, null, null, + null, null, null); + compareResults(docs); + } + + public SQLXML[] relate( + //distinct is only meaningful for self-relationships + boolean distinct, + //select args to limit the xml projection + //there is an assumption that the source/relationship select must project key values + String relationshipSelect, String sourceSelect, String targetSelect, + //relevant contexts, the same as expected by the legacy relate function + String relationshipContext, String sourceContext, String targetContext, + //break down of the relationship predicates + String sourceKey, + String sourceKeyPath, + String sourceKeyType, + String sourceFKey, + String targetFKey, + String targetFKeyPath, + String targetFKeyType, + String targetKey, + //target document + String xmlDocument, + //explicit/implicit relationship context criteria - should not use the context function + String relationshipCriteria, + //relateSource/implicit/explicit source context criteria - should not use the context function + String relateSourceCriteria, + //relateTarget criteria - should not use the context function + String relateTargetCriteria, + //relateTarget context criteria - should not use the context function + String relateTargetContextCriteria, + //subcontext criteria, logically applied after the relate operation - should use context function(s), and should not be specified against a root context + String relationshipContextCriteria, + String sourceContextCriteria, + String targetContextCriteria, + //order bys + String relationshipOrderBy, + String sourceOrderBy, + String targetOrderBy + ) throws Exception { + if (sourceSelect == null) { + sourceSelect = sourceContext + ".*"; + } + if (relationshipSelect == null) { + relationshipSelect = relationshipContext + ".*"; + } + if (targetSelect == null) { + targetSelect = targetContext + ".*"; + } + Connection conn = server.createConnection("jdbc:teiid:VehicleRentalsVDB"); //$NON-NLS-1$ + if (DEBUG) { + conn.createStatement().execute("SET SHOWPLAN DEBUG"); + } + SQLXML[] result = new SQLXML[3]; + //source query + String query = String.format("SELECT %s FROM %s WHERE CONTEXT(%s, %s) IN (SELECT %s FROM %s WHERE %s IN (SELECT %s FROM %s", sourceSelect, xmlDocument, sourceContext, sourceKey, sourceFKey, relationshipContext, targetFKey, targetKey, targetContext); + if (relateTargetCriteria != null) { + query += (" WHERE " + relateTargetCriteria); + } + query += "))"; + if (relateSourceCriteria != null) { + query += String.format(" AND (CONTEXT(%s, %s) = null OR %s)", sourceContext, sourceKey, relateSourceCriteria); + } + if (relationshipCriteria != null) { + query += String.format(" AND CONTEXT(%s, %s) IN (SELECT %s FROM %s WHERE AND %s)", sourceContext, sourceKey, sourceFKey, relationshipContext, relationshipCriteria); + } + if (sourceContextCriteria != null) { + query += (" AND " + sourceContextCriteria); + } + if (sourceOrderBy != null) { + query += (" ORDER BY " + sourceOrderBy); + } + PreparedStatement sourcePs = conn.prepareStatement(query); + ResultSet sourceRs = sourcePs.executeQuery(); + sourceRs.next(); + SQLXML sourceXml = sourceRs.getSQLXML(1); + result[0] = sourceXml; + + Statement ddlStmt = conn.createStatement(); + + ddlStmt.execute("CREATE LOCAL TEMPORARY TABLE #st_source (source_key STRING, PRIMARY KEY (source_key))"); + //source key extraction + String sourceStagingQuery = String.format("INSERT INTO #st_source (source_key) SELECT DISTINCT source_key FROM XMLTABLE(%s PASSING cast(? AS xml) COLUMNS source_key %s PATH '.') x", sourceKeyPath, sourceKeyType); + PreparedStatement ps = conn.prepareStatement(sourceStagingQuery); + ps.setSQLXML(1, sourceXml); + ps.execute(); + ps.close(); + + //relationship query + String relQuery = String.format("SELECT %s FROM %s WHERE CONTEXT(%s, %s) IN /*+ DJ */ (SELECT source_key from #st_source) AND CONTEXT(%s, %s) IN (SELECT %s FROM %s", relationshipSelect, xmlDocument, relationshipContext, sourceFKey, relationshipContext, targetFKey, targetKey, targetContext); + if (relateTargetContextCriteria != null) { + relQuery += (" WHERE " + relateTargetContextCriteria); + } + relQuery += ")"; + if (relationshipCriteria != null) { + relQuery += String.format(" AND (CONTEXT(%s, %s) = null OR %s)", relationshipContext, sourceFKey, relationshipCriteria); + } + if (relationshipContextCriteria != null) { + relQuery += (" AND " + relationshipContextCriteria); + } + if (relationshipOrderBy != null) { + relQuery += (" ORDER BY " + relationshipOrderBy); + } + PreparedStatement relStmt = conn.prepareStatement(relQuery); + ResultSet relRs = relStmt.executeQuery(); + relRs.next(); + SQLXML relXml = relRs.getSQLXML(1); + result[1] = relXml; + + ddlStmt.execute("CREATE LOCAL TEMPORARY TABLE #st_rel (target_key STRING, PRIMARY KEY (target_key))"); + //target key extraction + String relStagingQuery = String.format("INSERT INTO #st_rel (target_key) SELECT DISTINCT target_key FROM XMLTABLE(%s PASSING cast(? AS xml) COLUMNS target_key %s PATH '.') x", targetFKeyPath, targetFKeyType); + PreparedStatement psRel = conn.prepareStatement(relStagingQuery); + psRel.setSQLXML(1, relXml); + psRel.execute(); + psRel.close(); + + //target query + String targetQuery = String.format("SELECT %s FROM %s WHERE CONTEXT(%s, %s) IN /*+ DJ */ (SELECT target_key FROM #st_rel", targetSelect, xmlDocument, targetContext, targetKey); + if (distinct && targetContext.equalsIgnoreCase(sourceContext)) { + targetQuery += " EXCEPT SELECT source_key FROM #st_source"; + } + targetQuery += ")"; + if (targetContextCriteria != null) { + targetQuery += (" AND " + targetContextCriteria); + } + if (targetOrderBy != null) { + targetQuery += (" ORDER BY " + targetOrderBy); + } + PreparedStatement targetStmt = conn.prepareStatement(targetQuery); + ResultSet taretRs = targetStmt.executeQuery(); + taretRs.next(); + SQLXML targetXml = taretRs.getSQLXML(1); + result[2] = targetXml; + + ddlStmt.execute("drop table #st_source"); + ddlStmt.execute("drop table #st_rel"); + + return result; + } + +} Property changes on: branches/7.4.x/test-integration/common/src/test/java/org/teiid/dqp/internal/process/TestRelate.java ___________________________________________________________________ Added: svn:mime-type + text/plain Modified: branches/7.4.x/test-integration/common/src/test/java/org/teiid/jdbc/FakeServer.java =================================================================== --- branches/7.4.x/test-integration/common/src/test/java/org/teiid/jdbc/FakeServer.java 2011-06-02 18:23:22 UTC (rev 3213) +++ branches/7.4.x/test-integration/common/src/test/java/org/teiid/jdbc/FakeServer.java 2011-06-03 19:07:41 UTC (rev 3214) @@ -72,6 +72,10 @@ private boolean useCallingThread = true; public FakeServer() { + this(new DQPConfiguration()); + } + + public FakeServer(DQPConfiguration config) { this.logon = new LogonImpl(sessionService, null); this.repo.setSystemStore(VDBMetadataFactory.getSystem()); @@ -92,7 +96,6 @@ } }); - DQPConfiguration config = new DQPConfiguration(); config.setResultsetCacheConfig(new CacheConfiguration(Policy.LRU, 60, 250, "resultsetcache")); //$NON-NLS-1$ this.dqp.setCacheFactory(new DefaultCacheFactory()); this.dqp.start(config); @@ -102,6 +105,10 @@ registerClientService(DQP.class, dqp, null); } + public void setConnectorManagerRepository(ConnectorManagerRepository cmr) { + this.cmr = cmr; + } + public void stop() { this.dqp.stop(); } Added: branches/7.4.x/test-integration/common/src/test/resources/relate/VehicleRentalsVDB.vdb =================================================================== (Binary files differ) Property changes on: branches/7.4.x/test-integration/common/src/test/resources/relate/VehicleRentalsVDB.vdb ___________________________________________________________________ Added: svn:mime-type + application/octet-stream Added: branches/7.4.x/test-integration/common/src/test/resources/relate/rentals.sql =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/rentals.sql (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/rentals.sql 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,347 @@ +CREATE TABLE "ACCESSORIES" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + ACCID varchar(10), + TYPE varchar(40), + MODEL varchar(15), + VERSION varchar(15) +); +CREATE TABLE "COLORS" +( + COLORID varchar(10) primary key, + NAME varchar(42), + VEHICLEID varchar(10) +); +create index colors_vid_idx on colors (vehicleid); + +CREATE TABLE "COMPANIES" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + COMPANYID varchar(10) primary key, + FULLNAME varchar(40), + CLASSIFICATION varchar(15) +); +CREATE TABLE "LOCATIONS" +( + LOCATIONID varchar(10), + NAME varchar(42), + COMPANYID varchar(10) +); +CREATE TABLE "REL_COMP_ACC" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + NATURE varchar(15), + SUBJECTTYPE varchar(40), + TARGETTYPE varchar(40), + COMPANYID varchar(10) NOT NULL, + ACCESSORYID varchar(10) NOT NULL, + QUANTITYAUTH int, + QUANTITYAVAIL int +); +CREATE TABLE "REL_COMP_SHARE" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + NATURE varchar(15), + SUBJECTTYPE varchar(40), + TARGETTYPE varchar(40), + PRIMARYID varchar(10), + SECONDARYID varchar(10), + SINCE numeric(10,0) +); +CREATE TABLE "REL_COMP_SUBSID" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + NATURE varchar(15), + SUBJECTTYPE varchar(40), + TARGETTYPE varchar(40), + COMPANYID varchar(10), + SUBSIDIARYID varchar(10), + PERCENTOWNS numeric(10,0) +); +CREATE TABLE "REL_COMP_VEH" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + NATURE varchar(15), + SUBJECTTYPE varchar(40), + TARGETTYPE varchar(40), + COMPANYID varchar(10) NOT NULL, + VEHICLEID varchar(10) NOT NULL, + QUANTITYAUTH int, + QUANTITYAVAIL int +); +CREATE TABLE "REL_VEH_ACC" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + NATURE varchar(15), + SUBJECTTYPE varchar(40), + TARGETTYPE varchar(40), + VEHICLEID varchar(10) NOT NULL, + ACCESSORYID varchar(10) NOT NULL, + QUANTITYAUTH int, + QUANTITYAVAIL int +); +CREATE TABLE "RENTAL_PRODUCTS" +( + PRODUCTID varchar(10) NOT NULL, + DURATION varchar(42), + VEHICLEID varchar(10), + COMPANYID varchar(10) +); +CREATE TABLE "VEHICLES" +( + COMMONNAME varchar(40), + UUID varchar(36), + QUUID varchar(36), + VEHICLEID varchar(10) primary key, + STYLE varchar(40), + MAKE varchar(15), + MODEL varchar(15), + MODELYEAR int +); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Emerson NV-5000','AUUID2','AQUUID2','AID2','GPS','Emerson','NV-5000'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Garmin Street Pilot','AUUID1','AQUUID1','AID1','GPS','Garmin','Street Pilot'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Gvox A0102','AUUID5','AQUUID5','AID5','DVD','Gvox','A0102'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Gvox A0201','AUUID4','AQUUID4','AID4','DVD','Gvox','A0201'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Pioneer AVIC-N2','AUUID6','AQUUID6','AID6','Navigation','Pioneer','AVIC-N2'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Pioneer CD-VC60','AUUID8','AQUUID8','AID8','Voice Guidance','Pioneer','CD-VC60'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Pyle PLDVD65IN','AUUID3','AQUUID3','AID3','DVD','Pyle','PLDVD65IN'); + +INSERT INTO "ACCESSORIES" (COMMONNAME,UUID,QUUID,ACCID,TYPE,MODEL,VERSION) VALUES ('Sanyo NV-E700','AUUID7','AQUUID7','AID7','Navigation','Sanyo','NV-E700'); + + + +INSERT INTO "COLORS" (COLORID,NAME,VEHICLEID) VALUES ('C1','Red','VID1'); + +INSERT INTO "COLORS" (COLORID,NAME,VEHICLEID) VALUES ('C2','Black','VID1'); + +INSERT INTO "COLORS" (COLORID,NAME,VEHICLEID) VALUES ('C3','Puce','VID2'); + +INSERT INTO "COLORS" (COLORID,NAME,VEHICLEID) VALUES ('C4','Red','VID3'); + +INSERT INTO "COLORS" (COLORID,NAME,VEHICLEID) VALUES ('C5','Black','VID4'); + + + +INSERT INTO "COMPANIES" (COMMONNAME,UUID,QUUID,COMPANYID,FULLNAME,CLASSIFICATION) VALUES ('Avian','CUUID1','CQUUID1','CID1','Avian Rentals, Inc.','Consumer'); + +INSERT INTO "COMPANIES" (COMMONNAME,UUID,QUUID,COMPANYID,FULLNAME,CLASSIFICATION) VALUES ('Budge','CUUID3','CQUUID3','CID3','Budge, Inc.','Wholesale'); + +INSERT INTO "COMPANIES" (COMMONNAME,UUID,QUUID,COMPANYID,FULLNAME,CLASSIFICATION) VALUES ('Entertwine','CUUID2','CQUUID2','CID2','Entertwine Rent A Car, Inc.','Consumer'); + +INSERT INTO "COMPANIES" (COMMONNAME,UUID,QUUID,COMPANYID,FULLNAME,CLASSIFICATION) VALUES ('Gigahertz','CUUID4','CQUUID4','CID4','Gigahertz, Inc.','Consumer'); + +INSERT INTO "COMPANIES" (COMMONNAME,UUID,QUUID,COMPANYID,FULLNAME,CLASSIFICATION) VALUES ('Peso','CUUID5','CQUUID5','CID5','Peso, Inc.','Consumer'); + +INSERT INTO "COMPANIES" (COMMONNAME,UUID,QUUID,COMPANYID,FULLNAME,CLASSIFICATION) VALUES ('Wholefleet','CUUID6','CQUUID6','CID6','Wholefleet, Inc.','Wholesale'); + + + +INSERT INTO "LOCATIONS" (LOCATIONID,NAME,COMPANYID) VALUES ('LOC1','Pittsburgh','CID1'); + +INSERT INTO "LOCATIONS" (LOCATIONID,NAME,COMPANYID) VALUES ('LOC2','Moosejaw','CID2'); + +INSERT INTO "LOCATIONS" (LOCATIONID,NAME,COMPANYID) VALUES ('LOC3','Keokuk','CID1'); + + + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA11','CAUUID11','CAQUUID11','offers','Company','Accessory','CID1','AID1',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA12','CAUUID12','CAQUUID12','offers','Company','Accessory','CID1','AID2',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA13','CAUUID13','CAQUUID13','offers','Company','Accessory','CID1','AID3',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA14','CAUUID14','CAQUUID14','offers','Company','Accessory','CID1','AID4',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA15','CAUUID15','CAQUUID15','offers','Company','Accessory','CID1','AID5',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA16','CAUUID16','CAQUUID16','offers','Company','Accessory','CID1','AID6',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA21','CAUUID21','CAQUUID21','offers','Company','Accessory','CID2','AID1',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA22','CAUUID22','CAQUUID22','offers','Company','Accessory','CID2','AID2',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA23','CAUUID23','CAQUUID23','offers','Company','Accessory','CID2','AID3',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA33','CAUUID33','CAQUUID33','offers','Company','Accessory','CID3','AID3',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA61','CAUUID61','CAQUUID61','offers','Company','Accessory','CID6','AID1',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA62','CAUUID62','CAQUUID62','offers','Company','Accessory','CID6','AID2',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA63','CAUUID63','CAQUUID63','offers','Company','Accessory','CID6','AID3',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA64','CAUUID64','CAQUUID64','offers','Company','Accessory','CID6','AID4',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA65','CAUUID65','CAQUUID65','offers','Company','Accessory','CID6','AID5',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA66','CAUUID66','CAQUUID66','offers','Company','Accessory','CID6','AID6',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA67','CAUUID67','CAQUUID67','offers','Company','Accessory','CID6','AID7',1,1); + +INSERT INTO "REL_COMP_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCA68','CAUUID68','CAQUUID68','offers','Company','Accessory','CID6','AID8',1,1); + + + +INSERT INTO "REL_COMP_SHARE" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,PRIMARYID,SECONDARYID,SINCE) VALUES ('RCC12','CCUUID12','CCQUUID12','sharesWith','Company','Company','CID1','CID2',1985); + +INSERT INTO "REL_COMP_SHARE" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,PRIMARYID,SECONDARYID,SINCE) VALUES ('RCC13','CCUUID13','CCQUUID13','sharesWith','Company','Company','CID1','CID3',1995); + +INSERT INTO "REL_COMP_SHARE" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,PRIMARYID,SECONDARYID,SINCE) VALUES ('RCC14','CCUUID14','CCQUUID14','sharesWith','Company','Company','CID1','CID4',2005); + +INSERT INTO "REL_COMP_SHARE" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,PRIMARYID,SECONDARYID,SINCE) VALUES ('RCC34','CCUUID34','CCQUUID34','sharesWith','Company','Company','CID3','CID4',2001); + +INSERT INTO "REL_COMP_SHARE" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,PRIMARYID,SECONDARYID,SINCE) VALUES ('RCC54','CCUUID54','CCQUUID54','sharesWith','Company','Company','CID5','CID4',1999); + +INSERT INTO "REL_COMP_SHARE" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,PRIMARYID,SECONDARYID,SINCE) VALUES ('RCC64','CCUUID64','CCQUUID64','sharesWith','Company','Company','CID6','CID4',1995); + + + +INSERT INTO "REL_COMP_SUBSID" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,SUBSIDIARYID,PERCENTOWNS) VALUES ('RCS12','CSUUID12','CSQUUID12','owns','Company','Subsidiary','CID1','CID2',10); + +INSERT INTO "REL_COMP_SUBSID" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,SUBSIDIARYID,PERCENTOWNS) VALUES ('RCS13','CSUUID13','CSQUUID13','owns','Company','Subsidiary','CID1','CID3',50); + +INSERT INTO "REL_COMP_SUBSID" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,SUBSIDIARYID,PERCENTOWNS) VALUES ('RCS43','CSUUID43','CSQUUID43','owns','Company','Subsidiary','CID4','CID3',10); + +INSERT INTO "REL_COMP_SUBSID" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,SUBSIDIARYID,PERCENTOWNS) VALUES ('RCS56','CSUUID56','CSQUUID56','owns','Company','Subsidiary','CID5','CID6',100); + + + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV11','CVUUID11','CVQUUID11','rents','Company','Vehicle','CID1','VID1',10,2); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV12','CVUUID12','CVQUUID12','rents','Company','Vehicle','CID1','VID2',2,2); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV13','CVUUID13','CVQUUID13','rents','Company','Vehicle','CID1','VID3',2,0); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV14','CVUUID14','CVQUUID14','rents','Company','Vehicle','CID1','VID4',2,1); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV21','CVUUID21','CVQUUID21','rents','Company','Vehicle','CID2','VID1',5,3); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV22','CVUUID22','CVQUUID22','rents','Company','Vehicle','CID2','VID2',2,1); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV32','CVUUID32','CVQUUID32','rents','Company','Vehicle','CID3','VID2',1,1); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV47','CVUUID47','CVQUUID47','rents','Company','Vehicle','CID4','VID7',1,1); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV61','CVUUID61','CVQUUID61','rents','Company','Vehicle','CID6','VID1',1,1); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV62','CVUUID62','CVQUUID62','rents','Company','Vehicle','CID6','VID2',2,2); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV63','CVUUID63','CVQUUID63','rents','Company','Vehicle','CID6','VID3',3,3); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV64','CVUUID64','CVQUUID64','rents','Company','Vehicle','CID6','VID4',4,4); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV65','CVUUID65','CVQUUID65','rents','Company','Vehicle','CID6','VID5',5,5); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV66','CVUUID66','CVQUUID66','rents','Company','Vehicle','CID6','VID6',6,6); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV67','CVUUID67','CVQUUID67','rents','Company','Vehicle','CID6','VID7',7,7); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV68','CVUUID68','CVQUUID68','rents','Company','Vehicle','CID6','VID8',8,8); + +INSERT INTO "REL_COMP_VEH" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,COMPANYID,VEHICLEID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RCV69','CVUUID69','CVQUUID69','rents','Company','Vehicle','CID6','VID9',9,9); + + + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA11','VAUUID11','VAQUUID11','has','Vehicle','Accessory','VID1','AID1',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA12','VAUUID12','VAQUUID12','has','Vehicle','Accessory','VID1','AID2',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA13','VAUUID13','VAQUUID13','has','Vehicle','Accessory','VID1','AID3',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA23','VAUUID23','VAQUUID23','has','Vehicle','Accessory','VID2','AID3',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA34','VAUUID34','VAQUUID34','has','Vehicle','Accessory','VID3','AID4',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA35','VAUUID35','VAQUUID35','has','Vehicle','Accessory','VID3','AID5',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA41','VAUUID41','VAQUUID41','has','Vehicle','Accessory','VID4','AID1',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA45','VAUUID45','VAQUUID45','has','Vehicle','Accessory','VID4','AID5',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA46','VAUUID46','VAQUUID46','has','Vehicle','Accessory','VID4','AID6',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA51','VAUUID51','VAQUUID51','has','Vehicle','Accessory','VID5','AID1',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA53','VAUUID53','VAQUUID53','has','Vehicle','Accessory','VID5','AID3',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA55','VAUUID55','VAQUUID55','has','Vehicle','Accessory','VID5','AID5',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA57','VAUUID57','VAQUUID57','has','Vehicle','Accessory','VID5','AID7',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA62','VAUUID62','VAQUUID62','has','Vehicle','Accessory','VID6','AID2',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA64','VAUUID64','VAQUUID64','has','Vehicle','Accessory','VID6','AID4',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA66','VAUUID66','VAQUUID66','has','Vehicle','Accessory','VID6','AID6',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA68','VAUUID68','VAQUUID68','has','Vehicle','Accessory','VID6','AID8',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA88','VAUUID88','VAQUUID88','has','Vehicle','Accessory','VID8','AID8',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA91','VAUUID91','VAQUUID91','has','Vehicle','Accessory','VID9','AID1',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA92','VAUUID92','VAQUUID92','has','Vehicle','Accessory','VID9','AID2',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA93','VAUUID93','VAQUUID93','has','Vehicle','Accessory','VID9','AID3',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA94','VAUUID94','VAQUUID94','has','Vehicle','Accessory','VID9','AID4',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA95','VAUUID95','VAQUUID95','has','Vehicle','Accessory','VID9','AID5',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA96','VAUUID96','VAQUUID96','has','Vehicle','Accessory','VID9','AID6',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA97','VAUUID97','VAQUUID97','has','Vehicle','Accessory','VID9','AID7',1,1); + +INSERT INTO "REL_VEH_ACC" (COMMONNAME,UUID,QUUID,NATURE,SUBJECTTYPE,TARGETTYPE,VEHICLEID,ACCESSORYID,QUANTITYAUTH,QUANTITYAVAIL) VALUES ('RVA98','VAUUID98','VAQUUID98','has','Vehicle','Accessory','VID9','AID8',1,1); + + + +INSERT INTO "RENTAL_PRODUCTS" (PRODUCTID,DURATION,VEHICLEID,COMPANYID) VALUES ('P1','Hourly','VID1','CID1'); + +INSERT INTO "RENTAL_PRODUCTS" (PRODUCTID,DURATION,VEHICLEID,COMPANYID) VALUES ('P2','Daily','VID1','CID1'); + +INSERT INTO "RENTAL_PRODUCTS" (PRODUCTID,DURATION,VEHICLEID,COMPANYID) VALUES ('P3','Weekly','VID1','CID1'); + +INSERT INTO "RENTAL_PRODUCTS" (PRODUCTID,DURATION,VEHICLEID,COMPANYID) VALUES ('P4','Weekly','VID2','CID1'); + + + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Chevy Tahoe 2005','VUUID3','VQUUID3','VID3','Utility','Chevrolet','Tahoe',2005); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Ford F150 2004','VUUID2','VQUUID2','VID2','Utility','Ford','F150',2004); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Ford F150 2005','VUUID1','VQUUID1','VID1','Utility','Ford','F150',2005); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Ford Windstar 2004','VUUID5','VQUUID5','VID5','Minivan','Ford','Windstar',2004); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Ford Windstar 2005','VUUID4','VQUUID4','VID4','Minivan','Ford','Windstar',2005); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Honda Pilot 2005','VUUID9','VQUUID9','VID9','SUV','Honda','Pilot',2005); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Nissan Quest 2004','VUUID7','VQUUID7','VID7','Minivan','Nissan','Quest',2004); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Nissan Quest 2005','VUUID6','VQUUID6','VID6','Minivan','Nissan','Quest',2005); + +INSERT INTO "VEHICLES" (COMMONNAME,UUID,QUUID,VEHICLEID,STYLE,MAKE,MODEL,MODELYEAR) VALUES ('Toyota Sienna 2004','VUUID8','VQUUID8','VID8','Minivan','Toyota','Sienna',2004); + Added: branches/7.4.x/test-integration/common/src/test/resources/relate/test.h2.db =================================================================== (Binary files differ) Property changes on: branches/7.4.x/test-integration/common/src/test/resources/relate/test.h2.db ___________________________________________________________________ Added: svn:mime-type + application/octet-stream Added: branches/7.4.x/test-integration/common/src/test/resources/relate/test.trace.db =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/test.trace.db (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/test.trace.db 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,1501 @@ +05-28 19:49:16 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:39 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) + at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-28 19:49:40 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Feature not supported: "clientInfoProperties" [50100-147] + at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) + at org.h2.message.DbException.get(DbException.java:167) + at org.h2.message.DbException.get(DbException.java:144) + at org.h2.message.DbException.getUnsupportedException(DbException.java:202) + at org.h2.message.TraceObject.unsupported(TraceObject.java:423) + at org.h2.jdbc.JdbcDatabaseMetaData.getClientInfoProperties(JdbcDatabaseMetaData.java:2804) + at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) + at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) + at java.lang.reflect.Method.invoke(Method.java:597) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.executeGetter(MetaDataDataSet.java:255) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.generateLine(MetaDataDataSet.java:222) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.load(MetaDataDataSet.java:149) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDataSet.<init>(MetaDataDataSet.java:96) + at net.sourceforge.squirrel_sql.fw.sql.MetaDataDecoratorDataSet.<init>(MetaDataDecoratorDataSet.java:73) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.database.MetaDataTab.createDataSet(MetaDataTab.java:74) + at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) + at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) + at java.lang.Thread.run(Thread.java:662) +05-29 13:09:52 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 13:09:52 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 19:38:55 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 19:38:55 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 23:12:28 jdbc[4]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 23:12:28 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 23:12:28 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 23:15:35 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-29 23:15:35 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 13:15:59 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 13:15:59 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 13:42:22 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 13:42:22 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 13:42:27 jdbc[4]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 14:10:53 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 14:10:53 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 14:18:48 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 14:18:48 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 20:01:44 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 20:01:48 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:08:13 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:08:13 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:38:44 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:38:44 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:46:03 jdbc[4]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:46:03 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +05-31 21:46:03 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 10:49:49 jdbc[4]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 10:49:49 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 10:49:49 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 11:39:24 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 11:39:24 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 13:23:21 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-01 13:23:21 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-02 13:04:48 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-02 13:04:48 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-02 13:07:12 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-02 13:07:12 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-02 13:27:33 jdbc[3]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:174) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-02 13:27:33 jdbc[2]: connection not closed +java.lang.Exception: Stack Trace + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:121) + at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) + at org.h2.Driver.connect(Driver.java:72) + at org.h2.jdbcx.JdbcXAConnection.<init>(JdbcXAConnection.java:77) + at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:311) + at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:341) + at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:222) + at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:202) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:254) + at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:1) + at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:174) + at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:199) + at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:338) + at org.teiid.dqp.internal.process.DataTierTupleSource.access$0(DataTierTupleSource.java:329) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) + at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:1) + at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) + at java.util.concurrent.FutureTask.run(FutureTask.java:138) + at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) + at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) + at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) + at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) + at java.lang.Thread.run(Thread.java:662) +06-03 11:03:23 jdbc[2]: exception +org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT G_0.COMMONNAME, G_0.UUID, G_0.QUUID, G_0.COMPANYID, G_0.FULLNAME, G_0.CLASSIFICATION FROM COMPANIES AS G_0 WHERE G_0.COMPANYID IN (SELECT G_1.COMPANYID FROM REL_COMP_VEH AS G_1, (SELECT DISTINCT G_2.VEHICLEID AS C_0 FROM VEHICLES AS G_2) AS V_0 WHERE G_1.VEHICLEID = V_0.@[*]VEHICLEID) "; expected "identifier"; SQL statement: +SELECT g_0.COMMONNAME, g_0.UUID, g_0.QUUID, g_0.COMPANYID, g_0.FULLNAME, g_0.CLASSIFICATION FROM COMPANIES AS g_0 WHERE g_0.COMPANYID IN (SELECT g_1.COMPANYID FROM REL_COMP_VEH AS g_1, (SELECT DISTINCT g_2.VEHICLEID AS c_0 FROM VEHICLES AS g_2) AS v_0 WHERE g_1.VEHICLEID = v_0.@vehicleID) [42001-147] Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Moosejaw</rental:location></rental:locations></rental:company><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><rental:company commonName="Gigahertz" uuid="CUUID4" queryUUID="CQUUID4" companyID="C! ID4"><rental:name>Gigahertz, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company><rental:company commonName="Wholefleet" uuid="CUUID6" queryUUID="CQUUID6" companyID="CID6"><rental:name>Wholefleet, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV21" uuid="CVUUID21" queryUUID="CVQUUID21" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID2" vehicleID="VID1"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV22" uuid="CVUUID22" queryUUID=! "CVQUUID22" nature="rents" subjectType="Company" targetType="V! ehicle" companyID="CID2" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV32" uuid="CVUUID32" queryUUID="CVQUUID32" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID3" vehicleID="VID2"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV47" uuid="CVUUID47" queryUUID="CVQUUID47" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID4" vehicleID="VID7"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV61" uuid="CVUUID61" queryUUID="CVQUUID61" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID1"><rental:quantityAuthorized>1</rental:quantityAuth! orized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV62" uuid="CVUUID62" queryUUID="CVQUUID62" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV63" uuid="CVUUID63" queryUUID="CVQUUID63" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID3"><rental:quantityAuthorized>3</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV64" uuid="CVUUID64" queryUUID="CVQUUID64" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID4"><rental:quantityAuthorized>4</rental:quantityAuthorized><rental:quantityAvailable>4</rental:quantityAvailable></rental:rentsVehicle! UUID="CV QUUID65" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID5"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>5</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV66" uuid="CVUUID66" queryUUID="CVQUUID66" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID6"><rental:quantityAuthorized>6</rental:quantityAuthorized><rental:quantityAvailable>6</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV67" uuid="CVUUID67" queryUUID="CVQUUID67" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID7"><rental:quantityAuthorized>7</rental:quantityAuthorized><rental:quantityAvailable>7</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV68" uuid="CVUUID68" queryUUID="CVQUUID68" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6"! vehicleID="VID8"><rental:quantityAuthorized>8</rental:quantityAuthorized><rental:quantityAvailable>8</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV69" uuid="CVUUID69" queryUUID="CVQUUID69" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID9"><rental:quantityAuthorized>9</rental:quantityAuthorized><rental:quantityAvailable>9</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2004" uuid="VUUID5" queryUUID="VQUUID5" vehicleID="VID5"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Nissan Quest 2005" uuid="VUUID6" queryUUID="VQUUID6" vehicleID="VID6"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2005</rental:year></! rental:vehicle><rental:vehicle commonName="Nissan Quest 2004" ! uuid="VU UID7" queryUUID="VQUUID7" vehicleID="VID7"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Toyota Sienna 2004" uuid="VUUID8" queryUUID="VQUUID8" vehicleID="VID8"><rental:style>Minivan</rental:style><rental:make>Toyota</rental:make><rental:model>Sienna</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Honda Pilot 2005" uuid="VUUID9" queryUUID="VQUUID9" vehicleID="VID9"><rental:style>SUV</rental:style><rental:make>Honda</rental:make><rental:model>Pilot</rental:model><rental:year>2005</rental:year></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_compoundCritNestedTgt.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_compoundCritNestedTgt.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_compoundCritNestedTgt.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Moosejaw</rental:location></rental:locations></rental:company><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><rental:company commonName="Wholefleet" uuid="CUUID6" queryUUID="CQUUID6" companyID="! CID6"><rental:name>Wholefleet, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV21" uuid="CVUUID21" queryUUID="CVQUUID21" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID2" vehicleID="VID1"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV22" uuid="CVUUID22" queryUUID=! "CVQUUID22" nature="rents" subjectType="Company" targetType="V! ehicle" companyID="CID2" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV32" uuid="CVUUID32" queryUUID="CVQUUID32" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID3" vehicleID="VID2"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV61" uuid="CVUUID61" queryUUID="CVQUUID61" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID1"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV62" uuid="CVUUID62" queryUUID="CVQUUID62" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuth! orized><rental:quantityAvailable>2</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV63" uuid="CVUUID63" queryUUID="CVQUUID63" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID3"><rental:quantityAuthorized>3</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV64" uuid="CVUUID64" queryUUID="CVQUUID64" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID4"><rental:quantityAuthorized>4</rental:quantityAuthorized><rental:quantityAvailable>4</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV65" uuid="CVUUID65" queryUUID="CVQUUID65" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID5"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>5</rental:quantityAvailable></rental:rentsVehicle! UUID="CV QUUID66" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID6"><rental:quantityAuthorized>6</rental:quantityAuthorized><rental:quantityAvailable>6</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV67" uuid="CVUUID67" queryUUID="CVQUUID67" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID7"><rental:quantityAuthorized>7</rental:quantityAuthorized><rental:quantityAvailable>7</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV68" uuid="CVUUID68" queryUUID="CVQUUID68" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID8"><rental:quantityAuthorized>8</rental:quantityAuthorized><rental:quantityAvailable>8</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV69" uuid="CVUUID69" queryUUID="CVQUUID69" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6"! vehicleID="VID9"><rental:quantityAuthorized>9</rental:quantityAuthorized><rental:quantityAvailable>9</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2004" uuid="VUUID5" queryUUID="VQUUID5" vehicleID="VID5"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Nissan Quest 2005" uuid="VUUID6" queryUUID="VQUUID6" vehicleID="VID6"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2005</rental:year></! rental:vehicle><rental:vehicle commonName="Nissan Quest 2004" ! uuid="VU UID7" queryUUID="VQUUID7" vehicleID="VID7"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Toyota Sienna 2004" uuid="VUUID8" queryUUID="VQUUID8" vehicleID="VID8"><rental:style>Minivan</rental:style><rental:make>Toyota</rental:make><rental:model>Sienna</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Honda Pilot 2005" uuid="VUUID9" queryUUID="VQUUID9" vehicleID="VID9"><rental:style>SUV</rental:style><rental:make>Honda</rental:make><rental:model>Pilot</rental:model><rental:year>2005</rental:year></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_crit.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_crit.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_crit.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrc.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrc.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrc.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcCombinationContext.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcCombinationContext.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcCombinationContext.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location></rental:locations></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcContext.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcContext.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedSrcContext.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location></rental:locations></rental:company><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><rental:company commonName="Gigahertz" uuid="CUUID4" queryUUID="CQUUID4" companyID="CID4"><rental:name>Gigahertz, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company><rental:company common! Name="Wholefleet" uuid="CUUID6" queryUUID="CQUUID6" companyID="CID6"><rental:name>Wholefleet, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV21" uuid="CVUUID21" queryUUID="CVQUUID21" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID2" vehicleID="VID1"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV22" uuid="CVUUID22" queryUUID=! "CVQUUID22" nature="rents" subjectType="Company" targetType="V! ehicle" companyID="CID2" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV32" uuid="CVUUID32" queryUUID="CVQUUID32" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID3" vehicleID="VID2"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV47" uuid="CVUUID47" queryUUID="CVQUUID47" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID4" vehicleID="VID7"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV61" uuid="CVUUID61" queryUUID="CVQUUID61" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID1"><rental:quantityAuthorized>1</rental:quantityAuth! orized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV62" uuid="CVUUID62" queryUUID="CVQUUID62" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV63" uuid="CVUUID63" queryUUID="CVQUUID63" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID3"><rental:quantityAuthorized>3</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV64" uuid="CVUUID64" queryUUID="CVQUUID64" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID4"><rental:quantityAuthorized>4</rental:quantityAuthorized><rental:quantityAvailable>4</rental:quantityAvailable></rental:rentsVehicle! UUID="CV QUUID65" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID5"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>5</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV66" uuid="CVUUID66" queryUUID="CVQUUID66" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID6"><rental:quantityAuthorized>6</rental:quantityAuthorized><rental:quantityAvailable>6</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV67" uuid="CVUUID67" queryUUID="CVQUUID67" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID7"><rental:quantityAuthorized>7</rental:quantityAuthorized><rental:quantityAvailable>7</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV68" uuid="CVUUID68" queryUUID="CVQUUID68" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6"! vehicleID="VID8"><rental:quantityAuthorized>8</rental:quantityAuthorized><rental:quantityAvailable>8</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV69" uuid="CVUUID69" queryUUID="CVQUUID69" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID9"><rental:quantityAuthorized>9</rental:quantityAuthorized><rental:quantityAvailable>9</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2004" uuid="VUUID5" queryUUID="VQUUID5" vehicleID="VID5"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Nissan Quest 2005" uuid="VUUID6" queryUUID="VQUUID6" vehicleID="VID6"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2005</rental:year></! rental:vehicle><rental:vehicle commonName="Nissan Quest 2004" ! uuid="VU UID7" queryUUID="VQUUID7" vehicleID="VID7"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Toyota Sienna 2004" uuid="VUUID8" queryUUID="VQUUID8" vehicleID="VID8"><rental:style>Minivan</rental:style><rental:make>Toyota</rental:make><rental:model>Sienna</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Honda Pilot 2005" uuid="VUUID9" queryUUID="VQUUID9" vehicleID="VID9"><rental:style>SUV</rental:style><rental:make>Honda</rental:make><rental:model>Pilot</rental:model><rental:year>2005</rental:year></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedTgt.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedTgt.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testCase3365_critNestedTgt.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Moosejaw</rental:location></rental:locations></rental:company><rental:company commonName="Wholefleet" uuid="CUUID6" queryUUID="CQUUID6" companyID="CID6"><rental:name>Wholefleet, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:rentsVehicle commonName="RCV11" uuid="CVUUID11" queryUUID="CVQUUID11" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID1"><rental:quantityAuthorized>10</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Hourly</rental:duration><rental:duration>Daily</rental:duration><rental:duration>Weekly</rental:duration></rental:rentalProducts></rental:rentsVehicle><rental:rentsVehicle commonName="RCV12" uuid="CVUUID12" queryUUID="CVQUUID12" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable><rental:rentalProducts><rental:duration>Weekly</rental:duration></rental:rentalProducts></rent! al:rentsVehicle><rental:rentsVehicle commonName="RCV13" uuid="CVUUID13" queryUUID="CVQUUID13" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID3"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>0</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV14" uuid="CVUUID14" queryUUID="CVQUUID14" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID1" vehicleID="VID4"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV21" uuid="CVUUID21" queryUUID="CVQUUID21" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID2" vehicleID="VID1"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV22" uuid="CVUUID22" queryUUID=! "CVQUUID22" nature="rents" subjectType="Company" targetType="V! ehicle" companyID="CID2" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV61" uuid="CVUUID61" queryUUID="CVQUUID61" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID1"><rental:quantityAuthorized>1</rental:quantityAuthorized><rental:quantityAvailable>1</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV62" uuid="CVUUID62" queryUUID="CVQUUID62" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID2"><rental:quantityAuthorized>2</rental:quantityAuthorized><rental:quantityAvailable>2</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV63" uuid="CVUUID63" queryUUID="CVQUUID63" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID3"><rental:quantityAuthorized>3</rental:quantityAuth! orized><rental:quantityAvailable>3</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV64" uuid="CVUUID64" queryUUID="CVQUUID64" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID4"><rental:quantityAuthorized>4</rental:quantityAuthorized><rental:quantityAvailable>4</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV65" uuid="CVUUID65" queryUUID="CVQUUID65" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID5"><rental:quantityAuthorized>5</rental:quantityAuthorized><rental:quantityAvailable>5</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV66" uuid="CVUUID66" queryUUID="CVQUUID66" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID6"><rental:quantityAuthorized>6</rental:quantityAuthorized><rental:quantityAvailable>6</rental:quantityAvailable></rental:rentsVehicle! UUID="CV QUUID67" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID7"><rental:quantityAuthorized>7</rental:quantityAuthorized><rental:quantityAvailable>7</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV68" uuid="CVUUID68" queryUUID="CVQUUID68" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID8"><rental:quantityAuthorized>8</rental:quantityAuthorized><rental:quantityAvailable>8</rental:quantityAvailable></rental:rentsVehicle><rental:rentsVehicle commonName="RCV69" uuid="CVUUID69" queryUUID="CVQUUID69" nature="rents" subjectType="Company" targetType="Vehicle" companyID="CID6" vehicleID="VID9"><rental:quantityAuthorized>9</rental:quantityAuthorized><rental:quantityAvailable>9</rental:quantityAvailable></rental:rentsVehicle></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:vehicle commonName="Ford F150 2005" uuid="VUUID1" queryUUID="VQUUID1" vehicleID="VID1"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford F150 2004" uuid="VUUID2" queryUUID="VQUUID2" vehicleID="VID2"><rental:style>Utility</rental:style><rental:make>Ford</rental:make><rental:model>F150</rental:model><rental:year>2004</rental:year><rental:availablecolors><rental:color>Puce</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Chevy Tahoe 2005" uuid="VUUID3" queryUUID="VQUUID3" vehicleID="VID3"><rental:style>Utility</rental:style><rental:make>Chevrolet</rental! :make><rental:model>Tahoe</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Red</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2005" uuid="VUUID4" queryUUID="VQUUID4" vehicleID="VID4"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2005</rental:year><rental:availablecolors><rental:color>Black</rental:color></rental:availablecolors></rental:vehicle><rental:vehicle commonName="Ford Windstar 2004" uuid="VUUID5" queryUUID="VQUUID5" vehicleID="VID5"><rental:style>Minivan</rental:style><rental:make>Ford</rental:make><rental:model>Windstar</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Nissan Quest 2005" uuid="VUUID6" queryUUID="VQUUID6" vehicleID="VID6"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2005</rental:year></! rental:vehicle><rental:vehicle commonName="Nissan Quest 2004" ! uuid="VU UID7" queryUUID="VQUUID7" vehicleID="VID7"><rental:style>Minivan</rental:style><rental:make>Nissan</rental:make><rental:model>Quest</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Toyota Sienna 2004" uuid="VUUID8" queryUUID="VQUUID8" vehicleID="VID8"><rental:style>Minivan</rental:style><rental:make>Toyota</rental:make><rental:model>Sienna</rental:model><rental:year>2004</rental:year></rental:vehicle><rental:vehicle commonName="Honda Pilot 2005" uuid="VUUID9" queryUUID="VQUUID9" vehicleID="VID9"><rental:style>SUV</rental:style><rental:make>Honda</rental:make><rental:model>Pilot</rental:model><rental:year>2005</rental:year></rental:vehicle></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDoc.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDoc.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDoc.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><rental:company commonName="Peso" uuid="CUUID5" queryUUID="CQUUID5" companyID="CID5"><rental:name>Peso, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company><rental:company commonName="Wholefleet" uuid="CUUID6" queryUUID="CQUUID6" companyID="CID6"><rental:name>Wholefleet, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><! /rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:hasSharingAgreement commonName="RCC12" uuid="CCUUID12" queryUUID="CCQUUID12" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID2" since="1985"/><rental:hasSharingAgreement commonName="RCC13" uuid="CCUUID13" queryUUID="CCQUUID13" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID3" since="1995"/><rental:hasSharingAgreement commonName="RCC14" uuid="CCUUID14" queryUUID="CCQUUID14" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID4" since="2005"/><rental:hasSharingAgreement commonName="RCC34" uuid="CCUUID34" queryUUID="CCQUUID34" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID3" secondaryPartyID="CID4" since="2001"/><rental:hasSha! ringAgreement commonName="RCC54" uuid="CCUUID54" queryUUID="CCQUUID54" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID5" secondaryPartyID="CID4" since="1999"/><rental:hasSharingAgreement commonName="RCC64" uuid="CCUUID64" queryUUID="CCQUUID64" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID6" secondaryPartyID="CID4" since="1995"/></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Moosejaw</rental:location></rental:locations></rental:company><rental:company commonName="Gigahertz" uuid="CUUID4" queryUUID="CQUUID4" companyID="CID4"><rental:name>Gigahertz, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocEspaceQuestion3.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocEspaceQuestion3.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocEspaceQuestion3.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:hasSharingAgreement commonName="RCC12" uuid="CCUUID12" queryUUID="CCQUUID12" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID2" since="1985"/><rental:hasSharingAgreement commonName="RCC13" uuid="CCUUID13" queryUUID="CCQUUID13" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID3" since="1995"/><rental:hasSharingAgreement commonName="RCC14" uuid="CCUUID14" queryUUID="CCQUUID14" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID4" since="2005"/></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Moosejaw</rental:location></rental:locations></rental:company><rental:company commonName="Gigahertz" uuid="CUUID4" queryUUID="CQUUID4" companyID="CID4"><rental:name>Gigahertz, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgt.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgt.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgt.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:hasSharingAgreement commonName="RCC12" uuid="CCUUID12" queryUUID="CCQUUID12" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID2" since="1985"/><rental:hasSharingAgreement commonName="RCC13" uuid="CCUUID13" queryUUID="CCQUUID13" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID3" since="1995"/><rental:hasSharingAgreement commonName="RCC14" uuid="CCUUID14" queryUUID="CCQUUID14" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID4" since="2005"/></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company><rental:company commonName="Entertwine" uuid="CUUID2" queryUUID="CQUUID2" companyID="CID2"><rental:name>Entertwine Rent A Car, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Moosejaw</rental:location></rental:locations></rental:company><rental:company commonName="Gigahertz" uuid="CUUID4" queryUUID="CQUUID4" companyID="CID4"><rental:name>Gigahertz, Inc.</rental:name><rental:type>Consumer</rental:type></rental:company></rental:rentals> Added: branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgtContext.expected =================================================================== --- branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgtContext.expected (rev 0) +++ branches/7.4.x/test-integration/common/src/test/resources/relate/testSharesDocWithCritTgtContext.expected 2011-06-03 19:07:41 UTC (rev 3214) @@ -0,0 +1,3 @@ +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Avian" uuid="CUUID1" queryUUID="CQUUID1" companyID="CID1"><rental:name>Avian Rentals, Inc.</rental:name><rental:type>Consumer</rental:type><rental:locations><rental:location>Pittsburgh</rental:location><rental:location>Keokuk</rental:location></rental:locations></rental:company></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:hasSharingAgreement commonName="RCC13" uuid="CCUUID13" queryUUID="CCQUUID13" nature="sharesWith" subjectType="Company" targetType="Company" primaryPartyID="CID1" secondaryPartyID="CID3" since="1995"/></rental:rentals> +<?xml version="1.0" encoding="UTF-8"?><rental:rentals xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:rental="urn:metamatrix:source:rental"><rental:company commonName="Budge" uuid="CUUID3" queryUUID="CQUUID3" companyID="CID3"><rental:name>Budge, Inc.</rental:name><rental:type>Wholesale</rental:type></rental:company></rental:rentals>