[JBoss JIRA] (TEIID-5252) Teiid Wildfly Swarm Odata
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5252?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5252:
-------------------------------------
I found TEIID-5251 so I can't get past it, once that update is available I will re-test this.
> Teiid Wildfly Swarm Odata
> --------------------------
>
> Key: TEIID-5252
> URL: https://issues.jboss.org/browse/TEIID-5252
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Arvind Gopinath
> Assignee: Ramesh Reddy
> Priority: Minor
>
> Through Teiid Wildfly SWARM (examples code), I could able to run connecting below VDB and through SQL client, I could able to access my tables as well.
> To expose the same through Odata, in my pom.xml, I added below dependency.
> <dependency>
> <groupId>org.wildfly.swarm</groupId>
> <artifactId>odata</artifactId>
> <version>2018.1.0</version>
> </dependency>
> When my jar starts, I saw odata.war deployed and even my VDB added and through Sql client I could able to connect.
> 2018-02-08 15:30:31,119 INFO [org.jboss.as.server] (main) WFLYSRV0010: Deployed "odata.war" (runtime-name : "odata.war")
> 2018-02-08 15:30:31,493 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB sqlite.1 added to the repository
> 2018-02-08 15:30:31,497 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB sqlite.1 model "client" metadata is currently being loaded. Start Time: 8/02/18 3:30 PM
> But when I hit the URL,
> http://localhost:8080/odata4/sqlite.1/client.client
> I am getting error message below - Is it something I am missing?
> { "error": { "code": "38000", "message": "38000 TEIID10036 org.teiid.core.TeiidException: TEIID10036 org.teiid.core.TeiidRuntimeException: TEIID40067 javax.naming.NameNotFoundException: teiid\/queryengine\/odata -- service jboss.naming.context.java.teiid.queryengine.odata" } }
> Teiid Designer - Generated simple VDB.xml
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="sqlite" version="1">
> <description>SQLite VDB</description>
> <model name="client">
> <property name="importer.useFullSchemaName" value="false"/>
> <!-- https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtuali... -->
> <!-- <property name="importer.tableNamePattern" value="CLI%"/> -->
> <property name="importer.excludeTables" value="FIL.*|ORDER.*"/>
> <source name="sqlite-connector" translator-name="jdbc-simple" connection-jndi-name="java:jboss/datasources/demoDS"/>
> </model>
> </vdb>
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5252) Teiid Wildfly Swarm Odata
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5252?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIID-5252:
-----------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
> Teiid Wildfly Swarm Odata
> --------------------------
>
> Key: TEIID-5252
> URL: https://issues.jboss.org/browse/TEIID-5252
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Arvind Gopinath
> Assignee: Ramesh Reddy
> Priority: Minor
>
> Through Teiid Wildfly SWARM (examples code), I could able to run connecting below VDB and through SQL client, I could able to access my tables as well.
> To expose the same through Odata, in my pom.xml, I added below dependency.
> <dependency>
> <groupId>org.wildfly.swarm</groupId>
> <artifactId>odata</artifactId>
> <version>2018.1.0</version>
> </dependency>
> When my jar starts, I saw odata.war deployed and even my VDB added and through Sql client I could able to connect.
> 2018-02-08 15:30:31,119 INFO [org.jboss.as.server] (main) WFLYSRV0010: Deployed "odata.war" (runtime-name : "odata.war")
> 2018-02-08 15:30:31,493 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB sqlite.1 added to the repository
> 2018-02-08 15:30:31,497 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB sqlite.1 model "client" metadata is currently being loaded. Start Time: 8/02/18 3:30 PM
> But when I hit the URL,
> http://localhost:8080/odata4/sqlite.1/client.client
> I am getting error message below - Is it something I am missing?
> { "error": { "code": "38000", "message": "38000 TEIID10036 org.teiid.core.TeiidException: TEIID10036 org.teiid.core.TeiidRuntimeException: TEIID40067 javax.naming.NameNotFoundException: teiid\/queryengine\/odata -- service jboss.naming.context.java.teiid.queryengine.odata" } }
> Teiid Designer - Generated simple VDB.xml
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="sqlite" version="1">
> <description>SQLite VDB</description>
> <model name="client">
> <property name="importer.useFullSchemaName" value="false"/>
> <!-- https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtuali... -->
> <!-- <property name="importer.tableNamePattern" value="CLI%"/> -->
> <property name="importer.excludeTables" value="FIL.*|ORDER.*"/>
> <source name="sqlite-connector" translator-name="jdbc-simple" connection-jndi-name="java:jboss/datasources/demoDS"/>
> </model>
> </vdb>
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5252) Teiid Wildfly Swarm Odata
by Arvind Gopinath (JIRA)
Arvind Gopinath created TEIID-5252:
--------------------------------------
Summary: Teiid Wildfly Swarm Odata
Key: TEIID-5252
URL: https://issues.jboss.org/browse/TEIID-5252
Project: Teiid
Issue Type: Feature Request
Reporter: Arvind Gopinath
Assignee: Steven Hawkins
Priority: Minor
Through Teiid Wildfly SWARM (examples code), I could able to run connecting below VDB and through SQL client, I could able to access my tables as well.
To expose the same through Odata, in my pom.xml, I added below dependency.
<dependency>
<groupId>org.wildfly.swarm</groupId>
<artifactId>odata</artifactId>
<version>2018.1.0</version>
</dependency>
When my jar starts, I saw odata.war deployed and even my VDB added and through Sql client I could able to connect.
2018-02-08 15:30:31,119 INFO [org.jboss.as.server] (main) WFLYSRV0010: Deployed "odata.war" (runtime-name : "odata.war")
2018-02-08 15:30:31,493 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB sqlite.1 added to the repository
2018-02-08 15:30:31,497 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB sqlite.1 model "client" metadata is currently being loaded. Start Time: 8/02/18 3:30 PM
But when I hit the URL,
http://localhost:8080/odata4/sqlite.1/client.client
I am getting error message below - Is it something I am missing?
{ "error": { "code": "38000", "message": "38000 TEIID10036 org.teiid.core.TeiidException: TEIID10036 org.teiid.core.TeiidRuntimeException: TEIID40067 javax.naming.NameNotFoundException: teiid\/queryengine\/odata -- service jboss.naming.context.java.teiid.queryengine.odata" } }
Teiid Designer - Generated simple VDB.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="sqlite" version="1">
<description>SQLite VDB</description>
<model name="client">
<property name="importer.useFullSchemaName" value="false"/>
<!-- https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtuali... -->
<!-- <property name="importer.tableNamePattern" value="CLI%"/> -->
<property name="importer.excludeTables" value="FIL.*|ORDER.*"/>
<source name="sqlite-connector" translator-name="jdbc-simple" connection-jndi-name="java:jboss/datasources/demoDS"/>
</model>
</vdb>
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5237) Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5237?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5237.
-----------------------------------
Resolution: Done
Introduced a samplSize import property to sample multiple documents to capture the best possible representation. Also added a note in the docs about predicates not matching with mixed types.
> Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
> -------------------------------------------------------------------------------------------
>
> Key: TEIID-5237
> URL: https://issues.jboss.org/browse/TEIID-5237
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.3
> Environment: TEIID Embedded Server 8.12.3
> Datasource DB - MongoDB 3.4
> Java 1.7.0_71
> Reporter: Andriy G
> Assignee: Steven Hawkins
> Fix For: 10.2
>
>
> Issue to search for values using IN operator against MongoDB document containing field values both string and integer. Resultset simply filters out INTEGER values that stored in that field
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5251) OData WAR Module issue with WildFly-Swarm
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5251?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-5251.
---------------------------------
Fix Version/s: 10.2
10.0.3
10.1.1
Resolution: Done
Created a new module name that reflects the artifact name to avoid the resolving issues.
> OData WAR Module issue with WildFly-Swarm
> -----------------------------------------
>
> Key: TEIID-5251
> URL: https://issues.jboss.org/browse/TEIID-5251
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 10.2, 10.0.3, 10.1.1
>
>
> This issue is only applicable to WildFly-Swarm based Teiid when using OData.
> OData V4 war file uses the "org.apache.commons.lang" version "3.3.2", however, due to the nature of how Wildfly-Swarm loads the classes it is unable to load the module for the same.
> Looks like WildFly-Swarm also makes use of artifacts maven co-ordinates in some fashion from the feature-pack definitions then builds the classpath based on module definition. This is not consistent with WildFly but seems logical. To fix this module definition needs to be updated in Teiid then Teiid version needs to be updated WF-Swaram for OData to work correctly.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month