1 2 Previous Next 20 Replies Latest reply on Mar 28, 2013 8:35 AM by shawkins Go to original post
      • 15. Re: Did teiid7.7 supports procedures with OUT parameter? If it supports means what are the procedures to call sp through callable statement with teiid
        raghu85
        raghu85 Mar 27, 2013 5:06 AM (in response to raghu85)

        As per your suggestion we tweaked vdb file with translator property and deployed to jboss. Now we are getting the below exception. It seems that it is QueryResolverException by teiid stating that teiid expecting the return parmater but original procedure is not expecting any return parmater(Issue with Teiid as we discussed above). Plz give some inputs on this.

         

        Generated META INF-->vdb.xml file looks like

         

        <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

        <vdb version="1" name="ibisprocedureb">

            <property value="false" name="preview"/>

            <model visible="true" type="PHYSICAL" name="ibisprocedure" path="/GlobalAPI-Teiid-DataModels/sources/ibisprocedure.xmi">

                <property value="3115599332" name="checksum"/>

                <property value="Relational" name="modelClass"/>

                <property value="false" name="builtIn"/>

                <property value="3873171533.INDEX" name="indexName"/>

                <source translator-name="oracle" connection-jndi-name="ibisprocedure" name="ibisprocedure"/>

            </model>

            <translator description="" type="oracle" name="ibisprocedure">

                <property value="false" name="oracleSuppliedDriver"/>

            </translator>

        </vdb>

         

        Exception:

         

        Executing {call ibisprocedureb.INSERT_SCHOOL_DETAIL(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}

        org.teiid.jdbc.TeiidSQLException: Error Code:50000 Message:ibisprocedure: Error Code:50000 Message:'{ ?= call INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,?,?)}' erro

        r executing statement(s): {1}

            at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

            at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

            at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:624)

            at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:72)

            at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:539)

            at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

            at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

            at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

            at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:220)

            at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:255)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

            at java.lang.reflect.Method.invoke(Unknown Source)

            at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

            at $Proxy1.read(Unknown Source)

            at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:349)

            at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:548)

            at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211)

            at com.jai.TeiidCalableStatementTEST.insertSchool(TeiidCalableStatementTEST.java:71)

            at com.jai.TeiidCalableStatementTEST.main(TeiidCalableStatementTEST.java:37)

        Caused by: [TeiidProcessingException] 50000: Error Code:50000 Message:ibisprocedure: Error Code:50000 Message:'{ ?= call INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,

        ?,?)}' error executing statement(s): {1}

        1 [TranslatorException] 50000: Error Code:50000 Message:'{ ?= call INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,?,?)}' error executing statement(s): {1}

        2 [TeiidSQLException]Procedure ibisprocedure.INSERT_SCHOOL_DETAIL does not have a return value.

        3 [QueryResolverException]Procedure ibisprocedure.INSERT_SCHOOL_DETAIL does not have a return value.

            at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:430)

            at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:250)

            at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)

            at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

            at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)

            at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

            at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)

            at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)

            at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)

            at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)

            at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:375)

            at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

            at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

            at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

            at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:240)

            at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)

            at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)

            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:619)

        Caused by: [TranslatorException] 50000: Error Code:50000 Message:'{ ?= call INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,?,?)}' error executing statement(s): {1}

        1 [TeiidSQLException]Procedure ibisprocedure.INSERT_SCHOOL_DETAIL does not have a return value.

        2 [QueryResolverException]Procedure ibisprocedure.INSERT_SCHOOL_DETAIL does not have a return value.

            at org.teiid.translator.jdbc.JDBCProcedureExecution.execute(JDBCProcedureExecution.java:70)

            at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:276)

            at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)

            at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:143)

            at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:140)

            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.DQPCore$FutureWork.run(DQPCore.java:120)

            ... 6 more

        Caused by: org.teiid.jdbc.TeiidSQLException: Procedure ibisprocedure.INSERT_SCHOOL_DETAIL does not have a return value.

            at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

            at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

            at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)

            at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

            at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)

            at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

            at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:543)

            at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211)

            at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:299)

            at org.teiid.translator.jdbc.JDBCExecutionFactory.executeStoredProcedure(JDBCExecutionFactory.java:753)

            at org.teiid.translator.jdbc.oracle.OracleExecutionFactory.executeStoredProcedure(OracleExecutionFactory.java:720)

            at org.teiid.translator.jdbc.JDBCProcedureExecution.execute(JDBCProcedureExecution.java:67)

            ... 13 more

        Caused by: [QueryResolverException]Procedure ibisprocedure.INSERT_SCHOOL_DETAIL does not have a return value.

            at org.teiid.query.resolver.command.ExecResolver.findCommandMetadata(ExecResolver.java:159)

            at org.teiid.query.resolver.command.ExecResolver.resolveProceduralCommand(ExecResolver.java:231)

            at org.teiid.query.resolver.ProcedureContainerResolver.resolveCommand(ProcedureContainerResolver.java:140)

            at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:294)

            at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:147)

            at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:292)

            at org.teiid.dqp.internal.process.PreparedStatementRequest.resolveCommand(PreparedStatementRequest.java:88)

            at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:391)

            at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:154)

            at org.teiid.dqp.internal.process.Request.processRequest(Request.java:460)

            at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)

            at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)

            at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

            at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

            at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:390)

            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 org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

            at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:397)

            at $Proxy448.executeRequest(Unknown Source)

            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 org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:130)

            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:240)

            at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:224)

            at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:128)

            at $Proxy448.executeRequest(Unknown Source)

            at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

            at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

            ... 18 more

          • Actions
        • 16. Re: Did teiid7.7 supports procedures with OUT parameter? If it supports means what are the procedures to call sp through callable statement with teiid
          shawkins
          shawkins Mar 27, 2013 6:46 AM (in response to raghu85)

          It looks like the ibisprocedure connection-jndi-name is pointing you to a Teiid DataSource and not to Oracle.

           

          Steve

            • Actions
          • 17. Re: Did teiid7.7 supports procedures with OUT parameter? If it supports means what are the procedures to call sp through callable statement with teiid
            raghu85
            raghu85 Mar 28, 2013 1:51 AM (in response to shawkins)

            Thanks steve for your valuable inputs...

            We updated our vdb file with connection-jndi-name to point Oracale datasource. But after doing this we are getting the previous scope error that we discussed previously.(Teiid calling procedure as Function which leads to below exception). Refer the generateed vdb file and the oracle datasource xml file. Plz suggest some idea to solve this issue.

             

            Generated vdb file:

            <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

            <vdb version="1" name="ibisprocedurec">

                <property value="false" name="preview"/>

                <model visible="true" type="PHYSICAL" name="ibisprocedure" path="/GlobalAPI-Teiid-DataModels/sources/ibisprocedure.xmi">

                    <property value="2454190122" name="checksum"/>

                    <property value="Relational" name="modelClass"/>

                    <property value="false" name="builtIn"/>

                    <property value="3873171533.INDEX" name="indexName"/>

                    <source translator-name="oracle" connection-jndi-name="ibisiprocedurefororcale" name="ibisprocedure"/>

                </model>

                <translator description="" type="oracle" name="ibisprocedure">

                    <property value="false" name="oracleSuppliedDriver"/>

                </translator>

            </vdb>

             

            ibisiprocedurefororcale:

            <datasources>

              <local-tx-datasource>

                  <jndi-name>ibisiprocedurefororcale</jndi-name>

                <connection-url>jdbc:oracle:thin:******Some url****</connection-url>

                <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

                <user-name>PLUSER</user-name>

                <password>*******</password>

               

                <!--pooling parameters-->

                <min-pool-size>5</min-pool-size>

                <max-pool-size>100</max-pool-size>

                <idle-timeout-minutes>20</idle-timeout-minutes>   

                <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->

                <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>

                <!-- Checks the Oracle error codes and messages for fatal errors -->

                <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

                    <!-- sql to call when connection is created

                    <new-connection-sql>some arbitrary sql</new-connection-sql>

                    -->

             

                    <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered

                    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>

                    -->

             

                  <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

                  <metadata>

                      <!-- NO Default type mappings for Oracle 10g so use Oracle9i -->

                      <!-- Note there may be and issue with Number(10) being assigned to a short rather than an int -->

                     <type-mapping>Oracle9i</type-mapping>

                  </metadata>

              </local-tx-datasource>

             

            </datasources>

             

            Exception Trace:

            org.teiid.jdbc.TeiidSQLException: Error Code:65000 Message:ibisprocedure: Error Code:65000 Message:'{ ?= call SCHOOLS.INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,?,?

            )}' error executing statement(s): {1}

                at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

                at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

                at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:624)

                at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:72)

                at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:539)

                at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

                at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

                at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

                at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:220)

                at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:255)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

                at java.lang.reflect.Method.invoke(Unknown Source)

                at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)

                at $Proxy1.read(Unknown Source)

                at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:349)

                at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:548)

                at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211)

                at com.jai.TeiidCalableStatementTEST.insertSchool(TeiidCalableStatementTEST.java:70)

                at com.jai.TeiidCalableStatementTEST.main(TeiidCalableStatementTEST.java:37)

            Caused by: [TeiidProcessingException] 65000: Error Code:65000 Message:ibisprocedure: Error Code:65000 Message:'{ ?= call SCHOOLS.INSERT_SCHOOL_DETAIL(?,?,?,?,?,

            ?,?,?,?,?,?)}' error executing statement(s): {1}

            1 [TranslatorException] 65000: Error Code:65000 Message:'{ ?= call SCHOOLS.INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,?,?)}' error executing statement(s): {1}

            2 [SQLException]ORA-06550: line 1, column 13:

            PLS-00222: no function with name 'INSERT_SCHOOL_DETAIL' exists in this scope

            ORA-06550: line 1, column 7:

            PL/SQL: Statement ignored

             

                at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:430)

                at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:250)

                at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)

                at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

                at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)

                at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

                at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)

                at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)

                at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)

                at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)

                at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:375)

                at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

                at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

                at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:240)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)

                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:619)

            Caused by: [TranslatorException] 65000: Error Code:65000 Message:'{ ?= call SCHOOLS.INSERT_SCHOOL_DETAIL(?,?,?,?,?,?,?,?,?,?,?)}' error executing statement(s):

            {1}

            1 [SQLException]ORA-06550: line 1, column 13:

            PLS-00222: no function with name 'INSERT_SCHOOL_DETAIL' exists in this scope

            ORA-06550: line 1, column 7:

            PL/SQL: Statement ignored

             

                at org.teiid.translator.jdbc.JDBCProcedureExecution.execute(JDBCProcedureExecution.java:70)

                at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:276)

                at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)

                at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:143)

                at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:140)

                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.DQPCore$FutureWork.run(DQPCore.java:120)

                ... 6 more

            Caused by: java.sql.SQLException: ORA-06550: line 1, column 13:

            PLS-00222: no function with name 'INSERT_SCHOOL_DETAIL' exists in this scope

            ORA-06550: line 1, column 7:

            PL/SQL: Statement ignored

             

                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

                at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)

                at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)

                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)

                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)

                at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422)

                at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)

                at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:299)

                at org.teiid.translator.jdbc.JDBCExecutionFactory.executeStoredProcedure(JDBCExecutionFactory.java:753)

                at org.teiid.translator.jdbc.oracle.OracleExecutionFactory.executeStoredProcedure(OracleExecutionFactory.java:720)

                at org.teiid.translator.jdbc.JDBCProcedureExecution.execute(JDBCProcedureExecution.java:67)

                ... 13 more

              • Actions
            • 18. Re: Did teiid7.7 supports procedures with OUT parameter? If it supports means what are the procedures to call sp through callable statement with teiid
              shawkins
              shawkins Mar 28, 2013 6:58 AM (in response to raghu85)

              You are one step closer.  Note that you still have the source translator-name set to "oracle" rather than "ibisprocedure".

                • Actions
              • 19. Re: Did teiid7.7 supports procedures with OUT parameter? If it supports means what are the procedures to call sp through callable statement with teiid
                raghu85
                raghu85 Mar 28, 2013 8:20 AM (in response to shawkins)

                Steve..

                 

                Changed as per your inputs, but still getting the same exception. Whether this translation property that we are setting in vdb is not recognizing by teiid jdbc translator for oracle?

                 

                <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

                <vdb version="1" name="ibisprocedurec">

                    <property value="false" name="preview"/>

                    <model visible="true" type="PHYSICAL" name="ibisprocedure" path="/GlobalAPI-Teiid-DataModels/sources/ibisprocedure.xmi">

                        <property value="2454190122" name="checksum"/>

                        <property value="Relational" name="modelClass"/>

                        <property value="false" name="builtIn"/>

                        <property value="3873171533.INDEX" name="indexName"/>

                        <source translator-name="oracletrans" connection-jndi-name="ibisiprocedure" name="ibisprocedure"/>

                    </model>

                    <translator description="" type="oracle" name="oracletrans">

                        <property value="false" name="oracleSuppliedDriver"/>

                    </translator>

                </vdb>

                  • Actions
                • 20. Re: Did teiid7.7 supports procedures with OUT parameter? If it supports means what are the procedures to call sp through callable statement with teiid
                  shawkins
                  shawkins Mar 28, 2013 8:35 AM (in response to raghu85)

                  Yes, that property is supported.  It was added for https://issues.jboss.org/browse/TEIID-832 in Teiid 7.6 and would thus be in place for Teiid 7.7.  Are you still getting source sql with "?= call"?  If not, then this setting was successful.  However if you are still getting an exception then something else is still wrong.

                   

                  Steve

                    • Actions
                  1 2 Previous Next