question regaring to "The length of the Procedure parameter" Hi, I wrote a procedure in my view model. The procedure takes a "blob" data type as input parameter. I was testing my code and noticed that when the input blob contains 20000 of double precision value... 
problem with overwriting the default delete procedure Hi, I would like to overwrite the default delete procedure. Here is my procedure: FOR EACH ROW BEGIN ATOMIC DELETE FROM NativeModel.FIELD WHERE ("NEW".field_name = NativeModel.FIELD.N... FOR EACH ROW procedure for UPDATE Hi, Our view model created in Teiid Designer have to support updates, and we cant use the default UPDATE and INSERT. I have figured out how to write FOR EACH ROW procedure for INSERT. But for UPDATE, if ... 
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 ... 
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... 
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>... 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. ... 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... 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... 
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... 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_... 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... 
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... 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... 
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:... 
WebService generation problems CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_cardholderNumber; VARIABLES.IN_cardholderNumber = xpathValue(CardholderDB.CardholderDBService.getCardholder.getCardholder, '/*:getCardholder/*:arg0/*:car... 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... 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... 
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... 
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.
Log in to follow, share, and participate in this community.