[JBoss JIRA] (TEIID-3341) Metadata load failure between retries of multi-source models
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-3341:
-----------------------------------
Summary: Metadata load failure between retries of multi-source models
Key: TEIID-3341
URL: https://issues.jboss.org/browse/TEIID-3341
Project: Teiid
Issue Type: Bug
Components: Server
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 8.10
The code will attempt to load from each source until one is successful. There is an issue however that the metadatafactory is not being reset, so the next load attempt will be against existing metadata. Hence the question about "Failed to get metadata, trying next source."
It happens to be, if the metadata factories are chained like "NATIVE, DDL", in that case even the DDL schema must be valid, so that Teiid does not retry to load metadata from next source in line.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 10 months
[JBoss JIRA] (TEIID-3158) VDB versioning does not work
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3158?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3158:
------------------------------------------------
Matus Makovy <mmakovy(a)redhat.com> changed the Status of [bug 1098413|https://bugzilla.redhat.com/show_bug.cgi?id=1098413] from MODIFIED to VERIFIED
> VDB versioning does not work
> ----------------------------
>
> Key: TEIID-3158
> URL: https://issues.jboss.org/browse/TEIID-3158
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.4.1
> Environment: - JDV 6.0.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
>
> The vdb "test.1.vdb" should be deployed as the vdb "test" of the version "1" as described in [1]. But, it is deployed as the vdb "test.1" in fact as following:-
> {code}
> 20:48:20,210 INFO [org.jboss.as.repository] (management-handler-thread - 6) JBAS014900: Content added at location /opt/dv600/jboss-eap-6.1/standalone/data/content/b8/a0bf2213af6edc2817c63f149f760d1d796cda/content
> 20:48:20,212 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "test.1.vdb" (runtime-name: "test.1.vdb")
> 20:48:20,270 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB test.1 model "SourceModel" metadata is currently being loaded. Start Time: 10/2/14 8:48 PM
> 20:48:20,273 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB test.1 model "ViewModel" metadata is currently being loaded. Start Time: 10/2/14 8:48 PM
> 20:48:20,296 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB test.1 model "ViewModel" metadata loaded. End Time: 10/2/14 8:48 PM
> 20:48:20,296 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB test.1 model "SourceModel" metadata loaded. End Time: 10/2/14 8:48 PM
> 20:48:20,300 INFO [org.jboss.as.server] (management-handler-thread - 6) JBAS018559: Deployed "test.1.vdb" (runtime-name : "test.1.vdb")
> 20:48:20,334 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) Data Source SourceModel not accessible.
> 20:48:20,334 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB test.1 is set to ACTIVE
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 10 months
[JBoss JIRA] (TEIID-3320) Use alternative implementation to Spring in CXF
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3320?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3320:
-------------------------------------
You can programtically do most of the stuff, but most of the CXF documentation uses Spring and as well as the Teiid documentation. I think I have seen JBoss Web folks extended CXFBuS to do some of these tasks. IMO it is not worth time chasing this for no added value. I am inclined to do "Won't Fix" resolution.
> Use alternative implementation to Spring in CXF
> -----------------------------------------------
>
> Key: TEIID-3320
> URL: https://issues.jboss.org/browse/TEIID-3320
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
>
> Use an alternative implementation to Spring in CXF
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 10 months
[JBoss JIRA] (TEIID-3334) MongoDB: invalid ip address and port number
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3334?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3334.
---------------------------------
Labels: CR2 (was: )
Resolution: Done
The URI semantics were defined here [http://docs.mongodb.org/manual/reference/connection-string/]
It happens to be Java driver example always used the server:host semantics and I missed this. Another advantage of using the URL is to define any connection specific options. For more details look at above URL
> MongoDB: invalid ip address and port number
> --------------------------------------------
>
> Key: TEIID-3334
> URL: https://issues.jboss.org/browse/TEIID-3334
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: MongoDB with Teiid 8.9.1
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: CR2
> Fix For: 8.10
>
>
> I got invalid IP address/ port number error when I have ":" in IP address.
> Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492)
> at java.lang.Integer.valueOf(Integer.java:582)
> at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 10 months
[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB using Teiid 8.9.1
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ]
Ramesh Reddy edited comment on TEIID-3316 at 2/16/15 4:50 PM:
--------------------------------------------------------------
There are multiple things wrong with the above test.
- Teiid does not support multi-level nesting in 8.9.1, as I see it you have top level, "test" and "testarray".
- Your schema does not reflect the your document. There is no link between Backup, test and TeiidArray. Those must be established using Foreign keys. If you used Teiid importer and it gave above schema then that is bug. Also Teiid MongoDB importer can not create multi-level tables like above yet.
The posted schema shows single level, that means the data *MUST* to be like
{code}
{"TeiidArray":[
{"_id": "541087c3f706400030000002", "FirstName": "Eugene", "Score": [ "Korean", "100", "Medium" ], "LastName": "T", "CustomerID": 1 },
{"_id": "541089051c4d5a0030000001", "FirstName": "Stas", "Score": [ "Japanese", "50", "Advance" ], "LastName": "C", "CustomerID": 2 },
{"_id": "5410c969516cd50064000001", "FirstName": "Sally", "Score": [ "Russian", "90", "Advance" ], "LastName": "F", "CustomerID": 3 }
]}
{code}
then you can issue
{code}
select FirstName from TeiidArray
{code}
The schema that matches your document needs to look like
{code}
<vdb name="mongo" version="1">
<model name="mongo">
<source name="local" translator-name="mongodb" connection-jndi-name="java:/mongoDS"/>
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE Backup (
BackupType String,
TestDate date PRIMARY KEY
) OPTIONS(UPDATABLE 'TRUE');
CREATE FOREIGN TABLE Test (
ID String PRIMARY KEY,
TestDate date,
FirstName varchar(25),
LastName varchar(25),
CustomerID integer,
Score object[],
FOREIGN KEY (TestDate) REFERENCES Backup (TestDate)
) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:MERGE" 'Backup');
]]>
</metadata>
</model>
</vdb>
{code}
then you can run SQL like
{code}
insert into Backup(BackupType, TestDate) values ('DBBackup', {d '2015-01-29'});
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('541087c3f706400030000002',{d '2015-01-29'}, 'Eugene', 'T', 1, ('Korean', '100', 'Medium'));
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('541089051c4d5a0030000001',{d '2015-01-29'}, 'Stas', 'C', 2, ('Japanese', '50', 'Advance'));
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('5410c969516cd50064000001',{d '2015-01-29'}, 'Sally', 'F', 3, ('Russian', '90', 'Advance'));
{code}
that will produce the JSON document in the MongoDB much closer to what you have
{code}
> db.Backup.find().pretty();
{
"_id" : ISODate("2015-01-29T06:00:00Z"),
"BackupType" : "DBBackup",
"Test" : [
{
"FirstName" : "Eugene",
"LastName" : "T",
"CustomerID" : 1,
"Score" : [
"Korean",
"100",
"Medium"
],
"_id" : "541087c3f706400030000002"
},
{
"FirstName" : "Stas",
"LastName" : "C",
"CustomerID" : 2,
"Score" : [
"Japanese",
"50",
"Advance"
],
"_id" : "541089051c4d5a0030000001"
},
{
"FirstName" : "Sally",
"LastName" : "F",
"CustomerID" : 3,
"Score" : [
"Russian",
"90",
"Advance"
],
"_id" : "5410c969516cd50064000001"
}
]
}
{code}
If you notice there is no verbose "test" level, which was just array of array without any links between the documents. Teiid *needs* to have that relationship between documents, in the above I used "TestDate" field to build that. Hopefully this explains how to use Teiid, and not all the MongoDB documents can be read easily through Teiid, it expects certain rules.
was (Author: rareddy):
There are multiple things wrong with the above test.
- Teiid does not support multi-level nesting in 8.9.1, as I see it you have top level, "test" and "testarray".
- Your schema does not reflect the your document. There is no link between Backup, test and TeiidArray. Those must be established using Foreign keys. If you used Teiid importer and it gave above schema then that is bug. Also Teiid MongoDB importer can not create multi-level tables like above yet.
The posted schema shows single level, that means the data *MUST* to be like
{code}
{"TeiidArray":[
{"_id": "541087c3f706400030000002", "FirstName": "Eugene", "Score": [ "Korean", "100", "Medium" ], "LastName": "T", "CustomerID": 1 },
{"_id": "541089051c4d5a0030000001", "FirstName": "Stas", "Score": [ "Japanese", "50", "Advance" ], "LastName": "C", "CustomerID": 2 },
{"_id": "5410c969516cd50064000001", "FirstName": "Sally", "Score": [ "Russian", "90", "Advance" ], "LastName": "F", "CustomerID": 3 }
]}
{code}
then you can issue
{code}
select FirstName from TeiidArray
{code}
The schema that matches your document needs to look like
{code}
<vdb name="mongo" version="1">
<model name="mongo">
<source name="local" translator-name="mongodb" connection-jndi-name="java:/mongoDS"/>
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE Backup (
BackupType String,
TestDate date PRIMARY KEY
) OPTIONS(UPDATABLE 'TRUE');
CREATE FOREIGN TABLE Test (
ID String PRIMARY KEY,
TestDate date,
FirstName varchar(25),
LastName varchar(25),
CustomerID integer,
Score object[],
FOREIGN KEY (TestDate) REFERENCES Backup (TestDate)
) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:MERGE" 'Backup');
]]>
</metadata>
</model>
</vdb>
{code}
then you can run SQL like
{code}
insert into Backup(BackupType, TestDate) values ('DBBackup', {d '2015-01-29'});
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('541087c3f706400030000002',{d '2015-01-29'}, 'Eugene', 'T', 1, ('Korean', '100', 'Medium'));
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('541089051c4d5a0030000001',{d '2015-01-29'}, 'Stas', 'C', 2, ('Japanese', '50', 'Advance'));
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('5410c969516cd50064000001',{d '2015-01-29'}, 'Sally', 'F', 3, ('Russian', '90', 'Advance'));
{code}
that will produce the JSON document in the MongoDB much closer to what you have
{code}
> db.Backup.find().pretty();
{
"_id" : ISODate("2015-01-29T06:00:00Z"),
"BackupType" : "DBBackup",
"Test" : [
{
"FirstName" : "Eugene",
"LastName" : "T",
"CustomerID" : 1,
"Score" : [
"Korean",
"100",
"Medium"
],
"_id" : "541087c3f706400030000002"
},
{
"FirstName" : "Stas",
"LastName" : "C",
"CustomerID" : 2,
"Score" : [
"Japanese",
"50",
"Advance"
],
"_id" : "541089051c4d5a0030000001"
},
{
"FirstName" : "Sally",
"LastName" : "F",
"CustomerID" : 3,
"Score" : [
"Russian",
"90",
"Advance"
],
"_id" : "5410c969516cd50064000001"
},
{
"FirstName" : "Eugene",
"LastName" : "T",
"CustomerID" : 1,
"Score" : [
"Korean",
"100",
"Medium"
],
"_id" : "541087c3f706400030000002"
},
{
"FirstName" : "Stas",
"LastName" : "C",
"CustomerID" : 2,
"Score" : [
"Japanese",
"50",
"Advance"
],
"_id" : "541089051c4d5a0030000001"
},
{
"FirstName" : "Sally",
"LastName" : "F",
"CustomerID" : 3,
"Score" : [
"Russian",
"90",
"Advance"
],
"_id" : "5410c969516cd50064000001"
}
]
}
{code}
If you notice there is no verbose "test" level, which was just array of array without any links between the documents. Teiid *needs* to have that relationship between documents, in the above I used "TestDate" field to build that. Hopefully this explains how to use Teiid, and not all the MongoDB documents can be read easily through Teiid, it expects certain rules.
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 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)
10 years, 10 months
[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 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.
---------------------------------
Resolution: Rejected
Rejecting based on the explanation in the previous comment. I did not encounter any issues with "cursor" error. If the error occurs with correct usage of Teiid with MongoDB, please open another JIRA or open this JIRA again with more details.
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 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)
10 years, 10 months
[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB using Teiid 8.9.1
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3316:
-------------------------------------
There are multiple things wrong with the above test.
- Teiid does not support multi-level nesting in 8.9.1, as I see it you have top level, "test" and "testarray".
- Your schema does not reflect the your document. There is no link between Backup, test and TeiidArray. Those must be established using Foreign keys. If you used Teiid importer and it gave above schema then that is bug. Also Teiid MongoDB importer can not create multi-level tables like above yet.
The posted schema shows single level, that means the data *MUST* to be like
{code}
{"TeiidArray":[
{"_id": "541087c3f706400030000002", "FirstName": "Eugene", "Score": [ "Korean", "100", "Medium" ], "LastName": "T", "CustomerID": 1 },
{"_id": "541089051c4d5a0030000001", "FirstName": "Stas", "Score": [ "Japanese", "50", "Advance" ], "LastName": "C", "CustomerID": 2 },
{"_id": "5410c969516cd50064000001", "FirstName": "Sally", "Score": [ "Russian", "90", "Advance" ], "LastName": "F", "CustomerID": 3 }
]}
{code}
then you can issue
{code}
select FirstName from TeiidArray
{code}
The schema that matches your document needs to look like
{code}
<vdb name="mongo" version="1">
<model name="mongo">
<source name="local" translator-name="mongodb" connection-jndi-name="java:/mongoDS"/>
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE Backup (
BackupType String,
TestDate date PRIMARY KEY
) OPTIONS(UPDATABLE 'TRUE');
CREATE FOREIGN TABLE Test (
ID String PRIMARY KEY,
TestDate date,
FirstName varchar(25),
LastName varchar(25),
CustomerID integer,
Score object[],
FOREIGN KEY (TestDate) REFERENCES Backup (TestDate)
) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:MERGE" 'Backup');
]]>
</metadata>
</model>
</vdb>
{code}
then you can run SQL like
{code}
insert into Backup(BackupType, TestDate) values ('DBBackup', {d '2015-01-29'});
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('541087c3f706400030000002',{d '2015-01-29'}, 'Eugene', 'T', 1, ('Korean', '100', 'Medium'));
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('541089051c4d5a0030000001',{d '2015-01-29'}, 'Stas', 'C', 2, ('Japanese', '50', 'Advance'));
insert into Test(ID, TestDate, FirstName, LastName, CustomerID, Score) values ('5410c969516cd50064000001',{d '2015-01-29'}, 'Sally', 'F', 3, ('Russian', '90', 'Advance'));
{code}
that will produce the JSON document in the MongoDB much closer to what you have
{code}
> db.Backup.find().pretty();
{
"_id" : ISODate("2015-01-29T06:00:00Z"),
"BackupType" : "DBBackup",
"Test" : [
{
"FirstName" : "Eugene",
"LastName" : "T",
"CustomerID" : 1,
"Score" : [
"Korean",
"100",
"Medium"
],
"_id" : "541087c3f706400030000002"
},
{
"FirstName" : "Stas",
"LastName" : "C",
"CustomerID" : 2,
"Score" : [
"Japanese",
"50",
"Advance"
],
"_id" : "541089051c4d5a0030000001"
},
{
"FirstName" : "Sally",
"LastName" : "F",
"CustomerID" : 3,
"Score" : [
"Russian",
"90",
"Advance"
],
"_id" : "5410c969516cd50064000001"
},
{
"FirstName" : "Eugene",
"LastName" : "T",
"CustomerID" : 1,
"Score" : [
"Korean",
"100",
"Medium"
],
"_id" : "541087c3f706400030000002"
},
{
"FirstName" : "Stas",
"LastName" : "C",
"CustomerID" : 2,
"Score" : [
"Japanese",
"50",
"Advance"
],
"_id" : "541089051c4d5a0030000001"
},
{
"FirstName" : "Sally",
"LastName" : "F",
"CustomerID" : 3,
"Score" : [
"Russian",
"90",
"Advance"
],
"_id" : "5410c969516cd50064000001"
}
]
}
{code}
If you notice there is no verbose "test" level, which was just array of array without any links between the documents. Teiid *needs* to have that relationship between documents, in the above I used "TestDate" field to build that. Hopefully this explains how to use Teiid, and not all the MongoDB documents can be read easily through Teiid, it expects certain rules.
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 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)
10 years, 10 months
[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB using Teiid 8.9.1
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-3316:
--------------------------------
Fix Version/s: 8.10
> MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 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)
10 years, 10 months
[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3281.
---------------------------------
Labels: CR2 (was: )
Resolution: Done
Fixed as part of TEIID-2561, if needs for back porting for DV, then I can do more targeted patch for it as TEIID-2561 contains bigger changes.
> MongoDB: EmptyStackException when joining tables
> ------------------------------------------------
>
> Key: TEIID-3281
> URL: https://issues.jboss.org/browse/TEIID-3281
> Project: Teiid
> Issue Type: Bug
> Components: Connector API
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Ramesh Reddy
> Labels: CR2
> Fix For: 8.10
>
> Attachments: mongodb-vdb.xml, server.log
>
>
> Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled.
> Example:
> {code}
> insert into customer2 values(1,'Pepa', 'Koukal');
> insert into customer2 values(2,'Jan', 'Tlemil');
> insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode');
> insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode');
> {code}
> {code}
> select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID
> {code}
> {code}
> Error:
> java.util.EmptyStackException
> at java.util.Stack.peek(Stack.java:102)
> at java.util.Stack.pop(Stack.java:84)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993)
> at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112)
> {code}
> VDB and log are in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 10 months
[JBoss JIRA] (TEIID-3334) MongoDB: invalid ip address and port number
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3334?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-3334:
--------------------------------
Fix Version/s: 8.10
> MongoDB: invalid ip address and port number
> --------------------------------------------
>
> Key: TEIID-3334
> URL: https://issues.jboss.org/browse/TEIID-3334
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.9.1
> Environment: MongoDB with Teiid 8.9.1
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Fix For: 8.10
>
>
> I got invalid IP address/ port number error when I have ":" in IP address.
> Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492)
> at java.lang.Integer.valueOf(Integer.java:582)
> at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 10 months