2.3. Workarounds for Ongoing Issues
The following are workarounds for ongoing issues known to exist in JBoss Data Virtualization 6.
- BZ#996550 - Sybase15 subquery using HAVING clause failing
- In SYBASE 15, if a query is submitted with a subquery that contains the HAVING clause, it will fail. You can workaround this by using a custom translator to set supportsOnlyCorrelatedSubqueries to true, which will disable a non-correlated subquery pushdown such as this. However similar issues may still exist with other subqueries.
- BZ#1035035 - Unable to create function from the reconciler
- When building functions in Teiid Designer, users are not able to create recursive functions. The workaround is:
- Cancel out of the reconciler dialog
- Place your cursor in the SQL near the columns that need reconciling
- Select the "Expression Builder" action on the Transformation Editor toolbar
- Create/edit your complex/nested function definition
- BZ#1035480 - Changing connection profile jar then reset CP on Model does not update the jar
- When using Teiid Designer, users are finding that changes to the list of driver JARs for a connection profile are not being displayed when the user goes to "View Connection Info" for the model. To workaround this issue, after making changes to the list of driver JARs, perform one of the following options:
- Restart JBoss Developer Studio
- Create a new connection profile