[JBoss JIRA] (TEIID-2706) Cache hint for resultset cache in user query doesn't work
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIID-2706?page=com.atlassian.jira.plugin... ]
Debbie Steigner commented on TEIID-2706:
----------------------------------------
No the query with the hint doesn't show in the server.log, let me try a different query tool.
> Cache hint for resultset cache in user query doesn't work
> ---------------------------------------------------------
>
> Key: TEIID-2706
> URL: https://issues.jboss.org/browse/TEIID-2706
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7.7
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again:
> This is displayed the first time the query is run, it's loading the Cache:
> 2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> This displays the subsequent times the same query is run and you will not see source queries:
> 2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2706) Cache hint for resultset cache in user query doesn't work
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2706?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2706:
---------------------------------------
Do you see the that full query text on the server side? If not and you are for example issuing through squirrel, then the query tool is stripping the comment.
> Cache hint for resultset cache in user query doesn't work
> ---------------------------------------------------------
>
> Key: TEIID-2706
> URL: https://issues.jboss.org/browse/TEIID-2706
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7.7
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again:
> This is displayed the first time the query is run, it's loading the Cache:
> 2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> This displays the subsequent times the same query is run and you will not see source queries:
> 2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2706) Cache hint for resultset cache in user query doesn't work
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIID-2706?page=com.atlassian.jira.plugin... ]
Debbie Steigner commented on TEIID-2706:
----------------------------------------
I created a simple BQT vdb and am just querying the source model with
/*+ cache */ select * from bqt.SmallA
multiple times and every time you can see that we are querying the source again.
> Cache hint for resultset cache in user query doesn't work
> ---------------------------------------------------------
>
> Key: TEIID-2706
> URL: https://issues.jboss.org/browse/TEIID-2706
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7.7
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again:
> This is displayed the first time the query is run, it's loading the Cache:
> 2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> This displays the subsequent times the same query is run and you will not see source queries:
> 2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2706) Cache hint for resultset cache in user query doesn't work
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2706?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2706:
---------------------------------------
I don't see enough information here or in the case to say what may be going on. From the unit tests the user query cache hint is working as expected.
Can you provide more on the exact queries being issued?
> Cache hint for resultset cache in user query doesn't work
> ---------------------------------------------------------
>
> Key: TEIID-2706
> URL: https://issues.jboss.org/browse/TEIID-2706
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7.7
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again:
> This is displayed the first time the query is run, it's loading the Cache:
> 2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> This displays the subsequent times the same query is run and you will not see source queries:
> 2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
> But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2706) Cache hint for resultset cache in user query doesn't work
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-2706:
--------------------------------------
Summary: Cache hint for resultset cache in user query doesn't work
Key: TEIID-2706
URL: https://issues.jboss.org/browse/TEIID-2706
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.7.7
Reporter: Debbie Steigner
Assignee: Steven Hawkins
I enabled TRACE logging and Command Logging to see if the Resultset Cache was being used on my queries. If I use the ResultSetCacheMode=true on connection string you can see Teiid using the cache instead of pulling from source again:
This is displayed the first time the query is run, it's loading the Cache:
2013-10-18 07:17:52,951 TRACE [org.teiid.PROCESSOR] Adding to global/distributed cache Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
This displays the subsequent times the same query is run and you will not see source queries:
2013-10-18 07:19:21,115 TRACE [org.teiid.PROCESSOR] Cache hit for Cache Entry<tR+M2n5wIwzI=bqt2@teiid-security> params:null sql:select * from SmallA
But if I remove the connection string and just try using the Cache Hint /*+ cache*/ you see nothing in the logs in regards to the Cache loading or being used on the second query, you still see Teiid pulling the results from the source.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2424) Create OSGi bundles for Embedded
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2424?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2424:
---------------------------------------
Arg. This seems vastly more complicated than it should be, but it appears that the inclusion of the bundle plugin (even if through pluginManagement and adding supported project types) will fail if there is a "proper" resource adapter parent module. If the resource adapter parent isn't a child of the teiid root pom, then using pluginManagement works as expected. So there's something about our pom, jboss parent, or bom that prevents a sub-pom module from working as expected.
At this point it seems simplest to just go back to the old way.
> Create OSGi bundles for Embedded
> --------------------------------
>
> Key: TEIID-2424
> URL: https://issues.jboss.org/browse/TEIID-2424
> Project: Teiid
> Issue Type: Feature Request
> Components: AdminApi, Embedded
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Labels: Alpha1
> Fix For: 8.6
>
>
> Embedded should be available as an OSGi bundle(s). It may also be useful for Designer to consume us through bundles as well.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2702) Deploying google using example google.xml throws exception
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2702?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2702.
-----------------------------------
Resolution: Done
> Deploying google using example google.xml throws exception
> -----------------------------------------------------------
>
> Key: TEIID-2702
> URL: https://issues.jboss.org/browse/TEIID-2702
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
>
> Trying to deploy google using the example and the BatchSize config property is not recognized, error thrown:
> Caused by: java.lang.NoSuchMethodException: JBAS010474: Method setBatchSize not found
> at org.jboss.as.connector.util.Injection.inject(Injection.java:130)
> at org.jboss.as.connector.util.Injection.inject(Injection.java:83)
> at org.jboss.as.connector.services.resourceadapters.deployment.AbstractResourceAdapterDeploymentService$AbstractAS7RaDeployer.initAndInject(AbstractResourceAdapterDeploymentService.java:428)
> ... 8 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2424) Create OSGi bundles for Embedded
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2424?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2424:
---------------------------------------
Creating a common resource adapter relative parent pom has complicated the release a little bit. Because the relative pom is not a module, it does not have the proper version substitution performed. I tried a little bit to create a proper module without moving the connector-xxx modules, but in one way or another it wouldn't work (most commonly maven rejected the pom packaging). So we may need to consider creating a proper/simple module structure to separate out the resource adapters from the translators.
> Create OSGi bundles for Embedded
> --------------------------------
>
> Key: TEIID-2424
> URL: https://issues.jboss.org/browse/TEIID-2424
> Project: Teiid
> Issue Type: Feature Request
> Components: AdminApi, Embedded
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Labels: Alpha1
> Fix For: 8.6
>
>
> Embedded should be available as an OSGi bundle(s). It may also be useful for Designer to consume us through bundles as well.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2702) Deploying google using example google.xml throws exception
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-2702?page=com.atlassian.jira.plugin... ]
Van Halbert reopened TEIID-2702:
--------------------------------
Need these changes back ported to 8.4.1.
> Deploying google using example google.xml throws exception
> -----------------------------------------------------------
>
> Key: TEIID-2702
> URL: https://issues.jboss.org/browse/TEIID-2702
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.6
>
>
> Trying to deploy google using the example and the BatchSize config property is not recognized, error thrown:
> Caused by: java.lang.NoSuchMethodException: JBAS010474: Method setBatchSize not found
> at org.jboss.as.connector.util.Injection.inject(Injection.java:130)
> at org.jboss.as.connector.util.Injection.inject(Injection.java:83)
> at org.jboss.as.connector.services.resourceadapters.deployment.AbstractResourceAdapterDeploymentService$AbstractAS7RaDeployer.initAndInject(AbstractResourceAdapterDeploymentService.java:428)
> ... 8 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2702) Deploying google using example google.xml throws exception
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-2702?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-2702:
-------------------------------
Fix Version/s: 8.4.1
> Deploying google using example google.xml throws exception
> -----------------------------------------------------------
>
> Key: TEIID-2702
> URL: https://issues.jboss.org/browse/TEIID-2702
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.6
>
>
> Trying to deploy google using the example and the BatchSize config property is not recognized, error thrown:
> Caused by: java.lang.NoSuchMethodException: JBAS010474: Method setBatchSize not found
> at org.jboss.as.connector.util.Injection.inject(Injection.java:130)
> at org.jboss.as.connector.util.Injection.inject(Injection.java:83)
> at org.jboss.as.connector.services.resourceadapters.deployment.AbstractResourceAdapterDeploymentService$AbstractAS7RaDeployer.initAndInject(AbstractResourceAdapterDeploymentService.java:428)
> ... 8 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months