[JBoss JIRA] (TEIID-4657) Explain how the pojo module.xml should be configured
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4657?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4657:
----------------------------------
Fix Version/s: 9.3
> Explain how the pojo module.xml should be configured
> ----------------------------------------------------
>
> Key: TEIID-4657
> URL: https://issues.jboss.org/browse/TEIID-4657
> Project: Teiid
> Issue Type: Task
> Components: JDG Connector
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
> Fix For: 9.3
>
>
> The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
> {code}
> <?xml version="1.0" encoding="UTF-8"?>
> <module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
> <resources>
> <resource-root path="jdg-remote-cache-materialization-pojos.jar" />
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
> <module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
> </dependencies>
> </module>
> {code}
> Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-4822) predicate in on clause is not pushed down to view's underlying select statement
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4822:
-----------------------------------
Summary: predicate in on clause is not pushed down to view's underlying select statement
Key: TEIID-4822
URL: https://issues.jboss.org/browse/TEIID-4822
Project: Teiid
Issue Type: Enhancement
Affects Versions: 9.1.4
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Hi,
I have a view called tv_retrieve_labres that contains the following select statement
{code:sql}
SELECT
f.PatientID AS admissionid, f.Labogroep, f.SampleTime, f.EnterTime, f.varvalue, f.StringValue
FROM (
SELECT v.PatientID, v.Labogroep, v.SampleTime, v.EnterTime, v.varvalue, v.StringValue,
ROW_NUMBER() OVER (PARTITION BY v.PatientID, v.Labogroep, v.SampleTime ORDER BY v.EnterTime DESC) AS rang
FROM (
SELECT lcv.PatientID, lm.Labogroep, lcv.SampleTime, lcv.EnterTime, lcv.varvalue, lcv.StringValue,
ROW_NUMBER() OVER (PARTITION BY lcv.PatientID, lcv.variableid_oud, lcv.ResultID ORDER BY lcv.ResultNo DESC) AS rang
FROM izisprod.prod_U_P_LabMapping AS lm
INNER JOIN /*+ MAKEDEP */ izisprod.prod_U_PV_LabCorrectValues AS lcv ON
lcv.variableid_oud = lm.VariableID AND
bitand(convert(lcv.Status, integer), 8) = 8 AND
bitand(convert(lcv.Status, integer), 2) <> 2
UNION
SELECT lcv.PatientID, lm.Labogroep, lcv.SampleTime, lcv.EnterTime, lcv.varvalue, lcv.StringValue,
ROW_NUMBER() OVER (PARTITION BY lcv.PatientID, lcv.variableid_oud, lcv.ResultID ORDER BY lcv.ResultNo DESC) AS rang
FROM iziswh.wh_U_P_LabMapping AS lm
INNER JOIN /*+ MAKEDEP */ iziswh.wh_U_PV_LabCorrectValues AS lcv ON
lcv.variableid_oud = lm.VariableID AND
bitand(convert(lcv.Status, integer), 8) = 8 AND
bitand(convert(lcv.Status, integer), 2) <> 2
) AS v
WHERE v.rang = 1
) AS f
WHERE
f.rang = 1
{code}
When I execute the following select statement the value for lrs.Labogroep is not pushed down.
{code:sql}
select gd.patientid, lrs.varvalue, lrs.entertime, lrs.sampletime
from prod_P_GeneralData gd
join tv_retrieve_labres lrs on
lrs.admissionid = gd.PatientID
and lrs.Labogroep = 'pH-type'
and lrs.varvalue = 1
where gd.status = 1
{code}
Should this normally be working? I'm wondering if it doesn't work because of the union statement in the view.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-2465) Add additional size limitations
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2465?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-2465:
-----------------------------------
I need to revise the logic here. In the case of a tree, when the previous batches are removed the full cacheentry may not be retrieved and the size estimate isn't updated.
> Add additional size limitations
> -------------------------------
>
> Key: TEIID-2465
> URL: https://issues.jboss.org/browse/TEIID-2465
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.3
>
>
> We should introduce a limit to lob (which is currently only correct for up to 2 gigs) and single tuplebuffer results in storage as to prevent too much resource consumption from a single use.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-4815) How could I debug JDV memory allocation properly
by Rafael Coutinho (JIRA)
[ https://issues.jboss.org/browse/TEIID-4815?page=com.atlassian.jira.plugin... ]
Rafael Coutinho edited comment on TEIID-4815 at 3/21/17 6:13 PM:
-----------------------------------------------------------------
We got a heap dump and found out that this class was consuming 87% of the server memory:
SemaphoreArrayListManagedConnectionPool
That was managing an Oracle Datasource connection.
And searching the web I found this report:
https://access.redhat.com/solutions/742913
So we added that flag (maxCachedBufferSize) and have tested. It looks like the memory can get released.
Here is how our datasource is configured:
{{
<datasource jndi-name="java:/ORACLE_DS" pool-name="ORACLE_DS" enabled="true">
<connection-url>jdbc:oracle:thin:@oracleserver:1010:dev</connection-url>
<driver>ojdbc6-11g.jar</driver>
<pool>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>**</user-name>
<password>***</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>true</background-validation>
<background-validation-millis>10000</background-validation-millis>
</validation>
</datasource>
}}
Any other suggestions on configuring oracle datasources?
was (Author: rafael.coutinho):
We got a heap dump and found out that this class was consuming 87% of the server memory:
SemaphoreArrayListManagedConnectionPool
That was managing an Oracle Datasource connection.
And searching the web I found this report:
https://access.redhat.com/solutions/742913
So we added that flag (maxCachedBufferSize) and have tested. It looks like the memory can get released.
Here is how our datasource is configured:
{{<datasource jndi-name="java:/ORACLE_DS" pool-name="ORACLE_DS" enabled="true">
<connection-url>jdbc:oracle:thin:@oracleserver:1010:dev</connection-url>
<driver>ojdbc6-11g.jar</driver>
<pool>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>**</user-name>
<password>***</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>true</background-validation>
<background-validation-millis>10000</background-validation-millis>
</validation>
</datasource>}}
Any other suggestions on configuring oracle datasources?
> How could I debug JDV memory allocation properly
> ------------------------------------------------
>
> Key: TEIID-4815
> URL: https://issues.jboss.org/browse/TEIID-4815
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Rafael Coutinho
> Assignee: Steven Hawkins
> Attachments: Screenshot from 2017-03-17 17-54-24.png, Screenshot from 2017-03-17 18-14-50.png
>
>
> We hare having trouble with memory allocation on our JDV server (using Red Hat JBoss Data Virtualization - Version 6.3.0) for some reason memory gets allocated but never released.
> For simple queries memory increases just a little, however when we make complex joins etc, we are seeing scenarios with 20GB+ allocated heap.
> I wonder if there is any inspection tool for debugging what is consuming it in JDV.
> Our main datasource is an Oracle DS, but we do have a MariaDB being used too.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-4815) How could I debug JDV memory allocation properly
by Rafael Coutinho (JIRA)
[ https://issues.jboss.org/browse/TEIID-4815?page=com.atlassian.jira.plugin... ]
Rafael Coutinho commented on TEIID-4815:
----------------------------------------
We got a heap dump and found out that this class was consuming 87% of the server memory:
SemaphoreArrayListManagedConnectionPool
That was managing an Oracle Datasource connection.
And searching the web I found this report:
https://access.redhat.com/solutions/742913
So we added that flag (maxCachedBufferSize) and have tested. It looks like the memory can get released.
Here is how our datasource is configured:
{{<datasource jndi-name="java:/ORACLE_DS" pool-name="ORACLE_DS" enabled="true">
<connection-url>jdbc:oracle:thin:@oracleserver:1010:dev</connection-url>
<driver>ojdbc6-11g.jar</driver>
<pool>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>**</user-name>
<password>***</password>
</security>
<validation>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>true</background-validation>
<background-validation-millis>10000</background-validation-millis>
</validation>
</datasource>}}
Any other suggestions on configuring oracle datasources?
> How could I debug JDV memory allocation properly
> ------------------------------------------------
>
> Key: TEIID-4815
> URL: https://issues.jboss.org/browse/TEIID-4815
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Rafael Coutinho
> Assignee: Steven Hawkins
> Attachments: Screenshot from 2017-03-17 17-54-24.png, Screenshot from 2017-03-17 18-14-50.png
>
>
> We hare having trouble with memory allocation on our JDV server (using Red Hat JBoss Data Virtualization - Version 6.3.0) for some reason memory gets allocated but never released.
> For simple queries memory increases just a little, however when we make complex joins etc, we are seeing scenarios with 20GB+ allocated heap.
> I wonder if there is any inspection tool for debugging what is consuming it in JDV.
> Our main datasource is an Oracle DS, but we do have a MariaDB being used too.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-4821) Debug Plan is missing Annotation about JOIN Pushdown
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-4821:
-----------------------------------
Summary: Debug Plan is missing Annotation about JOIN Pushdown
Key: TEIID-4821
URL: https://issues.jboss.org/browse/TEIID-4821
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
When a translator supports the JOIN pushdown and the submitted query is not using the JOIN pushdown, there needs to be description in the plan as to why query planner did not include the JOIN in the pushdown query to translator. Currently this is not available.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-4657) Explain how the pojo module.xml should be configured
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4657?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4657:
------------------------------------
With the latest changes, there is no longer a need to add the dependency to the jdg resourcej-adapter to the module.xml
> Explain how the pojo module.xml should be configured
> ----------------------------------------------------
>
> Key: TEIID-4657
> URL: https://issues.jboss.org/browse/TEIID-4657
> Project: Teiid
> Issue Type: Task
> Components: JDG Connector
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
> {code}
> <?xml version="1.0" encoding="UTF-8"?>
> <module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
> <resources>
> <resource-root path="jdg-remote-cache-materialization-pojos.jar" />
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
> <module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
> </dependencies>
> </module>
> {code}
> Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years
[JBoss JIRA] (TEIID-4657) Explain how the pojo module.xml should be configured
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4657?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4657:
-------------------------------
Description:
The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
{code}
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
<resources>
<resource-root path="jdg-remote-cache-materialization-pojos.jar" />
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
<module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
</dependencies>
</module>
{code}
Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
was:
The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
{code}
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
<resources>
<resource-root path="jdg-remote-cache-materialization-pojos.jar" />
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
<module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
<module name="org.jboss.teiid.resource-adapter.infinispan.hotrod" export="true" />
</dependencies>
</module>
{code}
Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
> Explain how the pojo module.xml should be configured
> ----------------------------------------------------
>
> Key: TEIID-4657
> URL: https://issues.jboss.org/browse/TEIID-4657
> Project: Teiid
> Issue Type: Task
> Components: JDG Connector
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
> {code}
> <?xml version="1.0" encoding="UTF-8"?>
> <module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
> <resources>
> <resource-root path="jdg-remote-cache-materialization-pojos.jar" />
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
> <module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
> </dependencies>
> </module>
> {code}
> Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years