[JBoss JIRA] (TEIID-2425) Add example AdminShell scripts
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-2425?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-2425:
------------------------------------
Adding the following groovy scripts examples:
- PrintAllVDBAndDatasources.groovy - will print all the vdb's and data sources deployed to the server
- PrintVDBInfo.groovy - will print the details for a specific vdb (i.e, Models, Data sources and data policies)
- DeployAndVerifyVDB.groovy - will deploy a vdb and then verify the status
- CacheStats.groovy - will clear the stats, run a query 'x' number of times, then check the cache status
- AssignDatasourceToModel.groovy - will assign/change a deployed datasource to source model
> Add example AdminShell scripts
> ------------------------------
>
> Key: TEIID-2425
> URL: https://issues.jboss.org/browse/TEIID-2425
> Project: Teiid
> Issue Type: Task
> Components: Build/Kits, Tools
> Affects Versions: 8.3
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Optional
>
> Add example adminshell scripts which demonstrate performing common task for deployment, configuration and monitoring.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIID-2448) Oracle driver translation error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2448?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2448.
-----------------------------------
Resolution: Done
Added a check of whether the procedure has resultset columns and generally cleaned up the sql (white space and comment placement) for stored procedures.
> Oracle driver translation error
> -------------------------------
>
> Key: TEIID-2448
> URL: https://issues.jboss.org/browse/TEIID-2448
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4
>
>
> Even procedures without resultsets have ?= added to them by the Oracle translator when it assumes the oracle driver is being used (the default). This will lead to a source error complaining that the function cannot be found.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIID-2448) Oracle driver translation error
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2448:
-------------------------------------
Summary: Oracle driver translation error
Key: TEIID-2448
URL: https://issues.jboss.org/browse/TEIID-2448
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.4
Even procedures without resultsets have ?= added to them by the Oracle translator when it assumes the oracle driver is being used (the default). This will lead to a source error complaining that the function cannot be found.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIID-1092) Request to have Global Variables
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1092?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1092:
----------------------------------
After consulting the original case and various dbms usages of variables I believe this can be satisfied with only session level (and likely non-transactional) variables. The simplest approach is to not further the usage of set/show syntax nor leverage \@variables, but to just introduce new built-in functions such as 'object teiid_session_set(string, object)' and 'object teiid_session_get(string)'. By backing the values in the Session object, they would be available via UDFs and at the translator level.
> Request to have Global Variables
> --------------------------------
>
> Key: TEIID-1092
> URL: https://issues.jboss.org/browse/TEIID-1092
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.4
>
>
> Customer is requesting a Global Variable. They want the variable to persist outside of one procedure to other spawned procedures and subsequent queries.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIID-2432) Dynamic VDB isLoading state doesnt change on fail
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2432?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2432:
---------------------------------------
I'm saying that if VDB.getStatus == LOADING and Model.getMetadataStatus == FAILED that necessarily means that the error is recoverable. Only when the VDB status moves to FAILED does it mean that there is something truly wrong. But that must seem confusing so 4 model metadata states will work just fine.
> Dynamic VDB isLoading state doesnt change on fail
> -------------------------------------------------
>
> Key: TEIID-2432
> URL: https://issues.jboss.org/browse/TEIID-2432
> Project: Teiid
> Issue Type: Feature Request
> Components: AdminApi
> Affects Versions: 8.2
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
>
> I am deploying a dynamic VDB and polling the isLoading state to determine when the VDB deployment is finished.
> In my case the VDB dataSource is not available. I can see in the server log that the deployment fails immediately, but the isLoading state remains true.
> Is this in error, or what status should we be checking?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months
[JBoss JIRA] (TEIID-2432) Dynamic VDB isLoading state doesnt change on fail
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2432?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2432:
-------------------------------------
I was thinking that FAILED == fix the issue, redeploy
Here we just have to fix the Data source issue, the process of deploy will pickup from the model where it has stopped. Would it work the same way, with single state?
> Dynamic VDB isLoading state doesnt change on fail
> -------------------------------------------------
>
> Key: TEIID-2432
> URL: https://issues.jboss.org/browse/TEIID-2432
> Project: Teiid
> Issue Type: Feature Request
> Components: AdminApi
> Affects Versions: 8.2
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
>
> I am deploying a dynamic VDB and polling the isLoading state to determine when the VDB deployment is finished.
> In my case the VDB dataSource is not available. I can see in the server log that the deployment fails immediately, but the isLoading state remains true.
> Is this in error, or what status should we be checking?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 9 months