[teiid-issues] [JBoss JIRA] (TEIID-3740) ldap post
[
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)