[ https://issues.jboss.org/browse/TEIIDDES-870?page=com.atlassian.jira.plug... ]
Barry LaFond updated TEIIDDES-870:
----------------------------------
Fix Version/s: 7.6
> We should add a method/dialog to enable users to test JDBC connections used for Teiid instances
> -----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-870
> URL: https://issues.jboss.org/browse/TEIIDDES-870
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Dialogs
> Affects Versions: 7.3
> Reporter: Len DiMaggio
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> See SOA-2901 - the user cannot test the JDBC connection until after the Teiid instance is first created - but after the user saves the Teiid instance, we should provide a button/dialog to verify the JDBC information that he just entered.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-870?page=com.atlassian.jira.plug... ]
Barry LaFond reassigned TEIIDDES-870:
-------------------------------------
Assignee: Barry LaFond
> We should add a method/dialog to enable users to test JDBC connections used for Teiid instances
> -----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-870
> URL: https://issues.jboss.org/browse/TEIIDDES-870
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Dialogs
> Affects Versions: 7.3
> Reporter: Len DiMaggio
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> See SOA-2901 - the user cannot test the JDBC connection until after the Teiid instance is first created - but after the user saves the Teiid instance, we should provide a button/dialog to verify the JDBC information that he just entered.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1108:
----------------------------------------
generic "add properties" action/dialog is fine if you can find out what properties Teiid Server actually recognizes? And if those properties ARE defined, makes more sense to me to offer them specifically to the user.
If a user could add their OWN custom properties to a VDB and do something with them at runtime then I'd agree on the generic properties feature.
> Set Query Timeout at the VDB level
> ----------------------------------
>
> Key: TEIIDDES-1108
> URL: https://issues.jboss.org/browse/TEIIDDES-1108
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Environment: Windows
> Reporter: RAKESH BALGURI
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> Hi,
> We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object.
> Please see this discussion for more information http://community.jboss.org/message/600599#600599
> We want the setQueryTimeout to override the default values.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1108:
----------------------------------------
Why not add another tab under description, and leave as generic add properties dialog box for any property to be added instead of adding specific query-timeout property?
> Set Query Timeout at the VDB level
> ----------------------------------
>
> Key: TEIIDDES-1108
> URL: https://issues.jboss.org/browse/TEIIDDES-1108
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Environment: Windows
> Reporter: RAKESH BALGURI
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> Hi,
> We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object.
> Please see this discussion for more information http://community.jboss.org/message/600599#600599
> We want the setQueryTimeout to override the default values.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1108:
----------------------------------------
Recommend renaming the VDB Description tab in VDB Editor to say "VDB Properties". Make right half of panel "Description" and left half a Properties Panel initially containing just the Query Timeout (sec) property with DEFAULT == 0
> Set Query Timeout at the VDB level
> ----------------------------------
>
> Key: TEIIDDES-1108
> URL: https://issues.jboss.org/browse/TEIIDDES-1108
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Environment: Windows
> Reporter: RAKESH BALGURI
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> Hi,
> We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object.
> Please see this discussion for more information http://community.jboss.org/message/600599#600599
> We want the setQueryTimeout to override the default values.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-870?page=com.atlassian.jira.plug... ]
Ramesh Reddy commented on TEIIDDES-870:
---------------------------------------
The following code should do
String vdb = "<vdb name=\"Ping\" version=\"1\"> +
"<model name=\"Foo\"/>"+
"</vdb>";
admin.deployVDB("ping.vdb", new ByteArrayInputStream(vdb.toBytes()));
try{
Connection c = TeiidDriver.getInstance().connect("jdbc:teiid:ping@mm://<host>:<port>;<user-name>;<password>", null);
//pass
} catch(SQlexception e){
//fail
}
admin.undeploy("ping", 1);
> We should add a method/dialog to enable users to test JDBC connections used for Teiid instances
> -----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-870
> URL: https://issues.jboss.org/browse/TEIIDDES-870
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Dialogs
> Affects Versions: 7.3
> Reporter: Len DiMaggio
>
> See SOA-2901 - the user cannot test the JDBC connection until after the Teiid instance is first created - but after the user saves the Teiid instance, we should provide a button/dialog to verify the JDBC information that he just entered.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-870?page=com.atlassian.jira.plug... ]
Barry LaFond commented on TEIIDDES-870:
---------------------------------------
There was an idea thrown out there that Designer could have a simple/small VDB it could deploy/connect/undeploy during the "Test Connection" process... or was it a dynamicVDB (vdb.xml) we could use to test/ping the JDBC connection?
> We should add a method/dialog to enable users to test JDBC connections used for Teiid instances
> -----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-870
> URL: https://issues.jboss.org/browse/TEIIDDES-870
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Dialogs
> Affects Versions: 7.3
> Reporter: Len DiMaggio
>
> See SOA-2901 - the user cannot test the JDBC connection until after the Teiid instance is first created - but after the user saves the Teiid instance, we should provide a button/dialog to verify the JDBC information that he just entered.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1108:
----------------------------------------
1) VDB Editor as it corresponds to VDB not just preview
2) Not needed
3) Need to add "query-timeout" property in vdb.xml file at vdb level.
> Set Query Timeout at the VDB level
> ----------------------------------
>
> Key: TEIIDDES-1108
> URL: https://issues.jboss.org/browse/TEIIDDES-1108
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Environment: Windows
> Reporter: RAKESH BALGURI
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> Hi,
> We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object.
> Please see this discussion for more information http://community.jboss.org/message/600599#600599
> We want the setQueryTimeout to override the default values.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
Determine whether function models should be expanded in the Data Roles wizard so individual functions can be addressed
----------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-1125
URL: https://issues.jboss.org/browse/TEIIDDES-1125
Project: Teiid Designer
Issue Type: Task
Reporter: Paul Nittel
Fix For: 7.6
The Designer's New Data Roles wizard shows function models, but does not allow them to be expanded to show individual functions. It could be possible that some functions are less public than others, so should the user be allowed to restrict access to individual functions within a function model?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[ https://issues.jboss.org/browse/TEIIDDES-1108?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1108:
----------------------------------------
So is the solution here to:
1) add a Preference to the VDB Editor preferences or add it to the main "Preview/VDB Execution" preferences?
2) create a new Property in the Teiid Connection Profile "Query Timeout" which can be seeded with the preference but changed/saved by user
3) if timeout > 0, then use add the property to Teiid JDBC connection properties (along with U-name & PWD) when Designer/Eclipse calls teiidDriver.connect(vdbURL, properties)
> Set Query Timeout at the VDB level
> ----------------------------------
>
> Key: TEIIDDES-1108
> URL: https://issues.jboss.org/browse/TEIIDDES-1108
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Environment: Windows
> Reporter: RAKESH BALGURI
> Assignee: Barry LaFond
> Fix For: 7.6
>
>
> Hi,
> We want the configuration of the Query Timeout set on the server side instead of setting it for the Statement Object.
> Please see this discussion for more information http://community.jboss.org/message/600599#600599
> We want the setQueryTimeout to override the default values.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira