Package org.teiid.client.metadata

Examples of org.teiid.client.metadata.ParameterInfo

372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
    if(listOfParameters != null){
        //get the size of result set
        int resultSetSize = 0;
        Iterator iteratorOfParameters = listOfParameters.iterator();
        while(iteratorOfParameters.hasNext()){
            ParameterInfo parameter = (ParameterInfo)iteratorOfParameters.next();
            if(parameter.getType() == ParameterInfo.RESULT_SET){
                resultSetSize = parameter.getNumColumns();
                //one ResultSet only
                break;
            }
        }

        //return needs to be the first
        int index = 0; //index in user call - {?=call sp(?)}
        int count = 0;
        iteratorOfParameters = listOfParameters.iterator();
        while(iteratorOfParameters.hasNext()){
            ParameterInfo parameter = (ParameterInfo)iteratorOfParameters.next();
            if(parameter.getType() == ParameterInfo.RETURN_VALUE){
                count++;
                index++;
                outParamIndexMap.put(new Integer(index), new Integer(resultSetSize + count));
                break;
            }
        }

        iteratorOfParameters = listOfParameters.iterator();
        while(iteratorOfParameters.hasNext()){
            ParameterInfo parameter = (ParameterInfo)iteratorOfParameters.next();
            if(parameter.getType() != ParameterInfo.RETURN_VALUE && parameter.getType() != ParameterInfo.RESULT_SET){
                index++;
                if(parameter.getType() == ParameterInfo.OUT || parameter.getType() == ParameterInfo.INOUT){
                    count++;
                    outParamIndexMap.put(new Integer(index), new Integer(resultSetSize + count));
                }
            }
        }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
                                           DataTypeManager.DefaultDataTypes.BIG_INTEGER});
        message.setFinalRow(200);
        message.setFirstRow(1);
        message.setLastRow(100);
        List parameters = new ArrayList();
        parameters.add(new ParameterInfo(ParameterInfo.IN, 0));
        parameters.add(new ParameterInfo(ParameterInfo.RESULT_SET, 5));
        message.setParameters(parameters);
        PlanNode planDescs = new PlanNode("test");
        planDescs.addProperty("key1", "val1"); //$NON-NLS-1$ //$NON-NLS-2$
        planDescs.addProperty("key2", "val2"); //$NON-NLS-1$ //$NON-NLS-2$
        planDescs.addProperty("key3", "val3"); //$NON-NLS-1$ //$NON-NLS-2$
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
        assertEquals(1, copy.getFirstRow());
        assertEquals(100, copy.getLastRow());
       
        assertNotNull(copy.getParameters());
        assertEquals(2, copy.getParameters().size());
        ParameterInfo info1 = (ParameterInfo) copy.getParameters().get(0);
        assertEquals(ParameterInfo.IN, info1.getType());
        assertEquals(0, info1.getNumColumns());
        ParameterInfo info2 = (ParameterInfo) copy.getParameters().get(1);
        assertEquals(ParameterInfo.RESULT_SET, info2.getType());
        assertEquals(5, info2.getNumColumns());
       
        assertNotNull(copy.getPlanDescription());
        assertEquals(4, copy.getPlanDescription().getProperties().size());
       
        assertNotNull(copy.getResults());
View Full Code Here
639
640
641
642
643
644
645
646
647
648
649
    private static List<ParameterInfo> getParameterInfo(StoredProcedure procedure) {
        List<ParameterInfo> paramInfos = new ArrayList<ParameterInfo>();
       
        for (SPParameter param : procedure.getParameters()) {
            ParameterInfo info = new ParameterInfo(param.getParameterType(), param.getResultSetColumns().size());
            paramInfos.add(info);
        }
       
        return paramInfos;
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
    resultsMsg.setColumnNames(new String[] { "IntNum", "Out1", "Out2" }); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
    resultsMsg.setDataTypes(new String[] { JDBCSQLTypeInfo.INTEGER, JDBCSQLTypeInfo.INTEGER, JDBCSQLTypeInfo.INTEGER });
    resultsMsg.setFinalRow(results.length);
    resultsMsg.setLastRow(results.length);
    resultsMsg.setFirstRow(1);
    resultsMsg.setParameters(Arrays.asList(new ParameterInfo(ParameterInfo.RESULT_SET, 1), new ParameterInfo(ParameterInfo.OUT, 1), new ParameterInfo(ParameterInfo.OUT, 1)));
    mmcs.createResultSet(resultsMsg);
    assertEquals(1, mmcs.getInt(1));
    assertEquals(2, mmcs.getInt(2));
  }
View Full Code Here
TOP

Related Classes of org.teiid.client.metadata.ParameterInfo

  • org.teiid.dqp.internal.process.RequestWorkItem
  • org.teiid.dqp.message.TestResultsMessage
  • org.teiid.jdbc.StatementImpl
  • org.teiid.jdbc.TestCallableStatement
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.