[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3128:
----------------------------------
Summary: Issue while querying Salesforce. (was: Issue while querying Salesforce using Teiid embedded. )
Fix Version/s: 8.9
Steps to Reproduce:
Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
-Changing the order of the From part makes it run fine
was:
Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
-Changing the order of the From part makes it run fine
Affects Version/s: 8.4
Component/s: Salesforce Connector
Forum Reference: https://developer.jboss.org/thread/248796
> Issue while querying Salesforce.
> ---------------------------------
>
> Key: TEIID-3128
> URL: https://issues.jboss.org/browse/TEIID-3128
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 8.4
> Reporter: Pranav K
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> (I am using Teiid Embedded 8.8.0.Final)
> Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796
> Steps to reproduce at my end:
> 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
> 2) Execute the queries as shown in the steps below
> 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
> -Changing the order of the From part makes it run fine
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3120) honor javax.sql.DataSource LoginTimeout
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3120?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3120.
-----------------------------------
Fix Version/s: 8.9
Resolution: Done
Added support for the DataSource loginTimeout via a new driver property loginTimeout, which is the time in seconds before we'll an exception will be thrown on connecting. This is based upon checking a timeout value when a socket timeout occurs, so it is dependent upon the soTimeout rather than on another thread to explicitly interrupt. The soTimeout default was changed to 1000 (rather than 3000 / 3 seconds) so that it's resolution will roughly correspond to the second interval of login timeout. We can introduce usage of the Statement enhanced timer if we want to allow shorter timeouts and/or more precise control over when they occur via an interrupt. Also the handshake retries were modified to instead be based upon the synch ttl rather than being hard coded - but that has the effect of lengthening the handshake timeout from the current default of effectively 30 seconds to 240 seconds. However since users can now set the login timeout that is a more effective value to control that behavior rather than tuning soTimeout / synch ttl.
> honor javax.sql.DataSource LoginTimeout
> ---------------------------------------
>
> Key: TEIID-3120
> URL: https://issues.jboss.org/browse/TEIID-3120
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver
> Affects Versions: 8.4.2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> setLoginTimeout is currently not honored.
> Modify [1] to generate a reproducer. Use [2] in order to simulate an unresponsive Teiid instance.
>
> [1]
> https://github.com/teiid/teiid-quickstarts/tree/8.4.x/simpleclient
> add ds.setLoginTimeout(1) to JDBCClient.getDataSourceConnection
> [2]
> sudo iptables -I INPUT 1 -m state --state NEW -m tcp -p tcp --dport 31000 -j DROP
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce using Teiid embedded.
by Pranav K (JIRA)
[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ]
Pranav K updated TEIID-3128:
----------------------------
Description:
(I am using Teiid Embedded 8.8.0.Final)
Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796
Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
-Changing the order of the From part makes it run fine
was:
Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796
Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
-Changing the order of the From part makes it run fine
> Issue while querying Salesforce using Teiid embedded.
> ------------------------------------------------------
>
> Key: TEIID-3128
> URL: https://issues.jboss.org/browse/TEIID-3128
> Project: Teiid
> Issue Type: Bug
> Reporter: Pranav K
> Assignee: Steven Hawkins
>
> (I am using Teiid Embedded 8.8.0.Final)
> Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796
> Steps to reproduce at my end:
> 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
> 2) Execute the queries as shown in the steps below
> 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
> -Changing the order of the From part makes it run fine
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce using Teiid embedded.
by Pranav K (JIRA)
Pranav K created TEIID-3128:
-------------------------------
Summary: Issue while querying Salesforce using Teiid embedded.
Key: TEIID-3128
URL: https://issues.jboss.org/browse/TEIID-3128
Project: Teiid
Issue Type: Bug
Reporter: Pranav K
Assignee: Steven Hawkins
Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796
Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
-Changing the order of the From part makes it run fine
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3127) Multiple subquery arguments prevent plan completion
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3127:
-------------------------------------
Summary: Multiple subquery arguments prevent plan completion
Key: TEIID-3127
URL: https://issues.jboss.org/browse/TEIID-3127
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.7.1, 8.9
The evaluator is closed after each successful evaluation, but the values are not saved so multiple subqueries in the same logical operation will cause indefinite blocking.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 4 months
[JBoss JIRA] (TEIID-3124) InetAddress getLocalHost return UnknownHostException cause Teiid service start failed in JBoss Server
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3124?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3124.
-----------------------------------
Resolution: Done
Removed the possibility of an exception from the server side code and clarified the logic in the embedded case.
> InetAddress getLocalHost return UnknownHostException cause Teiid service start failed in JBoss Server
> -----------------------------------------------------------------------------------------------------
>
> Key: TEIID-3124
> URL: https://issues.jboss.org/browse/TEIID-3124
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.7
> Environment: JDV 6.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 8.7.1, 8.9
>
>
> After install JDV 6.0.0.GA via
> java -jar jboss-dv-installer-6.0.0.GA-redhat-4.jar
> start JDV throw the following exception cause some of servers start failed:
> ~~~
> 17:17:35,824 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-8) MSC000001: Failed to start service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_55]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address
> at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82)
> at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103)
> at org.teiid.transport.SocketListener.<init>(SocketListener.java:55)
> at org.teiid.jboss.TransportService.start(TransportService.java:157)
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
> ... 3 more
> 17:17:35,844 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC000001: Failed to start service jboss.teiid.transport.odbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.odbc: Failed to start service
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_55]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address
> at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82)
> at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103)
> at org.teiid.transport.SocketListener.<init>(SocketListener.java:55)
> at org.teiid.transport.ODBCSocketListener.<init>(ODBCSocketListener.java:43)
> at org.teiid.jboss.TransportService.start(TransportService.java:181)
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
> ... 3 more
> ~~~
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 4 months