April 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3360) Provide an option to virtualize source exceptions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3360?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3360: --------------------------------------- This would require a hard dependency on hibernate to be done at the source level. We'd need to get the relevant SQLExceptionConversionDelegate and then construct a StandardSQLExceptionConverter for the translator and then return the converted exception for any sqlexception that was the cause for translator exception. The Teiid dialect on top then would then just need to pull out the underlying JDBCException. An alternative approach would be to allow the Teiid dialect to take a list of names of the JDBC source types being accessed such that it constructs a composite SQLExceptionConversionDelegate. The final approach would be to redevelop similar handling on our own outside of hibernate - and consider using it for the non-JDBC sources as well. > Provide an option to virtualize source exceptions > ------------------------------------------------- > > Key: TEIID-3360 > URL: https://issues.jboss.org/browse/TEIID-3360 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11, Open To Community > > > Currently we'll pass the source exception along with the Teiid exception. And from source sql exceptions we'll also rely the sql state/code. When connecting to databases of different types it would be best to return a common set of codes. > There is exception mapping logic in Hibernate that we could reuse, but this could apply to the non-jdbc sources such that a predictable code will seen by Teiid clients. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3428) Data is being cleaned out after each server restart

by Van Halbert (JIRA)

Van Halbert created TEIID-3428: ---------------------------------- Summary: Data is being cleaned out after each server restart Key: TEIID-3428 URL: https://issues.jboss.org/browse/TEIID-3428 Project: Teiid Issue Type: Bug Components: Tools Affects Versions: 6.2-8.7.2 Reporter: Van Halbert Assignee: Van Halbert Priority: Critical Fix For: 6.2-8.7.2, 8.11 In the teiid-extensions logging persistence file, the schema is currently getting recreated after each restart due to being set to: <property name="hibernate.hbm2ddl.auto" value="create" /> so it needs to change to be: <property name="hibernate.hbm2ddl.auto" value="update" /> However, "update" isn't the ideal situation for production systems when DBA's like to restrict access as who can be creating tables. So they want the ddl script to run. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3426) Salesforce importer does not set cardinalities

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3426?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3426: --------------------------------------- Was thinking about cloning to Designer, but it seems best just to work this on the server side for now. Unfortunately Salesforce does not appear to apply the table sizes in a simple way, so this may take secondary queries to determine row counts. > Salesforce importer does not set cardinalities > ---------------------------------------------- > > Key: TEIID-3426 > URL: https://issues.jboss.org/browse/TEIID-3426 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Reporter: Burak Serdar > Assignee: Steven Hawkins > > The salesforce importer does not set cardinalities for salesforce objects it imports. That is causing problems with joins involving more than two tables, and when there are no criteria on a large table. If the large table is joined later, it retrieves all the rows of that table and joins them with the result of the previous joins. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3426) Salesforce importer does not set cardinalities

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3426?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-3426: ------------------------------------- Assignee: Steven Hawkins (was: Mark Drilling) > Salesforce importer does not set cardinalities > ---------------------------------------------- > > Key: TEIID-3426 > URL: https://issues.jboss.org/browse/TEIID-3426 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Reporter: Burak Serdar > Assignee: Steven Hawkins > > The salesforce importer does not set cardinalities for salesforce objects it imports. That is causing problems with joins involving more than two tables, and when there are no criteria on a large table. If the large table is joined later, it retrieves all the rows of that table and joins them with the result of the previous joins. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3427) Salesforce importer does not set cardinalities

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3427: ------------------------------------- Summary: Salesforce importer does not set cardinalities Key: TEIID-3427 URL: https://issues.jboss.org/browse/TEIID-3427 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Reporter: Burak Serdar Assignee: Mark Drilling The salesforce importer does not set cardinalities for salesforce objects it imports. That is causing problems with joins involving more than two tables, and when there are no criteria on a large table. If the large table is joined later, it retrieves all the rows of that table and joins them with the result of the previous joins. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3427) Salesforce importer does not set cardinalities

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3427?page=com.atlassian.jira.plugin... ] Steven Hawkins deleted TEIID-3427: ---------------------------------- > Salesforce importer does not set cardinalities > ---------------------------------------------- > > Key: TEIID-3427 > URL: https://issues.jboss.org/browse/TEIID-3427 > Project: Teiid > Issue Type: Feature Request > Reporter: Burak Serdar > Assignee: Mark Drilling > > The salesforce importer does not set cardinalities for salesforce objects it imports. That is causing problems with joins involving more than two tables, and when there are no criteria on a large table. If the large table is joined later, it retrieves all the rows of that table and joins them with the result of the previous joins. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3426) Salesforce importer does not set cardinalities

