TEIID30517 Client thread already involved in a transaction. Hi, I'm using teiid 8.10.0 and hibernate. I have 2 entities related with a @ManyToMany annotation. When i tried to get one of this entities i get the following error: 18:01:00,717 WARN [org.hibernate.engine.jd... 
Issue faced while using SimpleDb and Cassandra connector Hi, I noticed that while writing to a VDB using the Cassandra connector (Cassandra based source model contained within a VDB), writes were going very slow. On a single node Cassandra setup inserting a set 50k ... 
call stored procedure in oracleDB from Teiid Hi, we have couple of stored procedures in oracle databases, that we want to expose from DV as vdbs. How can we import these stored procedures? Please provide documentation links that would help me achieve ... 
Can we deploy virtual data bases to the Teiid runtime without using Eclipse workspace ? I want to use VDB without using eclipse and integrate with my own web application. is it possible ? 
connect vdb by jndi name from hibernate Hi, i am able to connect to a VDB from hibernate by giving the vdb connection details in hibernate.config file. I am trying to connect by JNDI name, but i get "org.hibernate.engine.jndi.JndiException: Error pa... return a string of length more than 4000 Hi, I need to return a variable of length more than 4000. i had the datatype as string but it is not returning the complete string. what should be the datatype of the column if i need to return a readable str... Teiid regression testing Hi, I recently started working with Teiid to create and deploy VDBs and I am currently exploring ways of how to automate the testing of the models. In particular, I am interested in testing automation ... 
response code for "primary key of parent table not found" Hi, When the primary key of the parent table is not found in the below kind of odata URL: odata/VDB/ParentTable/123/ChildTable then the response code is expected to be 404/500 or any error code... datatype for json array object Hi, We have a column which is returning a json array like given below: [ {"name":"john"}, {"age":"20"} ] When the datatype of the field is string, the odata url is returning the value as given belo... LOCATE function translation for SQL Server Dear all Is there any specific reason Teiid function LOCATE is not translated to CHARINDEX SQL Server function ? CHARINDEX documentation Thanks in advance for the information Jean-Pierre 
'M' or 'L' in odata URL for Primary Key Hi, We observe that the odata URL returns 'M' after the primary key value which is a BigDecimal in the response URLs, and 'L' for BigInteger. For eg : "__metadata": { ... 'selectable=false' on virtual table Hi, I am trying to make a field in a virtual table as 'selectable=false', so that I do not get that field in odata get response. But i am getting error : TEIID30492 The following data elements are not suppor... Queries are not killed even if the client sends a cancel request Hi all, I am experiencing a problem when I try to cancel a query that is processed locally in Teiid. For example, if I run a query like this: WITH x as ( SELECT * FROM SYS.COLUMNS LIMIT 70 ), y as ( &#... 
insert mutiple rows in to a view table Hi, I am able to do insert in to a single view table made out of multiple source tables by update procedures. for the below request: { "table1Field":"table1Value", "table2Field":"table2Value" } My... insert in to oracle db by sequence generated number Hi, We need to insert in to a table in Oracle Database whose primary key is a sequence generated number. We created a sequence in Source with columns nextval and currval having 'Name in source' as '<Sequen... Invalid dates in MySQL source tables are shown as NULL values in Teiid Hi all, I am experiencing a problem on loading source tables from MySQL containing columns defined as DATE as datatype. In particular, I have this table: create table my.test (col1 DATE NOT NULL); w... 'concat' when no of rows is not fixed Hi, I am creating a virtual table by doing an inner join on multiple oracle source tables. One of the tables has multiple rows based on one id. And the number of rows is not fixed. I need to con-cat these mu... deployment of VDB from Ldap sources Hi, I have created a vdb which is created from LDAP source following the steps in this document - http://docs.jboss.org/teiid/designer/8.6/user-guide/en-US/html_single/#ldap-import-section I am able to access... How to create table using with statement in the select statement of ddl Hi, We are trying to create dynamic vdb using ddl files, in which we are trying to create table using with statement in ddl file but it is not working,... 
ldap post Hi, I created a virtual table from Ldap source table, and I am able to do a odata GET call. When I try to make POST on the same table. It is giving the below errors : { "error": { ...
Log in to follow, share, and participate in this community.