[JBoss JIRA] (TEIID-4945) Teiid java client error (Column name "VDBName" does not exist)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4945?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4945:
---------------------------------------
You can add properties to the url: jdbc:teiid:ontop_dbVDB@mm://localhost:31000?useJDBC4ColumnNameAndLabelSemantics=false
> Teiid java client error (Column name "VDBName" does not exist)
> --------------------------------------------------------------
>
> Key: TEIID-4945
> URL: https://issues.jboss.org/browse/TEIID-4945
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 9.2.3
> Environment: Running teiid 9.2.3 on wildfly, failing using java client with 9.2.3 driver and sucess using protege with driver 9.2.3. both use ontop for mapping the data from db to the ontology.
> Reporter: Fábio Guilherme
> Assignee: Steven Hawkins
>
> This java client uses ontop to make the mapping from a db to a ontology. I had prior version where i was mapping my data from a postgres db to the ontology using ontop, in my recent version i changed the db to a teiid db(where i get the error).
> Using teiid 9.2.3 and wildfly with java client with 9.2.3 driver i get this error:
> {color:red}Error obtaining the Metadataorg.teiid.jdbc.TeiidSQLException: Column name "VDBName" does not exist.
> 09:31:15.411 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - Could not initialize the Quest query answering engine. Answering queries will not be available.
> 09:31:15.427 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - java.lang.NullPointerException
> it.unibz.krdb.obda.model.OBDAException: java.lang.NullPointerException{color}
> i used the same driver(9.2.3) on protege with ontop-pro and i dont get any error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4945) Teiid java client error (Column name "VDBName" does not exist)
by Fábio Guilherme (JIRA)
[ https://issues.jboss.org/browse/TEIID-4945?page=com.atlassian.jira.plugin... ]
Fábio Guilherme commented on TEIID-4945:
----------------------------------------
This how define my connection to the VDB, this is the same configuration that i use in protege:
sourceUri datasource1
connectionUrl jdbc:teiid:ontop_dbVDB@mm://localhost:31000
username user
password user1234
driverClass org.teiid.jdbc.TeiidDriver
> Teiid java client error (Column name "VDBName" does not exist)
> --------------------------------------------------------------
>
> Key: TEIID-4945
> URL: https://issues.jboss.org/browse/TEIID-4945
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 9.2.3
> Environment: Running teiid 9.2.3 on wildfly, failing using java client with 9.2.3 driver and sucess using protege with driver 9.2.3. both use ontop for mapping the data from db to the ontology.
> Reporter: Fábio Guilherme
> Assignee: Steven Hawkins
>
> This java client uses ontop to make the mapping from a db to a ontology. I had prior version where i was mapping my data from a postgres db to the ontology using ontop, in my recent version i changed the db to a teiid db(where i get the error).
> Using teiid 9.2.3 and wildfly with java client with 9.2.3 driver i get this error:
> {color:red}Error obtaining the Metadataorg.teiid.jdbc.TeiidSQLException: Column name "VDBName" does not exist.
> 09:31:15.411 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - Could not initialize the Quest query answering engine. Answering queries will not be available.
> 09:31:15.427 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - java.lang.NullPointerException
> it.unibz.krdb.obda.model.OBDAException: java.lang.NullPointerException{color}
> i used the same driver(9.2.3) on protege with ontop-pro and i dont get any error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4948) java.lang.IllegalArgumentException: No marshaller registered for ispn.G1
by Van Halbert (JIRA)
Van Halbert created TEIID-4948:
----------------------------------
Summary: java.lang.IllegalArgumentException: No marshaller registered for ispn.G1
Key: TEIID-4948
URL: https://issues.jboss.org/browse/TEIID-4948
Project: Teiid
Issue Type: Bug
Components: Infinispan
Affects Versions: 9.3
Reporter: Van Halbert
Assignee: Ramesh Reddy
Attachments: jdg-remote-cache-ddl-vdb.xml
Deploying a VDB that contains 2 models with tables that reference the same JNDI, but defined different caches. (see vdb attached).
Can query both caches and based on results, I know they are not the same cache.
When performing an insert to the first table (G1) it works. When performing an insert to other table (G2), get the IllegalArgmentException.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4945) Teiid java client error (Column name "VDBName" does not exist)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4945?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4945:
---------------------------------------
The flag can be set as a connection or DataSource property.
> Teiid java client error (Column name "VDBName" does not exist)
> --------------------------------------------------------------
>
> Key: TEIID-4945
> URL: https://issues.jboss.org/browse/TEIID-4945
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 9.2.3
> Environment: Running teiid 9.2.3 on wildfly, failing using java client with 9.2.3 driver and sucess using protege with driver 9.2.3. both use ontop for mapping the data from db to the ontology.
> Reporter: Fábio Guilherme
> Assignee: Steven Hawkins
>
> This java client uses ontop to make the mapping from a db to a ontology. I had prior version where i was mapping my data from a postgres db to the ontology using ontop, in my recent version i changed the db to a teiid db(where i get the error).
> Using teiid 9.2.3 and wildfly with java client with 9.2.3 driver i get this error:
> {color:red}Error obtaining the Metadataorg.teiid.jdbc.TeiidSQLException: Column name "VDBName" does not exist.
> 09:31:15.411 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - Could not initialize the Quest query answering engine. Answering queries will not be available.
> 09:31:15.427 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - java.lang.NullPointerException
> it.unibz.krdb.obda.model.OBDAException: java.lang.NullPointerException{color}
> i used the same driver(9.2.3) on protege with ontop-pro and i dont get any error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4896) Two VDB's referencing same teiid_ispn:cache is not using the same cache
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4896?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4896:
-------------------------------
Component/s: Infinispan
(was: JDG Connector)
> Two VDB's referencing same teiid_ispn:cache is not using the same cache
> -----------------------------------------------------------------------
>
> Key: TEIID-4896
> URL: https://issues.jboss.org/browse/TEIID-4896
> Project: Teiid
> Issue Type: Bug
> Components: Infinispan
> Affects Versions: 9.3
> Reporter: Van Halbert
> Fix For: 9.3.1
>
> Attachments: jdg-remote-cache-ddl-vdb.xml, jdg-remote-cache-registered-pb-vdb.xml
>
>
> I have 2 VDB's where they both reference the same cache using OPTIONS property:
> "teiid_ispn:cache" 'datasourceCache'
> However, when I insert into one VDB, its not seen by the other VDB.
> This was testing out the translators ability to use an already registered protobuf in Infinispan.
> The first VDB (jdg-remote-cache-vdb.xml) was deployed and then inserted and selected the results. This registered the protobuf.
> The second VDB (jdg-remote-cache-registered-pb-vdb.xml) was then deployed and was expecting to be able to read the same cache. The metadata was derived correctly, but it appears that one of the two are using the default cache, not the specified cache.
> I'll attach the vdb's.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4945) Teiid java client error (Column name "VDBName" does not exist)
by Fábio Guilherme (JIRA)
[ https://issues.jboss.org/browse/TEIID-4945?page=com.atlassian.jira.plugin... ]
Fábio Guilherme commented on TEIID-4945:
----------------------------------------
where do i change that flag?
it seems strange that the protege can connect and querie my VDB and my java client cant.
> Teiid java client error (Column name "VDBName" does not exist)
> --------------------------------------------------------------
>
> Key: TEIID-4945
> URL: https://issues.jboss.org/browse/TEIID-4945
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 9.2.3
> Environment: Running teiid 9.2.3 on wildfly, failing using java client with 9.2.3 driver and sucess using protege with driver 9.2.3. both use ontop for mapping the data from db to the ontology.
> Reporter: Fábio Guilherme
> Assignee: Steven Hawkins
>
> This java client uses ontop to make the mapping from a db to a ontology. I had prior version where i was mapping my data from a postgres db to the ontology using ontop, in my recent version i changed the db to a teiid db(where i get the error).
> Using teiid 9.2.3 and wildfly with java client with 9.2.3 driver i get this error:
> {color:red}Error obtaining the Metadataorg.teiid.jdbc.TeiidSQLException: Column name "VDBName" does not exist.
> 09:31:15.411 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - Could not initialize the Quest query answering engine. Answering queries will not be available.
> 09:31:15.427 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - java.lang.NullPointerException
> it.unibz.krdb.obda.model.OBDAException: java.lang.NullPointerException{color}
> i used the same driver(9.2.3) on protege with ontop-pro and i dont get any error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4945) Teiid java client error (Column name "VDBName" does not exist)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4945?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4945:
---------------------------------------
> TEIID40007 Keepalive failed for session RiZrctKFJYxl
That would be unrelated to this issue.
> I there is a guy that says it come from line 456 in JDBCConnectionManager
It makes me think that your client code is using a DatabaseMetaData result set and asking for a column by column name, not by the label. If your client logic is old see also TEIID-1651 - there is a flag that can alter how the metadata is reported.
> Teiid java client error (Column name "VDBName" does not exist)
> --------------------------------------------------------------
>
> Key: TEIID-4945
> URL: https://issues.jboss.org/browse/TEIID-4945
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 9.2.3
> Environment: Running teiid 9.2.3 on wildfly, failing using java client with 9.2.3 driver and sucess using protege with driver 9.2.3. both use ontop for mapping the data from db to the ontology.
> Reporter: Fábio Guilherme
> Assignee: Steven Hawkins
>
> This java client uses ontop to make the mapping from a db to a ontology. I had prior version where i was mapping my data from a postgres db to the ontology using ontop, in my recent version i changed the db to a teiid db(where i get the error).
> Using teiid 9.2.3 and wildfly with java client with 9.2.3 driver i get this error:
> {color:red}Error obtaining the Metadataorg.teiid.jdbc.TeiidSQLException: Column name "VDBName" does not exist.
> 09:31:15.411 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - Could not initialize the Quest query answering engine. Answering queries will not be available.
> 09:31:15.427 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - java.lang.NullPointerException
> it.unibz.krdb.obda.model.OBDAException: java.lang.NullPointerException{color}
> i used the same driver(9.2.3) on protege with ontop-pro and i dont get any error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4947) Error with Salesforce translator if criteria on outer join on a custom table is from the right side table
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-4947:
--------------------------------------
Summary: Error with Salesforce translator if criteria on outer join on a custom table is from the right side table
Key: TEIID-4947
URL: https://issues.jboss.org/browse/TEIID-4947
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 8.12.10.6_3, 8.7.11.6_2
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Running a left outer join between a parent and child custom table in salesforce results in an error:
select a.id, a.name, a.LastModifiedDate, b.Order_Recipe_Steps__c, b.name
from MPRS_Salesforce.Media_Prep_Order_Recipe_Steps__c a left outer join "MPRS_Salesforce"."Recipe_Step_Detail__c" b
on (a.id = b.Order_Recipe_Steps__c)
where b.LastModifiedDate >= parsetimestamp('2016-05-04 15:01:03.0', 'yyyy-MM-dd hh:mm:ss.s')
Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 MPRS_Salesforce: com.sforce.soap.partner.InvalidSObjectFault: INVALID_TYPE:
Recipe_Step_Detail__c.Catalog_Item__c FROM Recipe_Step_Detail__cs) FROM Media_Prep_Order_Recipe_Steps__c
^
ERROR at Row:1:Column:1137
Didn't understand relationship 'Recipe_Step_Detail__cs' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
SQLState: 50000
ErrorCode: 30504
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4945) Teiid java client error (Column name "VDBName" does not exist)
by Fábio Guilherme (JIRA)
[ https://issues.jboss.org/browse/TEIID-4945?page=com.atlassian.jira.plugin... ]
Fábio Guilherme commented on TEIID-4945:
----------------------------------------
In my code i don´t querie any table with a column VDBname, i thought i was something in teiid driver. On the server console i have this output: 08:59:15,933 INFO [org.teiid.SECURITY] (SessionMonitor) TEIID40007 Keepalive failed for session RiZrctKFJYxl
When i search for this problem i only found this link: https://groups.google.com/forum/#!msg/ontop4obda/Qe1PJXKOO_o/8fm7YPvV9J8J
I there is a guy that says it come from line 456 in JDBCConnectionManager
> Teiid java client error (Column name "VDBName" does not exist)
> --------------------------------------------------------------
>
> Key: TEIID-4945
> URL: https://issues.jboss.org/browse/TEIID-4945
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 9.2.3
> Environment: Running teiid 9.2.3 on wildfly, failing using java client with 9.2.3 driver and sucess using protege with driver 9.2.3. both use ontop for mapping the data from db to the ontology.
> Reporter: Fábio Guilherme
> Assignee: Steven Hawkins
>
> This java client uses ontop to make the mapping from a db to a ontology. I had prior version where i was mapping my data from a postgres db to the ontology using ontop, in my recent version i changed the db to a teiid db(where i get the error).
> Using teiid 9.2.3 and wildfly with java client with 9.2.3 driver i get this error:
> {color:red}Error obtaining the Metadataorg.teiid.jdbc.TeiidSQLException: Column name "VDBName" does not exist.
> 09:31:15.411 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - Could not initialize the Quest query answering engine. Answering queries will not be available.
> 09:31:15.427 [http-nio-8081-exec-8] ERROR i.u.k.o.o.owlapi3.QuestOWL - java.lang.NullPointerException
> it.unibz.krdb.obda.model.OBDAException: java.lang.NullPointerException{color}
> i used the same driver(9.2.3) on protege with ontop-pro and i dont get any error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months
[JBoss JIRA] (TEIID-4946) Support function SUBSTRING_INDEX in MySQL5ExecutionFactory
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4946?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4946:
----------------------------------
Component/s: JDBC Connector
Query Engine
Fix Version/s: 10.0
We'll evaluate if it makes sense to add this as an engine function as well.
> Support function SUBSTRING_INDEX in MySQL5ExecutionFactory
> ----------------------------------------------------------
>
> Key: TEIID-4946
> URL: https://issues.jboss.org/browse/TEIID-4946
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector, Query Engine
> Reporter: Pedro Inácio
> Assignee: Steven Hawkins
> Fix For: 10.0
>
>
> It is currently difficult to achieve the same functionality that is offered by *SUBSTRING_INDEX * function without direct support from _MySQL5ExecutionFactory_.
> So it would be nice to have this function implemented in the execution factory.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 9 months