• javax.xml.ws.soap.SOAPFaultException: java:<<JNDINAME>>, when we are trying to get the end point URL on Browser.

         We are able to create the war file by using Generating JBossWS-CXF War by using <<Filename>>.VDB file, and it's deployed successfully in JBoss EAP server 6.x final version. But ...
    Profile Photo
    last modified by hanumath
  • Is it possible to perform delta load to external materialisation table to track the changes at the source using Teiid?

    Is it possible to perform delta load to external materialisation table to track the changes at the source using teiid, where when a record is inserted into the database, or new file gets created and JMS event is gener...
    Profile Photo
    last modified by vivedha
  • Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in comparison

    This is the scenario in which we are trying to consume soap web service by using of existing WSDL and exposing it again it as web service. So when we are trying to model/ create web service out of <<Filename>...
    Profile Photo
    last modified by hanumath
  • update statement with WHERE clause is splitted

    Hi,   I have created a view model vdb using Teiid Designer and deployed it to JBOSS server. I overwrote the default Update transformation in the view model.   I am testing the Update using Squirrel.  ...
    Profile Photo
    last modified by katherine
  • Trying to generate WSVDB (web service VDB) as JbosWS-cxf-war, RunTimeException is comming File Simple DataTypes-instance does not exist.

            When we are trying to generate WSVDB (web service VDB) as JbosWS-cxf-war, we are getting the below error, rest of the VDB Modeling operations ‘Deploy’ and ‘Exe...
    Profile Photo
    last modified by hanumath
  • How to connect to a running server?

    I have the latest Designer 8.2 Alpha2 on Kepler running, I configured the running server desinged VDB etc. Then I closed the Eclipse, and re-started it. I went to servers view and started the server, now when I try to...
    Profile Photo
    last modified by rareddy
  • Procedure in source model

    Hi,   We have registered a procedure in source model VDB, and we can see that procedure in source model now.   In SELECT transformation in View Model, we want to call this procedure, let teiid push down th...
    Profile Photo
    last modified by jane_lj
  • Is this the right way to test Result set Cache?

    Hi I am Using Teiid 7.7.5 + Teiid Designer 7.8 + Eclipse Indigo , I tried creating a VDB with a Result set Cache 1. I changed the transformation in the view /*+ cache(ttl:300000) */SELECT * FROM SourceSample.Air_...
    Profile Photo
    last modified by vivedha
  • facing issue in exposing the VDB as web services

    Am using Teiid 7.7.5 + Teiid Designer : 8.1.0.   Hav created a VDB connecting to MySQL DB. Able to deploy VDB and the CXF WAR successfully. Able to access the WSDL file via endpoint. But getting the below error...
    Profile Photo
    last modified by forgetarun
  • No sources were given for the model abc

    Hi ,   Using Teiid 7.7.5 + Teiid Designer 7.8 + Eclipse Indigo , I tried creating a VDB to make a updateable WAR.   VDB and WAR was deployed successfully. But the source model is empty when viewed on Admin...
    Profile Photo
    last modified by forgetarun
  • LIMIT in virtual procedure

    I'm trying to apply a limit clause to a virtual procediure with no luck   CREATE VIRTUAL PROCEDURE BEGIN             SELECT XMLELEMENT(NAME alberate, XMLA...
    Profile Photo
    last modified by gioppoluca
  • Error While Deploying vdb

    When i deploy vdb i am getting error as     eclipse.buildId=unknown java.version=1.7.0_25 java.vendor=Oracle Corporation BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US Framework arguments:...
    Profile Photo
    last modified by ramarajudvs
  • WebService generation problems

    CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_cardholderNumber; VARIABLES.IN_cardholderNumber = xpathValue(CardholderDB.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:car...
    Profile Photo
    last modified by ramarajudvs
  • Teiid hibernate project

    Hi,   previously i used hibernate for persistence.now i need to use teiid for persistence.How Can i do it by using the hibernate code?How to configure the db properties in hibernate.cfg file? what about hbm file...
    Profile Photo
    last modified by ramarajudvs
  • Could you give me a hand

    Could you tell me how can I limit the data in VDB? I have built up a *.xmi file and needs to build up three VDBs according to this xmi file. The entries in each VDB is different from others. How can I implement this r...
    Profile Photo
    last modified by robin622091
  • Importing database Packages/Functions/Triggers in Teiid

    I have imported all the tables from my datasource to Teiid and have defined row based security on some of my tables using some virtual procedures.   But if my actual database package/procedure try to access thes...
    Profile Photo
    last modified by neetacomp
  • Teiid Designer 8.2 alpha works with Teiid 8.3?

    Just saw Teiid Designer 8.2 alpha is realsed.   Want to confirm if this version works with Teiid 8.3?   Thanks.
    Profile Photo
    last modified by jane_lj
  • Virtual Procedure to insert data into table is not working

    I have created a virtual procedure to insert data into a table   CREATE VIRTUAL PROCEDURE BEGIN     INSERT INTO SQLServerSourceModel.tblItems (ItemId, Part, SegCode) VALUES ('Item1', 'Part1', 'S...
    Profile Photo
    last modified by neetacomp
  • How to handle nulls

    Hi,   I am firing a select * query in SQL scrapbook, it works fine.But the follwing query does not work:   Select * from <table> where <column> is not null   This query returns data but t...
    Profile Photo
    last modified by mbisne
  • Virtual Procedure to insert data into table is not working

    I am not able to create insert/update procedure/trigger   I have followed following steps in Teiid Designer   - Created a source model (import) - Created "relational view model", then choose to transform...
    Profile Photo
    created by neetacomp