[JBoss JIRA] Created: (TEIIDDES-216) Designer removes parentheses around criteria in ansi join when using compound ON
by Marc Shirley (JIRA)
Designer removes parentheses around criteria in ansi join when using compound ON
--------------------------------------------------------------------------------
Key: TEIIDDES-216
URL: https://jira.jboss.org/jira/browse/TEIIDDES-216
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 6.1.0
Reporter: Marc Shirley
In Designer, when validating a transformation that has compound criteria in an ansi join statement's ON,…
[View More] the parentheses are removed and the order of operations is modified as a result. This does not appear to occur when using the same parentheses structure in WHERE criteria.
Before validation:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON (a.INTKEY = b.INTKEY) AND (a.INTNUM IS NULL OR a.INTNUM = 11)
After validation:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON a.INTKEY = b.INTKEY AND (a.INTNUM IS NULL) OR (a.INTNUM = 11)
After validating a second time:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON ((a.INTKEY = b.INTKEY) AND (a.INTNUM IS NULL)) OR (a.INTNUM = 11)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1519) NPE In Preview Manager When Empty Model Project And No Teiid Server Defined
by Dan Florian (JIRA)
Dan Florian created TEIIDDES-1519:
-------------------------------------
Summary: NPE In Preview Manager When Empty Model Project And No Teiid Server Defined
Key: TEIIDDES-1519
URL: https://issues.jboss.org/browse/TEIIDDES-1519
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 8.0
Environment: Eclipse 3.2.1, JBoss Tools 4.0.0.Alpha1, Designer 8.x-upgrade build 108, OS X …
[View More]10.8.2, JBoss AS 7.1.1.Final, Teiid 8.2.0.Beta2
Reporter: Dan Florian
Fix For: 8.0
I have a fresh Eclipse workspace with Designer perspective open. I have created a model project. The project is empty. Must've got the following error when I created the project.
java.lang.NullPointerException
at org.teiid.designer.runtime.preview.PreviewManager$1.done(PreviewManager.java:932)
at org.eclipse.core.internal.jobs.JobListeners$3.notify(JobListeners.java:39)
at org.eclipse.core.internal.jobs.JobListeners.doNotify(JobListeners.java:112)
at org.eclipse.core.internal.jobs.JobListeners.done(JobListeners.java:152)
at org.eclipse.core.internal.jobs.JobManager.endJob(JobManager.java:647)
at org.eclipse.core.internal.jobs.WorkerPool.endJob(WorkerPool.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:70)
--
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
[View Less]
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1466) url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1466?page=com.atlassian.jira.plu... ]
Johnathon Lee resolved TEIIDDES-1466.
-------------------------------------
Fix Version/s: 7.7.2
Resolution: Done
> url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1466
> …
[View More]URL: https://issues.jboss.org/browse/TEIIDDES-1466
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 7.7
> Environment: JBDS 5.0.1 with SOA-Tooling/EDS 5.3
> Reporter: Johnathon Lee
> Assignee: Johnathon Lee
> Fix For: 7.7.2
>
> Attachments: sfdcTest.zip
>
>
> The URL specified in the Salesforce connection profile in JBDS is not being written to the datasource when it is created from a JBDS action (either through preview functionality or Model->Create Datasource).
> Data sources created from Teiid Designer perspective do not include the SFDC URL input by the user. In some cases this results in the user being unable to authenticate and run queries against the datasource (preview or standard VDB queries) if their user id does not authenticate against the default login.salesforce.com site URLs. Need to correct the datasource creation behavior to push down the URL into the datasource as well.
> When creating the datasource using the Modelling->Create Data Source with the "Use Model Connection Info", the end result is the sfdcTest-ds.xml below:
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <connection-factories>
> <no-tx-connection-factory>
> <jndi-name>sfdcTest</jndi-name>
> <rar-name>teiid-connector-salesforce.rar</rar-name>
> <use-java-context>true</use-java-context>
> <connection-definition>javax.resource.cci.ConnectionFactory</connection-definition>
> <jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name>
> <min-pool-size>0</min-pool-size>
> <max-pool-size>10</max-pool-size>
> <blocking-timeout-millis>3000</blocking-timeout-millis>
> <idle-timeout-minutes>30</idle-timeout-minutes>
> <prefill>false</prefill>
> <background-validation>false</background-validation>
> <background-validation-millis>0</background-validation-millis>
> <validate-on-match>true</validate-on-match>
> <use-fast-fail>false</use-fast-fail>
> <statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter>
> <isSameRM-override-value>false</isSameRM-override-value>
> <allocation-retry>0</allocation-retry>
> <allocation-retry-wait-millis>5000</allocation-retry-wait-millis>
> <config-property type="java.lang.String" name="password">blahblahblah</config-property>
> <config-property type="java.lang.String" name="template-name">connector-salesforce</config-property>
> <config-property type="java.lang.String" name="username">mshirley.dev(a)redhat.com</config-property>
> </no-tx-connection-factory>
> </connection-factories>
> We should see an additional property of the URL (probably should look like the below example) stating the URL value from the model.
> <config-property type="java.lang.String" name="url">https://login.salesforce.com/services/Soap/u/25.0</config-property>
> Same behavior occurs when creating a data source using the connection profile option instead of the model connection info.
--
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
[View Less]
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1466) url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1466?page=com.atlassian.jira.plu... ]
Work on TEIIDDES-1466 started by Johnathon Lee.
> url config property for Salesforce being dropped from -ds.xml creation during deployment from JBDS 5.0
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1466
> URL: https://issues.jboss.org/browse/TEIIDDES-1466
> Project: Teiid …
[View More]Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 7.7
> Environment: JBDS 5.0.1 with SOA-Tooling/EDS 5.3
> Reporter: Johnathon Lee
> Assignee: Johnathon Lee
> Attachments: sfdcTest.zip
>
>
> The URL specified in the Salesforce connection profile in JBDS is not being written to the datasource when it is created from a JBDS action (either through preview functionality or Model->Create Datasource).
> Data sources created from Teiid Designer perspective do not include the SFDC URL input by the user. In some cases this results in the user being unable to authenticate and run queries against the datasource (preview or standard VDB queries) if their user id does not authenticate against the default login.salesforce.com site URLs. Need to correct the datasource creation behavior to push down the URL into the datasource as well.
> When creating the datasource using the Modelling->Create Data Source with the "Use Model Connection Info", the end result is the sfdcTest-ds.xml below:
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <connection-factories>
> <no-tx-connection-factory>
> <jndi-name>sfdcTest</jndi-name>
> <rar-name>teiid-connector-salesforce.rar</rar-name>
> <use-java-context>true</use-java-context>
> <connection-definition>javax.resource.cci.ConnectionFactory</connection-definition>
> <jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name>
> <min-pool-size>0</min-pool-size>
> <max-pool-size>10</max-pool-size>
> <blocking-timeout-millis>3000</blocking-timeout-millis>
> <idle-timeout-minutes>30</idle-timeout-minutes>
> <prefill>false</prefill>
> <background-validation>false</background-validation>
> <background-validation-millis>0</background-validation-millis>
> <validate-on-match>true</validate-on-match>
> <use-fast-fail>false</use-fast-fail>
> <statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter>
> <isSameRM-override-value>false</isSameRM-override-value>
> <allocation-retry>0</allocation-retry>
> <allocation-retry-wait-millis>5000</allocation-retry-wait-millis>
> <config-property type="java.lang.String" name="password">blahblahblah</config-property>
> <config-property type="java.lang.String" name="template-name">connector-salesforce</config-property>
> <config-property type="java.lang.String" name="username">mshirley.dev(a)redhat.com</config-property>
> </no-tx-connection-factory>
> </connection-factories>
> We should see an additional property of the URL (probably should look like the below example) stating the URL value from the model.
> <config-property type="java.lang.String" name="url">https://login.salesforce.com/services/Soap/u/25.0</config-property>
> Same behavior occurs when creating a data source using the connection profile option instead of the model connection info.
--
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
[View Less]
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1461) Elapsed Time in the JBoss developer studio shows incorrect timestamps
by Hisanobu Okuda (JIRA)
Hisanobu Okuda created TEIIDDES-1461:
----------------------------------------
Summary: Elapsed Time in the JBoss developer studio shows incorrect timestamps
Key: TEIIDDES-1461
URL: https://issues.jboss.org/browse/TEIIDDES-1461
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 7.4.2
Environment: JBDS 4.1.2
Reporter: Hisanobu Okuda
When you run the query in …
[View More]the JBoss developer studio, it is NOT showing correct elapsed timestamp.
For example, I know that it is taking more than 55 seconds for the below query when I run in the SQL Scrapbook window in the designer against VDB but it is showing as 0 hr, 0 min, 0 sec, 0 ms as shown below.
select * from "Salesforce_Source"."salesforce"."RecordType"
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[View Less]
12 years, 5 months