Log in to follow, share, and participate in this community.
Thread Issue faced while using SimpleDb and Cassandra connector
Issue faced while using SimpleDb and Cassandra connectorHi, 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 ...
Thread call stored procedure in oracleDB from Teiid
call stored procedure in oracleDB from TeiidHi, 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 ...
connect vdb by jndi name from hibernateHi, 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 4000Hi, 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 testingHi, 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 ...
Thread response code for "primary key of parent table not found"
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 objectHi, 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 ServerDear 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 KeyHi, 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 tableHi, 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...
Thread Queries are not killed even if the client sends a cancel request
Queries are not killed even if the client sends a cancel requestHi 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 tableHi, 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...
Thread insert in to oracle db by sequence generated number
insert in to oracle db by sequence generated numberHi, 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...
'concat' when no of rows is not fixedHi, 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 sourcesHi, 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...
ldap postHi, 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": { ...
Thread Embedded Teiid security based on standard XML config files
Embedded Teiid security based on standard XML config filesHi, We have been using a custom solution inside Teiid for the authentication/ authorization processes. Can we use the same config files we use in the standard version instead? We are thinking the way an AD ca...