[
https://issues.jboss.org/browse/TEIID-2995?page=com.atlassian.jira.plugin...
]
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&am... but
getting this error returned:
<error
xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadat...
<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/metadat...
<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.getNomination...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)