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

Unable to preview data of file-based data source when the JNDI name already exist on the server runtime

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 10.0.2
    • Fix Version/s: 11.1
    • Component/s: Data Preview
    • Labels:
      None
    • Environment:

      MacOS
      Red Hat JBoss Developer Studio 10.3.0.GA with JBoss Developer Studio Integration Stack 10.0.2 installed

    • Steps to Reproduce:
      Hide
      • Create a file resource adapter in the JDV runtime engine
        /subsystem=resource-adapters/resource-adapter=fileQS:add(module=org.jboss.teiid.resource-adapter.file)
        /subsystem=resource-adapters/resource-adapter=fileQS/connection-definitions=fileDS:add(jndi-name=java:/contractdata-file, class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true)
        /subsystem=resource-adapters/resource-adapter=fileQS/connection-definitions=fileDS/config-properties=ParentDirectory:add(value=${jboss.home.dir}/teiidfiles/data/)
        /subsystem=resource-adapters/resource-adapter=fileQS/connection-definitions=fileDS/config-properties=AllowParentPaths:add(value=true)
        /subsystem=resource-adapters/resource-adapter=fileQS:activate
      • Start JBDS
        File -> Import
        Use File Source (Flat) >> Source and View Model
        This will create a source and view model based on the csv file you selected
      • Setup JNDI name on Source model schema
        Right click Source model schema
        Select Modeling -> Set JBoss Data Source JNDI Name to contractdata-file
        Select Modeling -> Set Translator Name to file
      • Preview Data
        ERROR 1 It says that the data source is missing, which is not, do you want to create them, Click Yes
        ERROR 2 A data source with JNDI name "java:/contractdata-file" failed to deploy
        See screenshots
      Show
      Create a file resource adapter in the JDV runtime engine /subsystem=resource-adapters/resource-adapter=fileQS:add(module=org.jboss.teiid.resource-adapter.file) /subsystem=resource-adapters/resource-adapter=fileQS/connection-definitions=fileDS:add(jndi-name=java:/contractdata-file, class-name=org.teiid.resource.adapter.file.FileManagedConnectionFactory, enabled=true, use-java-context=true) /subsystem=resource-adapters/resource-adapter=fileQS/connection-definitions=fileDS/config-properties=ParentDirectory:add(value=${jboss.home.dir}/teiidfiles/data/) /subsystem=resource-adapters/resource-adapter=fileQS/connection-definitions=fileDS/config-properties=AllowParentPaths:add(value=true) /subsystem=resource-adapters/resource-adapter=fileQS:activate Start JBDS File -> Import Use File Source (Flat) >> Source and View Model This will create a source and view model based on the csv file you selected Setup JNDI name on Source model schema Right click Source model schema Select Modeling -> Set JBoss Data Source JNDI Name to contractdata-file Select Modeling -> Set Translator Name to file Preview Data ERROR 1 It says that the data source is missing, which is not, do you want to create them, Click Yes ERROR 2 A data source with JNDI name "java:/contractdata-file" failed to deploy See screenshots

      Description

      If a data source is already created on the JDV server runtime unable to preview data on the models.
      Workaround is to add these models into a VDB, deploy/execute VDB but Preview data should work despite the fact that the datasource JNDI names already exists on the server side.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  cvanball Cojan van Ballegooijen
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: