Unsupported Feature when executing procedure
aelmeswari Mar 18, 2010 11:56 AMHello,
I have updated my existing source model by importing an Oracle procedure that has one IN parameter and one OUT parameter. As a side note, when updating an existing model, all of the objects currently on the model are marked for deletion. So I actually have to uncheck all of those, otherwise they will be deleted and only the new object (in this case the procedure) will be added. Anyway, back to the issue at hand. I created a virtual procedure in the existing view model that has one Procedure Parameter to represent the IN paramater, and within the NewProcedureResult I have one column representing the OUT parameter. I synch up the VDB and excute it with Transaction Autowrap set to PESSIMISTIC. I click the procedure in the SQLExplorer and generate the exec statement. The generated statement is EXEC JOPES_VL.JOPES.JOPES_SET_ROLE( 'TMT_USER' ). When I run this statement i get the following error:
com.metamatrix.jdbc.MMSQLException: Error Code:17023 Message:Error Code:17023 Message:Error occurred on connector JOPES_PL XA Connector<9> - Error Code:17023 Message:Unsupported feature
at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:123)
at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71)
at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:423)
at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:318)
at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:192)
at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: [MetaMatrixComponentException] 17023: Error Code:17023 Message:Error Code:17023 Message:Error occurred on connector JOPES_PL XA Connector<9> - Error Code:17023 Message:Unsupported feature
1 [ConnectorException]Error Code:17023 Message:Error occurred on connector JOPES_PL XA Connector<9> - Error Code:17023 Message:Unsupported feature
2 [ConnectorException]Error Code:17023 Message:Unsupported feature
3 [SQLException]Unsupported feature
at org.teiid.dqp.internal.process.DataTierTupleSource.switchBatch(DataTierTupleSource.java:128)
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:89)
at com.metamatrix.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:132)
at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:261)
at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:165)
at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:261)
at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:165)
at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:261)
at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:110)
at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:160)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:261)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:207)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211)
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: org.teiid.connector.api.ConnectorException: Error Code:17023 Message:Error occurred on connector JOPES_PL XA Connector<9> - Error Code:17023 Message:Unsupported feature
at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleError(ConnectorWorkItem.java:238)
at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:174)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at org.teiid.dqp.internal.datamgr.impl.SynchConnectorWorkItem.run(SynchConnectorWorkItem.java:69)
... 4 more
Caused by: org.teiid.connector.api.ConnectorException: Error Code:17023 Message:Unsupported feature
at org.teiid.connector.jdbc.JDBCProcedureExecution.getOutputParameterValues(JDBCProcedureExecution.java:131)
at org.teiid.dqp.internal.datamgr.impl.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:88)
at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:405)
at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.processNewRequest(ConnectorWorkItem.java:283)
at org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:157)
... 6 more
Caused by: java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.OracleParameterMetaData.getParameterType(OracleParameterMetaData.java:166)
at org.teiid.connector.jdbc.JDBCProcedureExecution.addParameterValue(JDBCProcedureExecution.java:138)
at org.teiid.connector.jdbc.JDBCProcedureExecution.getOutputParameterValues(JDBCProcedureExecution.java:126)
... 10 more
I looks like it is having an issue with the parameter type. Both the IN and OUT parameters have a VARCHAR2 native type and a string datatype. I am using the ojdbc6.jar and the connection class is oracle.jdbc.xa.client.OracleXADataSource
Any thoughts?