Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2951

Designer haven't set password to datasource which is created before preview.

    Details

    • Steps to Reproduce:
      1. Stop server
      2. Import from any database via JDBC
      3. Start server
      4. preview data

      Description

      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) if I had wanted to create DS. I clicked yes and ok but server shows error:

      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.
      

      I tried to create the data source (with the same name) manually but the error is still there 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:

      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>
      

      Datasource which is created in the import wizard:

      <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>
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                mkralik Matej Kralik
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: