[teiid-issues] [JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata
Tom Johnston (JIRA)
issues at jboss.org
Tue Jun 10 16:07:15 EDT 2014
[ https://issues.jboss.org/browse/TEIID-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12975028#comment-12975028 ]
Tom Johnston commented on TEIID-2995:
-------------------------------------
Must have looked at old docs..
Now I'm using http://127.0.0.1:8180/odata/POC_VDB/getNominationbyRange?StartNbr=1000&EndNbr=1000 but getting this error returned:
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code>ServerErrorException</code>
<message lang="en-US">Internal Server Error</message>
</error>
And this stack trace on the server:
(not sure what the cast to Long is about)
15:02:11,038 ERROR [org.teiid.ODATA] (http-/127.0.0.1:8180-5) TEIID16013 Error occured producing OData result.: java.lang.ClassCastException: java.lan
g.Integer cannot be cast to java.lang.Long
at org.odata4j.core.OSimpleObjects.create(OSimpleObjects.java:44) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
at org.odata4j.core.OFunctionParameters.parse(OFunctionParameters.java:45) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
at org.odata4j.producer.resources.FunctionResource.getFunctionParameters(FunctionResource.java:204) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
at org.odata4j.producer.resources.FunctionResource.callFunction(FunctionResource.java:86) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
at org.odata4j.producer.resources.EntitiesRequestResource.getEntitiesImpl(EntitiesRequestResource.java:353) [odata4j-core-0.8.0-SNAPSHOT-redha
t.jar:]
at org.odata4j.producer.resources.EntitiesRequestResource.getEntities(EntitiesRequestResource.java:266) [odata4j-core-0.8.0-SNAPSHOT-redhat.ja
r:]
at sun.reflect.GeneratedMethodAccessor197.invoke(Unknown Source) [:1.7.0_60]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_60]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_60]
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-
1]
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-
1]
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Fi
nal-redhat-1]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-r
edhat-1]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-r
edhat-1]
at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:97) [classes:]
at org.teiid.odata.ODataServlet.service(ODataServlet.java:61) [classes:]
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.6.Final-redhat-1
.jar:2.3.6.Final-redhat-1]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.
Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-re
dhat-1]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1
]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1
]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:499) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redha
t-1]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.1.Final-redhat
-10.jar:7.2.1.Final-redhat-10]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.F
inal-redhat-1]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_60]
> procedure with inputs fails to be found when executed via odata
> ---------------------------------------------------------------
>
> Key: TEIID-2995
> URL: https://issues.jboss.org/browse/TEIID-2995
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Tom Johnston
> Assignee: Steven Hawkins
>
> The following snippet is what is seen in the $metadata call
> {code}
> <ComplexType Name="getNominationbyRange_NewProcedureResult">
> <Property Name="WorkplanID" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/>
> <Property Name="RationaleComments" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/>
> </ComplexType>
> <EntityContainer Name="NominationRationaleVIEW" m:IsDefaultEntityContainer="false">
> <EntitySet Name="toLoadData" EntityType="NominationRationaleVIEW.toLoadData"/>
> <FunctionImport Name="getNominationbyRange" ReturnType="Collection(NominationRationaleVIEW.getNominationbyRange_NewProcedureResult)" m:HttpMethod="GET">
> <Parameter Name="StartNbr" Type="Edm.Int64" Mode="In" Nullable="false"/>
> <Parameter Name="EndNbr" Type="Edm.Int64" Mode="In" Nullable="false"/>
> </FunctionImport>
> </EntityContainer>
> {code}
> the ERROR is:
> {code}
> <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
> <code>NotFoundException</code>
> <message lang="en-US">
> TEIID16011 EntitySet "NominationRationaleVIEW.getNominationbyRange" is not found; Check the spelling, use modelName.tableName; The table that representing the Entity type must either have a PRIMARY KEY or UNIQUE key(s)
> </message>
> </error>
> {code}
> the sample URL I'm trying is:
> http://127.0.0.1:8180/odata/POC_VDB/NominationRationaleVIEW.getNominationbyRange(StartNbr=1000,EndNbr=1000)
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
More information about the teiid-issues
mailing list