[JBoss JIRA] (TEIID-3740) ldap post
by Prashanthi Kairuppala (JIRA)
[ https://issues.jboss.org/browse/TEIID-3740?page=com.atlassian.jira.plugin... ]
Prashanthi Kairuppala commented on TEIID-3740:
----------------------------------------------
Hi steven,
I am able to post now.
I added two columns : 'dn' and 'objectClass' in my tables and updated the 'name in source' to dn and objectClass respectively.
Thanks for your support,
Prashanthi.
> ldap post
> ---------
>
> Key: TEIID-3740
> URL: https://issues.jboss.org/browse/TEIID-3740
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Prashanthi Kairuppala
> Assignee: Steven Hawkins
> Attachments: testDelete.vdb
>
>
> 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": {
> "code": "ServerErrorException",
> "message": {
> "lang": "en-US",
> "value": "TEIID30492 TEIID30061 Insert is not allowed on the view LdapView.\"user\". A procedure may be needed to handle the Insert since: The query defining an updatable view has no valid target for INSERTs."
> }
> }
> }
>
> My virtual table is a simple (select * from table) statement. and "Suports update" is checked for source and view. VDB file attached for reference
> how do i make a successful post?
> Thanks in advance,
> Prashanthi
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-3740) ldap post
by Prashanthi Kairuppala (JIRA)
[ https://issues.jboss.org/browse/TEIID-3740?page=com.atlassian.jira.plugin... ]
Prashanthi Kairuppala commented on TEIID-3740:
----------------------------------------------
Hi steven,
I have removed the columns from source table that i am not inserting.
Now i get the below error:
{
"error": {
"code": "ServerErrorException",
"message": {
"lang": "en-US",
"value": "TEIID30504 LdapSource2: no column in insert statement with source name DN - must be present and set to distinguishedName for new record"
}
}
}
Should i add any extra column?
Thanks,
Prashanthi.
> ldap post
> ---------
>
> Key: TEIID-3740
> URL: https://issues.jboss.org/browse/TEIID-3740
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Prashanthi Kairuppala
> Assignee: Steven Hawkins
> Attachments: testDelete.vdb
>
>
> 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": {
> "code": "ServerErrorException",
> "message": {
> "lang": "en-US",
> "value": "TEIID30492 TEIID30061 Insert is not allowed on the view LdapView.\"user\". A procedure may be needed to handle the Insert since: The query defining an updatable view has no valid target for INSERTs."
> }
> }
> }
>
> My virtual table is a simple (select * from table) statement. and "Suports update" is checked for source and view. VDB file attached for reference
> how do i make a successful post?
> Thanks in advance,
> Prashanthi
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-3727) Add a latest version of the salesforce connectivity to the server kit
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3727?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3727.
-----------------------------------
Resolution: Done
Updated the docs and added a deprecation notice about the v 22 support. When it's dropped we may keep using the "salesforce" resource adapter / translator name, but make it point to v 34 instead.
> Add a latest version of the salesforce connectivity to the server kit
> ---------------------------------------------------------------------
>
> Key: TEIID-3727
> URL: https://issues.jboss.org/browse/TEIID-3727
> Project: Teiid
> Issue Type: Feature Request
> Components: Salesforce Connector, Server
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> For convenience it would be good to offer a latest salesforce version, rather than requiring users to build a new translator/resource adapter. We can also deprecate the v22 connectivity then.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-3740) ldap post
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3740?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3740:
---------------------------------------
Designer should be showing the full list of validation problems with insert:
The updatable view query does not project the column LdapSource.users.orclisenabled, which is required to make LdapSource.users a target of INSERT operations., The updatable view query does not project the column LdapSource.users.useragreement, which is required to make LdapSource.users a target of INSERT operations., The updatable view query does not project the column LdapSource.users.title, which is required to make LdapSource.users a target of INSERT operations., ...
In other words there are a lot of columns on the source table that are not defaultable / nullable, that are not exposed by the view, so the target is considered non-updatable.
I can also see where we should be showing a fuller report on the server side.
> ldap post
> ---------
>
> Key: TEIID-3740
> URL: https://issues.jboss.org/browse/TEIID-3740
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Prashanthi Kairuppala
> Assignee: Steven Hawkins
> Attachments: testDelete.vdb
>
>
> 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": {
> "code": "ServerErrorException",
> "message": {
> "lang": "en-US",
> "value": "TEIID30492 TEIID30061 Insert is not allowed on the view LdapView.\"user\". A procedure may be needed to handle the Insert since: The query defining an updatable view has no valid target for INSERTs."
> }
> }
> }
>
> My virtual table is a simple (select * from table) statement. and "Suports update" is checked for source and view. VDB file attached for reference
> how do i make a successful post?
> Thanks in advance,
> Prashanthi
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-3740) ldap post
by Prashanthi Kairuppala (JIRA)
Prashanthi Kairuppala created TEIID-3740:
--------------------------------------------
Summary: ldap post
Key: TEIID-3740
URL: https://issues.jboss.org/browse/TEIID-3740
Project: Teiid
Issue Type: Feature Request
Reporter: Prashanthi Kairuppala
Assignee: Steven Hawkins
Attachments: testDelete.vdb
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": {
"code": "ServerErrorException",
"message": {
"lang": "en-US",
"value": "TEIID30492 TEIID30061 Insert is not allowed on the view LdapView.\"user\". A procedure may be needed to handle the Insert since: The query defining an updatable view has no valid target for INSERTs."
}
}
}
My virtual table is a simple (select * from table) statement. and "Suports update" is checked for source and view. VDB file attached for reference
how do i make a successful post?
Thanks in advance,
Prashanthi
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-3739) Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3739?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3739:
-------------------------------------
[~dsteigne] I should have read it completely before replying ;) , I thought I did the redeploy of the top level VDB, but it is other way around. So, what Steve saying is correct.
> Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-3739
> URL: https://issues.jboss.org/browse/TEIID-3739
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.7.1.6_2
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Attachments: dynovdb1-vdb.xml, dynovdb2-vdb.xml
>
>
> When using a Dynamic VDB that imports another VDB it isn't redeployed if the imported VDB is redeployed. You can in the log it undeploys the top VDB and the imported VDB but only redeploys the imported one. The top VDB then doesn't exist until it's redeployed.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-3739) Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIID-3739?page=com.atlassian.jira.plugin... ]
Debbie Steigner commented on TEIID-3739:
----------------------------------------
Ramesh,
In regards to their use case, they are using all Dynamic VDBs, so they have one for each Physical Model and then create a top level Dynamic VDB that imports all the physicals and creates their views on top. If you want their VDBs I can send them to you.
> Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-3739
> URL: https://issues.jboss.org/browse/TEIID-3739
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.7.1.6_2
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Attachments: dynovdb1-vdb.xml, dynovdb2-vdb.xml
>
>
> When using a Dynamic VDB that imports another VDB it isn't redeployed if the imported VDB is redeployed. You can in the log it undeploys the top VDB and the imported VDB but only redeploys the imported one. The top VDB then doesn't exist until it's redeployed.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIID-2729) Dynamic VDB xml requires sibling elements to be in a certain order
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2729?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-2729:
-----------------------------------
Assignee: (was: Steven Hawkins)
Reopening for consideration in 8.12.x
> Dynamic VDB xml requires sibling elements to be in a certain order
> ------------------------------------------------------------------
>
> Key: TEIID-2729
> URL: https://issues.jboss.org/browse/TEIID-2729
> Project: Teiid
> Issue Type: Enhancement
> Components: AdminApi
> Affects Versions: 8.5
> Reporter: Mark Drilling
>
> In my *-vdb.xml, I have a model defined per following snippet:
> <model name="myModel" type="PHYSICAL" visible="true">
> <source name="myModel" translator-name="hive" connection-jndi-name="Hive12Src" />
> <property name="trimColumnNames" value="true" />
> </model>
> The vdb.xml failed to parse, so I moved the <property> element ahead of <source> and then it worked.
> I don't think element ordering should matter in this case?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months