Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4792

Unable to use WHERE clause against a JDG data source - ISPN000402: The type com.redhat.demo.sko.pojo.Call has no property named .....

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • None
    • None
    • JDG Connector
    • None
    • Hide

      JDG 6.6.1 env
      cli.sh
      /subsystem=infinispan/cache-container=local/local-cache=callCache:add(start=EAGER)
      /subsystem=infinispan/cache-container=local/local-cache=contractCache:add(start=EAGER)

      JDV 6.3.4 env
      batch
      /subsystem=teiid/translator=infinispan-cache-dsl:add(module=org.jboss.teiid.translator.infinispan.dsl)
      /subsystem=resource-adapters/resource-adapter=callRA:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl)
      /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS:add(jndi-name="java:/callDS", class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory", pool-name="callDS",enabled="true", use-java-context="true")
      /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS/config-properties=CacheTypeMap:add(value="callCache:com.redhat.demo.sko.pojo.Call;Phone")
      /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS/config-properties=Module:add(value="com.redhat.demo.sko.pojo")
      /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS/config-properties=RemoteServerList:add(value="127.0.0.1:11322")
      /subsystem=resource-adapters/resource-adapter=callRA:activate
      /subsystem=resource-adapters/resource-adapter=contractRA:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl)
      /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS:add(jndi-name="java:/contractDS", class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory", pool-name="contractDS",enabled="true", use-java-context="true")
      /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS/config-properties=CacheTypeMap:add(value="contractCache:com.redhat.demo.sko.pojo.Contract;Phone")
      /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS/config-properties=Module:add(value="com.redhat.demo.sko.pojo")
      /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS/config-properties=RemoteServerList:add(value="127.0.0.1:11322")
      /subsystem=resource-adapters/resource-adapter=contractRA:activate
      run-batch
      :reload

      unzip Contract_JDG_Module.zip into $JDV_HOME
      unzip Call_JDG_Module.zip into $JDV_HOME

      copy module.xml $JDV_HOME/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/dsl/main

      copy module pojo.xml $JDV_HOME/modules/com/redhat/demo/sko/pojo/main/module.xml

      Start JDG with port off set 100
      Start JDV
      deploy the VDB in $JDV_HOME/standalone/deployments
      Add some entries in the cache using INSERT statements
      SELECT * FROM Call_VBL."Call" all entries from JDG returned

      SELECT * FROM Call_VBL."Call" where Intlcalls > 0 -> ERROR

      Show
      JDG 6.6.1 env cli.sh /subsystem=infinispan/cache-container=local/local-cache=callCache:add(start=EAGER) /subsystem=infinispan/cache-container=local/local-cache=contractCache:add(start=EAGER) JDV 6.3.4 env batch /subsystem=teiid/translator=infinispan-cache-dsl:add(module=org.jboss.teiid.translator.infinispan.dsl) /subsystem=resource-adapters/resource-adapter=callRA:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl) /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS:add(jndi-name="java:/callDS", class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory", pool-name="callDS",enabled="true", use-java-context="true") /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS/config-properties=CacheTypeMap:add(value="callCache:com.redhat.demo.sko.pojo.Call;Phone") /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS/config-properties=Module:add(value="com.redhat.demo.sko.pojo") /subsystem=resource-adapters/resource-adapter=callRA/connection-definitions=callDS/config-properties=RemoteServerList:add(value="127.0.0.1:11322") /subsystem=resource-adapters/resource-adapter=callRA:activate /subsystem=resource-adapters/resource-adapter=contractRA:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl) /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS:add(jndi-name="java:/contractDS", class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory", pool-name="contractDS",enabled="true", use-java-context="true") /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS/config-properties=CacheTypeMap:add(value="contractCache:com.redhat.demo.sko.pojo.Contract;Phone") /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS/config-properties=Module:add(value="com.redhat.demo.sko.pojo") /subsystem=resource-adapters/resource-adapter=contractRA/connection-definitions=contractDS/config-properties=RemoteServerList:add(value="127.0.0.1:11322") /subsystem=resource-adapters/resource-adapter=contractRA:activate run-batch :reload unzip Contract_JDG_Module.zip into $JDV_HOME unzip Call_JDG_Module.zip into $JDV_HOME copy module.xml $JDV_HOME/modules/system/layers/dv/org/jboss/teiid/resource-adapter/infinispan/dsl/main copy module pojo.xml $JDV_HOME/modules/com/redhat/demo/sko/pojo/main/module.xml Start JDG with port off set 100 Start JDV deploy the VDB in $JDV_HOME/standalone/deployments Add some entries in the cache using INSERT statements SELECT * FROM Call_VBL."Call" all entries from JDG returned SELECT * FROM Call_VBL."Call" where Intlcalls > 0 -> ERROR

    Description

      SELECT * FROM Calls."Call" works as expected and returns all rows
      Adding a where clause
      SELECT * FROM Calls."Call" WHERE Calls."Call".Intlcalls > 0
      generate the following error:
      org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: org.hibernate.hql.ParsingException: ISPN000402: The type com.redhat.demo.sko.pojo.Call has no property named 'Intlmins'.

      Elapsed Time: 0 hr, 0 min, 0 sec, 191 ms.

      If I join two VBL together and run the join query it returns the same error.

      Attachments

        1. Screen Shot 2017-03-01 at 16.32.19.png
          Screen Shot 2017-03-01 at 16.32.19.png
          1.33 MB
        2. module pojo.xml
          0.7 kB
        3. module.xml
          2 kB
        4. Contract_JDG_Module.zip
          4 kB
        5. ChurnPrediction-vdb.xml
          5 kB
        6. Call_JDG_Module.zip
          3 kB

        Activity

          People

            van.halbert Van Halbert (Inactive)
            cvanball_jira Cojan van Ballegooijen (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: