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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 11.1
    • 10.0.2
    • Data Preview
    • None
    • 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

      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.

        1. Screen Shot 2017-03-01 at 10.16.26.png
          Screen Shot 2017-03-01 at 10.16.26.png
          953 kB
        2. Screen Shot 2017-03-01 at 10.16.46.png
          Screen Shot 2017-03-01 at 10.16.46.png
          952 kB

              blafond Barry LaFond
              cvanball_jira Cojan van Ballegooijen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: