[JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2995?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2995:
---------------------------------------
Look at the literal formats for odata. A long should end in l.
> 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.getNomination...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIID-2996) Ability to disable keepAlive
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2996?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2996:
---------------------------------------
To clarify this is valid when not using teiid based load balancing. Otherwise client connections may maintain more than 1 server session that are not associated with a socket.
> Ability to disable keepAlive
> ----------------------------
>
> Key: TEIID-2996
> URL: https://issues.jboss.org/browse/TEIID-2996
> Project: Teiid
> Issue Type: Enhancement
> Components: Server
> Affects Versions: 7.7.10
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
>
> offer an option to disable the ping/keep alive as the connections will always be associated with a given socket.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIID-2996) Ability to disable keepAlive
by Johnathon Lee (JIRA)
Johnathon Lee created TEIID-2996:
------------------------------------
Summary: Ability to disable keepAlive
Key: TEIID-2996
URL: https://issues.jboss.org/browse/TEIID-2996
Project: Teiid
Issue Type: Enhancement
Components: Server
Affects Versions: 7.7.10
Reporter: Johnathon Lee
Assignee: Steven Hawkins
offer an option to disable the ping/keep alive as the connections will always be associated with a given socket.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata
by Tom Johnston (JIRA)
[ 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&En... 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.getNomination...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2995?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-2995:
--------------------------------
Description:
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.getNomination...
was:
The following snippet is what is seen in the $metadata call
<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>
the ERROR is:
<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>
the sample URL I'm trying is:
http://127.0.0.1:8180/odata/POC_VDB/NominationRationaleVIEW.getNomination...
> 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.getNomination...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years
[JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2995?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2995.
-----------------------------------
Resolution: Rejected
You are using entity syntax, not function syntax. See http://www.odata.org/documentation/odata-version-2-0/uri-conventions/ - and add the parameters to the query string ?param1=x¶m2=y...
> 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
> <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>
> the ERROR is:
> <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>
> 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)
10 years
[JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata
by Tom Johnston (JIRA)
Tom Johnston created TEIID-2995:
-----------------------------------
Summary: 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
<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>
the ERROR is:
<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>
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)
10 years
[JBoss JIRA] (TEIID-2981) Add an OData query parameter that caches the resultset
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2981?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2981:
---------------------------------------
Added connection. property handling to odata as well. This will be for both the vdb properties and the servlet init properties (with preference given to the init properties). However without a more substantial effort this will not yet be used for standard JDBC.
> Add an OData query parameter that caches the resultset
> ------------------------------------------------------
>
> Key: TEIID-2981
> URL: https://issues.jboss.org/browse/TEIID-2981
> Project: Teiid
> Issue Type: Feature Request
> Components: OData
> Affects Versions: 8.7
> Reporter: John Muller
> Assignee: Steven Hawkins
> Priority: Minor
> Labels: Caching, OData,
> Fix For: 8.8
>
>
> The Teiid caching guide indicates that the /*+ cache */ SQL hint is neccessary in order to cache results [1] . We would like two features added to the OData support: (1) to have a query parameter that basically injects the hint into the SQL statement run against the VDB and (2) a configuration setting that turns on OData resultset caching for all result sets smaller than some size (perhaps 256 as the default)
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years