• Forum Going Read-Only

    This forum will shortly be read-only.  Please create new topics on StackOverflow.  For now we'll just use the teiid tag for all topics.
    Profile Photo
    created by shawkins
  • SQL query failing

    Hi,   Wanted to point out a scenario where I faced an issue. The following query is fired on a VDB which made atop a JDBC (SQL-Server) based source model. It gives the error as shown below, whereas it works fine...
    Profile Photo
    last modified by pranavk
  • Teiid Developer forum is now read only

    Hello all,   In an effort to consolidate community activity we are combining the Teiid and Teiid Developer forums.  Since most of the actual development chatter happens through JIRA there isn't a specific ne...
    Profile Photo
    created by shawkins
  • Resource adapter based on Java Native Interface

    My custom resource adapter is using JNI to comunicate with the EIS. The JNI wraps a plain C-function to send and receive data (usually commands like open, find, read, etc.). E.g. a SQL-Select has to be translated to a...
    Profile Photo
    last modified by tomesc
  • Implement features

    Hi,   I'm currently planning to implement some framework whose architecture and features seem similar / complimentary of those of this project:   https://docs.google.com/document/d/1OqsVn6uo0cr6qruzWj9yRAS...
    Profile Photo
    last modified by ssamarug
  • exception while processing vdb request

    Hi,   When i try to process request to vdb i get exception:   Caused by: org.teiid.translator.TranslatorException: TEIID30481 Failed to find the Connection Factory with JNDI name orient/ConnectionFactory....
    Profile Photo
    last modified by arli1215
  • designer doesn't show table names

    Hi everyone,   I've created new execution factory for OrientDB, and now I'm trying to test it. But designer doesn't show any table names, although they exist. What I'm doing wrong? I use orientdb jdbc driver.
    Profile Photo
    last modified by arli1215
  • Usage of array type

    In my translator I use the 'array type' feature. Here an example:   Table table = metadataFactory.addTable("FILE_0004"); Column column = metadataFactory.addColumn("ISN", "string", table); Column column = metad...
    Profile Photo
    last modified by tomesc
  • literal formatting

    Hi guys,   In PostgreSQLExecutionFactory i see 'DATE' appendix in translateLiteralDate method. Could you please explain?   I tried sql request in postgres, I got following output: 2017-07-10.   I st...
    Profile Photo
    last modified by arli1215
  • why my vdb 'state is alwarys loading

    <?xml version="1.0" ?> <vdb name="ln622" version="1"> <description>VDB for: ln622, Version: 1</description> <connection-type>BY_VERSION</connection-type> <property name="{htt...
    Profile Photo
    last modified by uuliver
  • Getting exception querying using EmbeddedConnection

    Hi,   While connecting to my application (running on a jetty server), I am able to properly connect and and run queries over Teiid when I use the SocketConnection (using URL format: jdbc:teiid:Portfolio@mm://loc...
    Profile Photo
    last modified by pranavk
  • where the xml file

    where the xml save in service disk ,in which folder
    Profile Photo
    last modified by uuliver
  • confusion with joins

    My connector does not support joins. Thus my translator does overwrite the following support methods only: supportsCompareCriteriaEquals() supportsCompareCriteriaOrdered() supportsOrCriteria() supportsInCriteria()...
    Profile Photo
    last modified by tomesc
  • Empty WHERE clause for unsupported translator capability

    I am writting my own adapter and translater. It works very well so far. However I have a question to not supported translator capabilities: It seems that the query (QueryExpression) has no WHERE clause if the stateme...
    Profile Photo
    last modified by tomesc
  • error about the vdb.xml

    <?xml version="1.0" ?><vdb name="ln622" version="1"> <description>VDB for: ln622, Version: 1</description> <connection-type>BY_VERSION</connection-type> <model name="bln" type...
    Profile Photo
    last modified by uuliver
  • where the ddl-file's location

    when i deploy the vdb ,throw exception"No vdb resource exists with name  /1.ddl",I want know ,where the ddl file i will be place in
    Profile Photo
    last modified by uuliver
  • how to set the vdb.xml

    i want deploy a vdb by some tables or procedures of database ,how can confige the xml file,not by DDL,caurse the count of tables  greater than 100
    Profile Photo
    last modified by uuliver
  • Proxy options don't work with Salesforce connector

    Hi, Just wanted to point out that using proxy options in the Salesforce connector does not work (most surely an underlying library issue though). Following is the way I am setting the options in question.   ...
    Profile Photo
    last modified by pranavk
  • Exposing WKBGeometry via Teiid

    Hello! Does anyone know how to expose a WKBGeometry object from PostGRES/PostGIS through Teiid VDB inorder to expose spatial data? Cheers!
    Profile Photo
    last modified by jollyfella
  • Materialized Views on Teiid 9.2.3

    Before Teiid 9.2, it was not necessary to have any PRIMARY KEY in View nor on their Materialized Views counterpart.   When trying to run the following VDB in Teiid Server 9.2 the folowing problem arises:   ...
    Profile Photo
    last modified by pringi