by Burak Serdar (JIRA)

Burak Serdar created TEIID-3426: ----------------------------------- Summary: Salesforce importer does not set cardinalities Key: TEIID-3426 URL: https://issues.jboss.org/browse/TEIID-3426 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Reporter: Burak Serdar Assignee: Mark Drilling The salesforce importer does not set cardinalities for salesforce objects it imports. That is causing problems with joins involving more than two tables, and when there are no criteria on a large table. If the large table is joined later, it retrieves all the rows of that table and joins them with the result of the previous joins. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3425) Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3425?page=com.atlassian.jira.plugin... ] Juraj Duráni edited comment on TEIID-3425 at 4/14/15 6:25 AM: -------------------------------------------------------------- Same problem with Impala (pass-through). But in this case even static configuration does not work. Static configuration error: ERROR [org.apache.thrift.transport.TSaslTransport] (Worker1_QueryProcessorQueue1) SASL negotiation failure: javax.security.sasl.SaslException: Final handshake failed [Caused by org.ietf.jgss.GSSException, major code: 11, minor code: 0 major string: General failure, unspecified at GSSAPI level minor string: Input max size 0 less than computed required size 53] But IBM jdk is not supported - http://www.cloudera.com/content/cloudera/en/documentation/core/latest/top... was (Author: jdurani): Same problem with Impala (pass-through). But in this case even static configuration does not work. Static configuration error: ERROR [org.apache.thrift.transport.TSaslTransport] (Worker1_QueryProcessorQueue1) SASL negotiation failure: javax.security.sasl.SaslException: Final handshake failed [Caused by org.ietf.jgss.GSSException, major code: 11, minor code: 0 major string: General failure, unspecified at GSSAPI level minor string: Input max size 0 less than computed required size 53] > Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver > ----------------------------------------------------------------------------------------- > > Key: TEIID-3425 > URL: https://issues.jboss.org/browse/TEIID-3425 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: Fedora 20 > java: IBM JDK 1.7 > arch: x86_64 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Attachments: set-up-mssql-ibm.cli, sql2012krb-static-vdb.xml, sql2012krb-vdb.xml > > > I have configured a datasource for MSSQL database. The datasource uses PassthroughIdentityLoginModule. I have also created a VDB which requires kerberos authentication. I am trying to pass credentials used for authentication CLIENT <=> TEIID to datasource so they can be used for authentication TEIID <=> MSSQL. > Method getConnection(..) (record in server log) is called with correct credentials, but SQLServerDriver throws an exception: > initAuthInit failed privileged exception:-java.security.PrivilegedActionException: org.ietf.jgss.GSSException, major code: 13, minor code: 0 > major string: Invalid credentials > minor string: Cannot get credential from JAAS Subject for principal: default principal > Some ideas, but I am only guessing: > 1. I have seen same exception (on client side) if system property "javax.security.auth.useSubjectCredsOnly" is set to false on client side. As this property is set to true in the server config (<property name="javax.security.auth.useSubjectCredsOnly" value="true"/>), it is probably not passed to the driver (or is being ignored). > 2. SQLServerDriver sets two system properties by default (if no kerberos configuration file is specified) useDefaultCcache = true moduleBanner = false - see https://msdn.microsoft.com/en-us/library/gg558122%28v=sql.110%29.aspx - ibm kerberos login module will try to get TGT from ticket cache > I have tried static kerberos configuration for same DS and there was no problem with it. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3425) Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3425?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3425: ------------------------------------- Same problem with Impala (pass-through). But in this case even static configuration does not work. Static configuration error: ERROR [org.apache.thrift.transport.TSaslTransport] (Worker1_QueryProcessorQueue1) SASL negotiation failure: javax.security.sasl.SaslException: Final handshake failed [Caused by org.ietf.jgss.GSSException, major code: 11, minor code: 0 major string: General failure, unspecified at GSSAPI level minor string: Input max size 0 less than computed required size 53] > Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver > ----------------------------------------------------------------------------------------- > > Key: TEIID-3425 > URL: https://issues.jboss.org/browse/TEIID-3425 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: Fedora 20 > java: IBM JDK 1.7 > arch: x86_64 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Attachments: set-up-mssql-ibm.cli, sql2012krb-static-vdb.xml, sql2012krb-vdb.xml > > > I have configured a datasource for MSSQL database. The datasource uses PassthroughIdentityLoginModule. I have also created a VDB which requires kerberos authentication. I am trying to pass credentials used for authentication CLIENT <=> TEIID to datasource so they can be used for authentication TEIID <=> MSSQL. > Method getConnection(..) (record in server log) is called with correct credentials, but SQLServerDriver throws an exception: > initAuthInit failed privileged exception:-java.security.PrivilegedActionException: org.ietf.jgss.GSSException, major code: 13, minor code: 0 > major string: Invalid credentials > minor string: Cannot get credential from JAAS Subject for principal: default principal > Some ideas, but I am only guessing: > 1. I have seen same exception (on client side) if system property "javax.security.auth.useSubjectCredsOnly" is set to false on client side. As this property is set to true in the server config (<property name="javax.security.auth.useSubjectCredsOnly" value="true"/>), it is probably not passed to the driver (or is being ignored). > 2. SQLServerDriver sets two system properties by default (if no kerberos configuration file is specified) useDefaultCcache = true moduleBanner = false - see https://msdn.microsoft.com/en-us/library/gg558122%28v=sql.110%29.aspx - ibm kerberos login module will try to get TGT from ticket cache > I have tried static kerberos configuration for same DS and there was no problem with it. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3425) Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3425?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-3425: -------------------------------- Attachment: set-up-mssql-ibm.cli sql2012krb-static-vdb.xml sql2012krb-vdb.xml Configuration file, VDBs > Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver > ----------------------------------------------------------------------------------------- > > Key: TEIID-3425 > URL: https://issues.jboss.org/browse/TEIID-3425 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: Fedora 20 > java: IBM JDK 1.7 > arch: x86_64 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Attachments: set-up-mssql-ibm.cli, sql2012krb-static-vdb.xml, sql2012krb-vdb.xml > > > I have configured a datasource for MSSQL database. The datasource uses PassthroughIdentityLoginModule. I have also created a VDB which requires kerberos authentication. I am trying to pass credentials used for authentication CLIENT <=> TEIID to datasource so they can be used for authentication TEIID <=> MSSQL. > Method getConnection(..) (record in server log) is called with correct credentials, but SQLServerDriver throws an exception: > initAuthInit failed privileged exception:-java.security.PrivilegedActionException: org.ietf.jgss.GSSException, major code: 13, minor code: 0 > major string: Invalid credentials > minor string: Cannot get credential from JAAS Subject for principal: default principal > Some ideas, but I am only guessing: > 1. I have seen same exception (on client side) if system property "javax.security.auth.useSubjectCredsOnly" is set to false on client side. As this property is set to true in the server config (<property name="javax.security.auth.useSubjectCredsOnly" value="true"/>), it is probably not passed to the driver (or is being ignored). > 2. SQLServerDriver sets two system properties by default (if no kerberos configuration file is specified) useDefaultCcache = true moduleBanner = false - see https://msdn.microsoft.com/en-us/library/gg558122%28v=sql.110%29.aspx - ibm kerberos login module will try to get TGT from ticket cache > I have tried static kerberos configuration for same DS and there was no problem with it. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2015