[JBoss JIRA] (TEIID-3369) Add a extension point to manipulate incoming sql
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3369?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3369:
---------------------------------------
Add a PreParser hook with some light refactoring to make the command context available. Is this good enough of a start?
> Add a extension point to manipulate incoming sql
> ------------------------------------------------
>
> Key: TEIID-3369
> URL: https://issues.jboss.org/browse/TEIID-3369
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> We should look at adding a client or server extension point for manipulating sql - just the sql string, pre resolving. This will allow more flexibility in dealing with clients that don't send queries directly understood by Teiid. For example a select for update.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3376) SQL Server 2008/2012 - incompatible data types in comparison after cast/convert
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3376?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3376.
-----------------------------------
Fix Version/s: 8.11
Resolution: Done
Added handling for the cast to time from timestamp for 2008+
> SQL Server 2008/2012 - incompatible data types in comparison after cast/convert
> -------------------------------------------------------------------------------
>
> Key: TEIID-3376
> URL: https://issues.jboss.org/browse/TEIID-3376
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Environment: OS: fedora 20
> java: oracle 1.7
> arch: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> If user want to cast/convert timestamp-value to time and then use it in comparison, Teiid throws an Exception:
> "SQLServerException: The data types datetime and time are incompatible in the greater than operator."
> Expected behavior:
> The query should return correct result as the SQL Server is able to handle similar queries (teiid does not have any problem with same query with oracle, postgres, mysql,...)
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3364) Teiid Embedded generic-soap run failed
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3364?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3364:
------------------------------------
I have added the following embedded examples:
* cassandra-as-a-datasourse
* embedded-portfolio
* excel-as-a-datasource
* generic-soap
* hbase-as-a-datasource
* ldap-as-a-datasource
* mongodb-as-a-datasource
* webservices-as-a-datasource
it all run fine in my environment.
> Teiid Embedded generic-soap run failed
> --------------------------------------
>
> Key: TEIID-3364
> URL: https://issues.jboss.org/browse/TEIID-3364
> Project: Teiid
> Issue Type: Enhancement
> Components: Embedded
> Reporter: Kylin Soong
> Assignee: Kylin Soong
>
> I test the 8.10 embedded-dist zip download, the generic-soap run failed with Connection reset exception.
> On the other sides, can we add more samples for teiid embedded mode?
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3376) SQL Server 2008/2012 - incompatible data types in comparison after cast/convert
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-3376:
-----------------------------------
Summary: SQL Server 2008/2012 - incompatible data types in comparison after cast/convert
Key: TEIID-3376
URL: https://issues.jboss.org/browse/TEIID-3376
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1
Environment: OS: fedora 20
java: oracle 1.7
arch: x86_64
Reporter: Juraj Duráni
Assignee: Steven Hawkins
If user want to cast/convert timestamp-value to time and then use it in comparison, Teiid throws an Exception:
"SQLServerException: The data types datetime and time are incompatible in the greater than operator."
Expected behavior:
The query should return correct result as the SQL Server is able to handle similar queries (teiid does not have any problem with same query with oracle, postgres, mysql,...)
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3371) Upgrade Teiid with EAP 6.4 Alpha
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3371?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3371:
-------------------------------------
Two issues I see are
- The BOM version never seems to be inline with root JBoss EAP version. i.e I can not find a BOm version that can do EAP 6.4.0-Alpha and then may be for product EAP 6.4.0.Final. Not sure the BOM is community vs product. The solution here is to move back depend upon the jboss-parent that root of the JBoss-EAP.
- I did not find the distribution file for EAP 6.4.0-Alpha in the maven, this will prohibit us from integration tests and as well building the server kit and Docker image.
> Upgrade Teiid with EAP 6.4 Alpha
> --------------------------------
>
> Key: TEIID-3371
> URL: https://issues.jboss.org/browse/TEIID-3371
> Project: Teiid
> Issue Type: Enhancement
> Components: Build/Kits
> Affects Versions: 8.11
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: diff.txt, status.txt
>
>
> Upgrade all the Teiid projects to be built based on EAP 6.4 Alpha. Currently, this would align with jboss-integration-platform-bom 6.0.0.CR25 and EAP Alpha version 7.5.0.Final-redhat-17. Note, 7.5.0.Final-redhat-17 is the version in the EAP kit, but only CR25 bom is available.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3121) Teiid Standalone Server
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3121.
---------------------------------
Fix Version/s: 8.10
(was: Open To Community)
Resolution: Done
Independent server distribution is now available from the download site.
Some some reason I could not assign Tom's name to assignee name
> Teiid Standalone Server
> -----------------------
>
> Key: TEIID-3121
> URL: https://issues.jboss.org/browse/TEIID-3121
> Project: Teiid
> Issue Type: Feature Request
> Components: Build/Kits
> Reporter: Tom Arnold
> Fix For: 8.10
>
>
> Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss.
> * Teiid Runtime
> * Teiid Web Console
> * JBoss EAP 6.1 Alpha
> * Resteasy JAX-RS Patch
> End result would simplify the installation process to:
> 1. Unzip Teiid server.
> 2. Run `bin/add-user.sh` script.
> 3. Deploy custom translators, VDB, etc.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years
[JBoss JIRA] (TEIID-3371) Upgrade Teiid with EAP 6.4 Alpha
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3371?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3371:
-------------------------------
Attachment: diff.txt
status.txt
The attached diff.txt and status.txt show the changes that I needed to do to get it to build.
> Upgrade Teiid with EAP 6.4 Alpha
> --------------------------------
>
> Key: TEIID-3371
> URL: https://issues.jboss.org/browse/TEIID-3371
> Project: Teiid
> Issue Type: Enhancement
> Components: Build/Kits
> Affects Versions: 8.11
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Attachments: diff.txt, status.txt
>
>
> Upgrade all the Teiid projects to be built based on EAP 6.4 Alpha. Currently, this would align with jboss-integration-platform-bom 6.0.0.CR25 and EAP Alpha version 7.5.0.Final-redhat-17. Note, 7.5.0.Final-redhat-17 is the version in the EAP kit, but only CR25 bom is available.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years