[JBoss JIRA] (TEIIDDES-2950) Existing data source is not overridden
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2950?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2950:
-----------------------------------
Summary: Existing data source is not overridden (was: Exist data source is not overridden)
> Existing data source is not overridden
> --------------------------------------
>
> Key: TEIIDDES-2950
> URL: https://issues.jboss.org/browse/TEIIDDES-2950
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: screenshot.png
>
>
> When a user creates datasource with a name which already exists, a user can click OK but this datasource won't be overridden. In the wizard is warning (screenshot) that "A Data Source with the name SQL_Server_2008_Books_DS already exists." but a user can click OK. A user can think that datasource was overridden.
> This is confusing so I think that designer should show some warning that datasource will not be overridden or the OK button should be disabled.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years
[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2951:
--------------------------------------
Assignee: Barry LaFond
> Designer haven't set password to datasource which is created before preview.
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2951
> URL: https://issues.jboss.org/browse/TEIIDDES-2951
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 10.0.2
>
> Attachments: screenshot1.png, screenshot2.png
>
>
> I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly.
> {code}
> I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource.
> I deleted datasource.
> When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine.
> So I notice that datasource haven't set a password when DS is created before the preview.
> I looked to standalone.xml
> Datasource which is created before preview:
> {code:java}
> datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> </security>
> </datasource>
> {code}
> Datasource which is created in the import wizard:
> {code:java}
> <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> <password>**</password>
> </security>
> </datasource>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years
[JBoss JIRA] (TEIIDDES-2950) Exist data source is not overridden
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2950?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2950:
--------------------------------------
Assignee: Barry LaFond
> Exist data source is not overridden
> -----------------------------------
>
> Key: TEIIDDES-2950
> URL: https://issues.jboss.org/browse/TEIIDDES-2950
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: screenshot.png
>
>
> When a user creates datasource with a name which already exists, a user can click OK but this datasource won't be overridden. In the wizard is warning (screenshot) that "A Data Source with the name SQL_Server_2008_Books_DS already exists." but a user can click OK. A user can think that datasource was overridden.
> This is confusing so I think that designer should show some warning that datasource will not be overridden or the OK button should be disabled.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years
[JBoss JIRA] (TEIIDDES-2950) Exist data source is not overridden
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2950?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2950:
-----------------------------------
Fix Version/s: 10.0.2
> Exist data source is not overridden
> -----------------------------------
>
> Key: TEIIDDES-2950
> URL: https://issues.jboss.org/browse/TEIIDDES-2950
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: screenshot.png
>
>
> When a user creates datasource with a name which already exists, a user can click OK but this datasource won't be overridden. In the wizard is warning (screenshot) that "A Data Source with the name SQL_Server_2008_Books_DS already exists." but a user can click OK. A user can think that datasource was overridden.
> This is confusing so I think that designer should show some warning that datasource will not be overridden or the OK button should be disabled.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years
[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2951:
-----------------------------------
Fix Version/s: 10.0.2
> Designer haven't set password to datasource which is created before preview.
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2951
> URL: https://issues.jboss.org/browse/TEIIDDES-2951
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Priority: Critical
> Fix For: 10.0.2
>
> Attachments: screenshot1.png, screenshot2.png
>
>
> I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly.
> {code}
> I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource.
> I deleted datasource.
> When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine.
> So I notice that datasource haven't set a password when DS is created before the preview.
> I looked to standalone.xml
> Datasource which is created before preview:
> {code:java}
> datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> </security>
> </datasource>
> {code}
> Datasource which is created in the import wizard:
> {code:java}
> <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> <password>**</password>
> </security>
> </datasource>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years
[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ]
Matus Makovy reassigned TEIIDDES-2951:
--------------------------------------
Assignee: (was: Matus Makovy)
> Designer haven't set password to datasource which is created before preview.
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2951
> URL: https://issues.jboss.org/browse/TEIIDDES-2951
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: screenshot1.png, screenshot2.png
>
>
> I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly.
> {code}
> I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource.
> I deleted datasource.
> When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine.
> So I notice that datasource haven't set a password when DS is created before the preview.
> I looked to standalone.xml
> Datasource which is created before preview:
> {code:java}
> datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> </security>
> </datasource>
> {code}
> Datasource which is created in the import wizard:
> {code:java}
> <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> <password>**</password>
> </security>
> </datasource>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years