• Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1

    Hello,   After creating view, while i am going to view it's data using preview. below exception is coming.   java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVI...
    Profile Photo
    last modified by rahulsharma1392
  • How to create view based on sql script with "aggregate functions" and "group by"

    Hi, This is sql query. Based on this, i am going to create View. My view should return same result as this sql query. i have to use "aggregate functions"and "group by" with joins in query.   Select cc.country_na...
    Profile Photo
    last modified by rahulkumarsharma
  • Server got stopped and unable to access VDBs

    HI,   I installed jboss data virtualization server on google VM and deployed VDBs. Everything working fine. Suddenly server got stopped at yestereve. When we restarted it, got started by unable to access VDBs w...
    Profile Photo
    last modified by rahulkumarsharma
  • Exception in Execution: java.sql.SQLException: Cannot perform operations on a closed connection.

    I created view successfully. when i went to see preview, it was throwing below exception.   It throws exception randomly but not always.   java.sql.SQLException: Cannot perform operations on a closed conne...
    Profile Photo
    last modified by rahulsharma1392
  • How to create VDB Web Service to return result based on given parameters.

    I have created VDB Web Service which is working fine but according to requirement i need to fetch records based on conditions.   How to expose web service to fetch record based on given parameters.
    Profile Photo
    last modified by rahulsharma1392
  • Issue while updating view from the source already been used.

    I have created view with selected columns from source in jboss data virtualization. Now i want to add some more column in that view from the tables which has been used already in that view.   When i try to add ...
    Profile Photo
    last modified by rahulsharma1392
  • Synchronize VDB to Updated JDBC Source Model

    Hi,   We have requirements to publish and review source code and DML changes in our production process.   I am wondering how, after DML changes are made, can we synchronize the JDBC Model Source, especia...
    Profile Photo
    last modified by werx.io
  • Can't import ParseException class in teiid-engine sub of 9.0 Alpha code?

    In the  org.teiid.api.exception.query , class QueryParserException, the import of org.teiid.query.parser.ParseException doesn't resolve for me.  I've tried maven reimports, synchs, re-pulled from master to m...
    Profile Photo
    last modified by don.krapohl
  • Does DV Extend SQL, let you use procedural statements anywhere?

    Hi Devs,   My apologies, but your system is saying that I am posting forbidden content and I have no idea what that is, so I am attaching as an image and we can update the replies with the actual text. I simpl...
    Profile Photo
    last modified by werx.io
  • Creating or Modify Table/View on VDB at runtime

    Hi all.   Is currently possible in JDV 6.2 to do the following:   1. Creating virtual table/view on VDB at runtime? (e.g. via Web or JDBC, using DDL?) 2. Modify existing virtual table/view structure (add/...
    Profile Photo
    last modified by yayan
  • Passing User ID in sys_context from Teiid to Oracle with JDBC connection

    I have to pass User ID from Teiid to Oracle for VPD purpose. I have code written to set logged in user ID in sys_context's os_user. How can I implement to execute that piece of code while Teiid makes connection to Ora...
    Profile Photo
    last modified by abhilash_tcs
  • Using jBoss Data Virtualization platform

    Hi,   I am fairly new to the entire jBoss middleware suite.   I am working on an application in which I am looking to connect to disparate data sources. To save time, I am looking to implement some data vi...
    Profile Photo
    last modified by prabodh1987