[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-3316:
----------------------------------
Thanks for fixing this issue. When is the target release date for 8.10?
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
> --------------------------------------------------------------------------------------------------
>
> Key: TEIID-3316
> URL: https://issues.jboss.org/browse/TEIID-3316
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: Final
> Fix For: 8.10
>
>
> I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1:
> Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"}
> at com.mongodb.CommandResult.getException(CommandResult.java:76)
> at com.mongodb.CommandResult.throwOnError(CommandResult.java:131)
> at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100)
> at com.mongodb.DBCollection.aggregate(DBCollection.java:1571)
> at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111)
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months
[JBoss JIRA] (TEIID-3260) Create custom metadata repository that uses Modeshape
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3260?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3260:
-------------------------------------
I think we need to check out how Komodo developed their CND files for "Library" mode? That should be the node structure that needs to be used to be compatible with tooling.
What we need to make sure is Komodo is developing this CND file and as well as the framework with required API around it in terms of inserting, updating/modifying and deleting this metadata in modular fashion in separate plugin that can be used by Teiid. Better, we need to move that project under Teiid organization. Then we can start writing the Teiid layer. [~blafond] can you comment on this, as it seemed that this portion of the development was nearly complete from our last discussion.
>From here [https://developer.jboss.org/en/artificer/blog/2015/02/20/artificers-ramp-...] , Ideally I would like us to design one runtime repository, where we can support the dependency/impact analysis stuff.
> Create custom metadata repository that uses Modeshape
> -----------------------------------------------------
>
> Key: TEIID-3260
> URL: https://issues.jboss.org/browse/TEIID-3260
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Affects Versions: 8.10
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> Create a custom metadata repository implementation that uses ModeShape as the repository for obtaining the VDB metadata for deployment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months
[JBoss JIRA] (TEIID-3348) MongoDB: Teiid 8.10 CR are not compatible with MongoDB 2.4.8
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3348?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3348.
---------------------------------
Labels: Final (was: )
Resolution: Done
The root cause is TEIID-3316, however added code to avoid NPE error in future.
> MongoDB: Teiid 8.10 CR are not compatible with MongoDB 2.4.8
> -------------------------------------------------------------
>
> Key: TEIID-3348
> URL: https://issues.jboss.org/browse/TEIID-3348
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.10
> Environment: Teiid 8.10 with MongoDB 2.4.8
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: Final
> Fix For: 8.10
>
>
> I am not able to run any query with with Teiid 8.10 CR1 against MongoDB version 2.4.8. But it works for MongoDB version 2.6.6
> Caused by: java.lang.NullPointerException
> at org.teiid.translator.mongodb.MongoDBQueryExecution.close(MongoDBQueryExecution.java:144)
> at org.teiid.translator.mongodb.MongoDBQueryExecution.cancel(MongoDBQueryExecution.java:150)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.cancel(ConnectorWorkItem.java:191)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:209)
> at $Proxy183.cancel(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.fullyCloseSource(DataTierTupleSource.java:323)
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:378)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months
[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3316.
---------------------------------
Labels: Final (was: )
Resolution: Done
Corrected the usage of AggregateOptions object during the execution of aggregate call between version 2.4 and 2.6.
The current MongoDB defaults to version 2.4 in the Teiid translator, when working with 2.6 or above users need to override translator property to set the correct version of the mongodb as below in the vdb.xml file
{code}
<translator name="mongo" type="mongodb">
<property name="supportsDirectQueryProcedure" value="true"/>
<property name="databaseVersion" value="2.6"/>
</translator>
{code}
Will update the default version of the Mongo to 2.8 possibly in Teiid 8.11
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
> --------------------------------------------------------------------------------------------------
>
> Key: TEIID-3316
> URL: https://issues.jboss.org/browse/TEIID-3316
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: Final
> Fix For: 8.10
>
>
> I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1:
> Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"}
> at com.mongodb.CommandResult.getException(CommandResult.java:76)
> at com.mongodb.CommandResult.throwOnError(CommandResult.java:131)
> at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100)
> at com.mongodb.DBCollection.aggregate(DBCollection.java:1571)
> at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111)
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months
[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reopened TEIID-3316:
---------------------------------
This also reported at https://jira.mongodb.org/browse/SERVER-11415
This is due the AggregateOptions object that is being used at the time of execution. The Cursor option is introduced in 2.6, thus using this option with 2.4 resulting in error rightfully.
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
> --------------------------------------------------------------------------------------------------
>
> Key: TEIID-3316
> URL: https://issues.jboss.org/browse/TEIID-3316
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Fix For: 8.10
>
>
> I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1:
> Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"}
> at com.mongodb.CommandResult.getException(CommandResult.java:76)
> at com.mongodb.CommandResult.throwOnError(CommandResult.java:131)
> at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100)
> at com.mongodb.DBCollection.aggregate(DBCollection.java:1571)
> at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111)
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months
[JBoss JIRA] (TEIID-2384) Managing Spatial Data Types
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-2384?page=com.atlassian.jira.plugin... ]
Tom Arnold edited comment on TEIID-2384 at 2/23/15 9:30 AM:
------------------------------------------------------------
Added ST_AsEWKT and ST_AsKML.
Edit: Moved to TEIID-3350.
was (Author: tom9729):
Added ST_AsEWKT and ST_AsKML.
Edit: Mofved to TEIID-3350.
> Managing Spatial Data Types
> ---------------------------
>
> Key: TEIID-2384
> URL: https://issues.jboss.org/browse/TEIID-2384
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 8.2
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Labels: spatial, types
> Fix For: 8.10
>
>
> It would be useful to be able to consume data from spatial database exposing the VDB as a spatial database to other application (imagine geoserver).
> TEIID could be strategic for merging georeferenced data and make it available to those systems.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months
[JBoss JIRA] (TEIID-2384) Managing Spatial Data Types
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-2384?page=com.atlassian.jira.plugin... ]
Tom Arnold edited comment on TEIID-2384 at 2/23/15 9:30 AM:
------------------------------------------------------------
Added ST_AsEWKT and ST_AsKML.
Edit: Mofved to TEIID-3350.
was (Author: tom9729):
Added ST_AsEWKT and ST_AsKML: https://github.com/teiid/teiid/pull/411
> Managing Spatial Data Types
> ---------------------------
>
> Key: TEIID-2384
> URL: https://issues.jboss.org/browse/TEIID-2384
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 8.2
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Labels: spatial, types
> Fix For: 8.10
>
>
> It would be useful to be able to consume data from spatial database exposing the VDB as a spatial database to other application (imagine geoserver).
> TEIID could be strategic for merging georeferenced data and make it available to those systems.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 2 months