[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: 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
> Assignee: Matus Makovy
> 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, 11 months
[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2858:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.3 (was: )
> DDL Importer does drops quotes from quoted column names
> -------------------------------------------------------
>
> Key: TEIIDDES-2858
> URL: https://issues.jboss.org/browse/TEIIDDES-2858
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Dynamic VDBs
> Affects Versions: 10.0.1
> Environment: Fedora 23
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: remoteXML.zip, screenshot1.png, screenshot2.png
>
>
> When I wanted preview date from the table which contains column with specific name, server shows me this error:
> TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9.
> Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
> I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks.
> "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE')
> When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2)
> A similar situation is when I generated dynamic VDB.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2858.
----------------------------------
> DDL Importer does drops quotes from quoted column names
> -------------------------------------------------------
>
> Key: TEIIDDES-2858
> URL: https://issues.jboss.org/browse/TEIIDDES-2858
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Dynamic VDBs
> Affects Versions: 10.0.1
> Environment: Fedora 23
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: remoteXML.zip, screenshot1.png, screenshot2.png
>
>
> When I wanted preview date from the table which contains column with specific name, server shows me this error:
> TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9.
> Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
> I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks.
> "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE')
> When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2)
> A similar situation is when I generated dynamic VDB.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months