[JBoss JIRA] Created: (TEIID-1216) Cannot pass xml result from one select as critera to another select
by John Doyle (JIRA)
Cannot pass xml result from one select as critera to another select
-------------------------------------------------------------------
Key: TEIID-1216
URL: https://jira.jboss.org/browse/TEIID-1216
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1
Environment: Teiid 7.1 CR2 on RHEL 5
Reporter: John Doyle
Assignee: Steve Hawkins
I've created a VDB with procedures to create and parse XML, as wall as one to invoke the WS connector. SQL that unites them all into a single call passing the created XML into the invoke procedure is failing:
SELECT t.* FROM table (EXEC cis.CountryInfoServiceXML.CapitalCity.create_CapitalCity('US')) AS request, table (EXEC CountryInfoService.invoke('SOAP11', '', request.xml_out, 'http://www.oorsprong.org/websamples.countryinfo/CountryInfoService.wso')) AS response, table (EXEC cis.CountryInfoServiceXML.CapitalCity.extract_CapitalCityResponse(RESPONSE.result)) AS t;
13:23:02,501 ERROR [PROCESSOR] Unexpected exception for request wHnSpxDdmkGB.5
[TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate request.xml_out: No value was available
at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:389)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:629)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Resolved: (TEIID-1336) EDS adminshell - clearCache() having no effect
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-1336?page=com.atlassian.jira.plugin.s... ]
Ramesh Reddy resolved TEIID-1336.
---------------------------------
Resolution: Done
Fixed the code to not hit the cache when user did not turn on caching or did not provide a cache hint. This way the total requests will correctly counted. Before, it was counting the total requests whether user turned on caching or not.
Also, resetting the TotalRequests and cacheHitRatio, if the contents of the cache are cleared.
> EDS adminshell - clearCache() having no effect
> ----------------------------------------------
>
> Key: TEIID-1336
> URL: https://jira.jboss.org/browse/TEIID-1336
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER3 build
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Fix For: 7.1.1
>
>
> clearCache() doesn't look like it's doing anything - see below:
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "conn-1")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> ===================
> server.log:
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@18cf5ea
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Ping MLwHWKFcHgcq
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:38
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@c171b7
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) before clearCache:org.teiid.adminapi.jboss.Admin@1a42c71(QUERY_SERVICE_RESULT_SET_CACHE)
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) after clearCache : null
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:39
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Resolved: (TEIID-962) Create new system function to dump temp table contents to file.
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-962?page=com.atlassian.jira.plugin.sy... ]
Ramesh Reddy resolved TEIID-962.
--------------------------------
Resolution: Done
> Create new system function to dump temp table contents to file.
> -----------------------------------------------------------------
>
> Key: TEIID-962
> URL: https://jira.jboss.org/browse/TEIID-962
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 6.0.0
> Environment: All
> Reporter: Ken Johnson
> Assignee: Ramesh Reddy
> Fix For: 7.2
>
>
> A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL.
> Suggested capability: function will take the following parameters:
> - Temp table name as string
> - Target file name (path qualified) as string
> - Delimiter as string
> When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values.
> This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary.
> Open questions:
> 1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified?
> Suggest this feature remain undocumented for the short term.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Updated: (TEIID-1336) EDS adminshell - clearCache() having no effect
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-1336?page=com.atlassian.jira.plugin.s... ]
Ramesh Reddy updated TEIID-1336:
--------------------------------
Assignee: Ramesh Reddy
Fix Version/s: 7.1.1
Component/s: Query Engine
> EDS adminshell - clearCache() having no effect
> ----------------------------------------------
>
> Key: TEIID-1336
> URL: https://jira.jboss.org/browse/TEIID-1336
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER3 build
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Fix For: 7.1.1
>
>
> clearCache() doesn't look like it's doing anything - see below:
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "conn-1")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> ===================
> server.log:
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@18cf5ea
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Ping MLwHWKFcHgcq
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:38
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@c171b7
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) before clearCache:org.teiid.adminapi.jboss.Admin@1a42c71(QUERY_SERVICE_RESULT_SET_CACHE)
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) after clearCache : null
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:39
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Commented: (TEIID-962) Create new system function to dump temp table contents to file.
by Steven Hawkins (JIRA)
[ https://jira.jboss.org/browse/TEIID-962?page=com.atlassian.jira.plugin.sy... ]
Steven Hawkins commented on TEIID-962:
--------------------------------------
I updated ramesh's checkin so that textagg is no longer resvered, but this required the use of a keyword - textagg(for ...)
Most usage will look like:
SELECT TEXTAGG(FOR c1, c2, ... HEADER ENCODING "UTF-16") FROM TBL
Following H2 or PostgreSQL we could consider using the form:
TABLETEXT FOR (SELECT c1, c2 ... FROM TBL) HEADER ENCODING "UTF-16"
This latter form is a bit more straight-forward and will not have any interactions with aggregate planning. It could also be used as a parenthesized expression to return the blob value.
> Create new system function to dump temp table contents to file.
> -----------------------------------------------------------------
>
> Key: TEIID-962
> URL: https://jira.jboss.org/browse/TEIID-962
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 6.0.0
> Environment: All
> Reporter: Ken Johnson
> Assignee: Ramesh Reddy
> Fix For: 7.2
>
>
> A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL.
> Suggested capability: function will take the following parameters:
> - Temp table name as string
> - Target file name (path qualified) as string
> - Delimiter as string
> When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values.
> This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary.
> Open questions:
> 1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified?
> Suggest this feature remain undocumented for the short term.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Issue Comment Edited: (TEIID-1336) EDS adminshell - clearCache() having no effect
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-1336?page=com.atlassian.jira.plugin.s... ]
Ramesh Reddy edited comment on TEIID-1336 at 10/29/10 12:51 PM:
----------------------------------------------------------------
What are you expecting here? ClearCache throws away cache entries if there were any. In this case I see no entries. Are you thing thinking that "requestCount" should go to zero perhaps?
was (Author: rareddy):
What are you expecting here?
> EDS adminshell - clearCache() having no effect
> ----------------------------------------------
>
> Key: TEIID-1336
> URL: https://jira.jboss.org/browse/TEIID-1336
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER3 build
> Reporter: Len DiMaggio
>
> clearCache() doesn't look like it's doing anything - see below:
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "conn-1")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> ===================
> server.log:
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@18cf5ea
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Ping MLwHWKFcHgcq
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:38
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@c171b7
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) before clearCache:org.teiid.adminapi.jboss.Admin@1a42c71(QUERY_SERVICE_RESULT_SET_CACHE)
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) after clearCache : null
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:39
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Commented: (TEIID-1336) EDS adminshell - clearCache() having no effect
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/browse/TEIID-1336?page=com.atlassian.jira.plugin.s... ]
Ramesh Reddy commented on TEIID-1336:
-------------------------------------
What are you expecting here?
> EDS adminshell - clearCache() having no effect
> ----------------------------------------------
>
> Key: TEIID-1336
> URL: https://jira.jboss.org/browse/TEIID-1336
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER3 build
> Reporter: Len DiMaggio
>
> clearCache() doesn't look like it's doing anything - see below:
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "conn-1")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> ===================
> server.log:
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@18cf5ea
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Ping MLwHWKFcHgcq
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:38
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@c171b7
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) before clearCache:org.teiid.adminapi.jboss.Admin@1a42c71(QUERY_SERVICE_RESULT_SET_CACHE)
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) after clearCache : null
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:39
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months
[JBoss JIRA] Moved: (TEIID-1336) EDS adminshell - clearCache() having no effect
by Van Halbert (JIRA)
[ https://jira.jboss.org/browse/TEIID-1336?page=com.atlassian.jira.plugin.s... ]
Van Halbert moved SOA-2521 to TEIID-1336:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1336 (was: SOA-2521)
Affects Version/s: 7.1.1
(was: 5.1.0.ER3)
Security: (was: Public)
Component/s: (was: EDS)
> EDS adminshell - clearCache() having no effect
> ----------------------------------------------
>
> Key: TEIID-1336
> URL: https://jira.jboss.org/browse/TEIID-1336
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.1.1
> Environment: SOA-P 5.1 ER3 build
> Reporter: Len DiMaggio
>
> clearCache() doesn't look like it's doing anything - see below:
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "conn-1")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=0; requestCount=3
> ===================
> server.log:
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@18cf5ea
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Ping MLwHWKFcHgcq
> 2010-10-29 12:13:07,065 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:38
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@c171b7
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) before clearCache:org.teiid.adminapi.jboss.Admin@1a42c71(QUERY_SERVICE_RESULT_SET_CACHE)
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.ADMIN_API] (New I/O server worker #2-1) after clearCache : null
> 2010-10-29 12:13:07,067 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for request ID:39
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 8 months