[JBoss JIRA] (TEIID-2929) Provide ability define "execution properties" as VDB properties
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2929?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2929.
-----------------------------------
Resolution: Done
updated the odbc and vdb documentation to mention the usage of these properties.
> Provide ability define "execution properties" as VDB properties
> ---------------------------------------------------------------
>
> Key: TEIID-2929
> URL: https://issues.jboss.org/browse/TEIID-2929
> Project: Teiid
> Issue Type: Enhancement
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Fix For: 8.8
>
>
> Currently if user needs to set any execution properties on their connection, with JDBC they can define on the URL or use "SET " statement to issue a query. In ODBC can also use "SET " method.
> However, when working with packaged applications and ODBC or in some situations it may be better to configure these properties VDB wide so that all the connections are using same execution properties.
> This JIRA proposes ability to add execution properties as vdb properties in vdb.xml file.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
11 years, 10 months
[JBoss JIRA] (TEIID-2953) DB2: doesn't work with composite key
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2953?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2953:
---------------------------------------
What is the specific version of DB2? We have the translator marked as supporting the array type, which allows for this comparison.
> DB2: doesn't work with composite key
> -------------------------------------
>
> Key: TEIID-2953
> URL: https://issues.jboss.org/browse/TEIID-2953
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: DB2 with Teiid 8.7
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
>
> If I run a sql with composite key in DB2, Teiid translates it to something incorrect DB2 sql.
> However, it works for postgres, mysql, and oracle.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
11 years, 11 months
[JBoss JIRA] (TEIID-2953) DB2: doesn't work with composite key
by Ivan Chan (JIRA)
Ivan Chan created TEIID-2953:
--------------------------------
Summary: DB2: doesn't work with composite key
Key: TEIID-2953
URL: https://issues.jboss.org/browse/TEIID-2953
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7
Environment: DB2 with Teiid 8.7
Reporter: Ivan Chan
Assignee: Steven Hawkins
If I run a sql with composite key in DB2, Teiid translates it to something incorrect DB2 sql.
However, it works for postgres, mysql, and oracle.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
11 years, 11 months
[JBoss JIRA] (TEIID-2944) getIndexInfo should return statistical information
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2944?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2944.
-----------------------------------
Fix Version/s: 8.8
Resolution: Done
Updated getIndexInfo to return table cardinalities when approximate info is requested. But we are still setting the non-stat index cardinality to 0 regardless.
> getIndexInfo should return statistical information
> --------------------------------------------------
>
> Key: TEIID-2944
> URL: https://issues.jboss.org/browse/TEIID-2944
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Driver
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.8
>
>
> DatabaseMetaData.getIndexInfo can return statistical indexes with cardinality information and/or cardinality can be returned on the other index info for the table.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
11 years, 11 months
[JBoss JIRA] (TEIID-2948) Implement Access Controls on management operations in Teiid
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2948?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-2948.
---------------------------------
Resolution: Done
Based on instructions,
* Translator and Transport have been defined as application based resources
* All the sensitive information in the configuration is marked as such. So a person with out in sufficient privileges will not be able to see certain properties
* Marked all the operations on Teiid that do modifications to runtime state as such, which will be considered as write sensitive operations and authorized as such
Note that RBAC features are by default turned OFF in EAP. However in the case when the user turns these on, Designer and other tooling such as web-console need to use users with sufficient privileges to carry out tasks. Otherwise they will end up with errors.
Only 8.7.x branch currently has RBAC as it is supported only in > EAP 6.2, latest master does not contain RBAC feature.
> Implement Access Controls on management operations in Teiid
> -----------------------------------------------------------
>
> Key: TEIID-2948
> URL: https://issues.jboss.org/browse/TEIID-2948
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 8.7.1
>
>
> EAP 6.2 and above provides facilities to implement access controls on the management operations. Teiid should implement them on the management operations so that they can be controlled by access level of the user.
> Unfortunately this is not in EAP 6.1.Alpha, so it becomes hard to pull the changes upstream into 8.8
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
11 years, 11 months