-
1. Re: ldap post
shawkins Oct 2, 2015 8:51 AM (in response to prashanthi1)Is the ldap source table marked as updatable?
> "A procedure may be needed" - is the procedure an update procedure?
Yes, it means that an instead of insert trigger with a procedure could be needed. But given you have a simple transformation, it should be that the source table is not marked as updatable.
-
2. Re: ldap post
prashanthi1 Oct 2, 2015 9:01 AM (in response to shawkins)Hi Steven,
Thanks for your reply.
I have checked the "Supports Update" checkbox to true and i still get the error.
-Prashanthi.
-
3. Re: ldap post
shawkins Oct 2, 2015 9:13 AM (in response to prashanthi1)> I have checked the "Supports Update" checkbox to true and i still get the error.
If supports update is true on both the view and the source table, and you have a simple transformation, then it should work as expected. The exception still makes it seem as if the source table is not updatable.
You could turn up the server log level and see if there is any relevant information in the logs. Or provide a reproducing vdb.
-
4. Re: ldap post
prashanthi1 Oct 2, 2015 9:31 AM (in response to shawkins)Hi Steven,
I am unable to attach a vdb here. it gives option to attach image or video.
-Prashanthi
-
5. Re: ldap post
shawkins Oct 2, 2015 9:51 AM (in response to prashanthi1)You can also open an issue. What happens if over JDBC you directly issue your insert against the view?
-
6. Re: ldap post
prashanthi1 Oct 2, 2015 9:57 AM (in response to shawkins)I get the same error even if i try to insert from JDBC.
I read from this document - .Teiid Designer User Guide that for insert in to ldap we need to make some additional changes. but i am not getting it write in my table.
Please let me know if i need to make any additional changes other than what is mentioned in this document. I would open also open an issue for this.
-Prashanthi.
-
7. Re: ldap post
shawkins Oct 2, 2015 10:00 AM (in response to prashanthi1)As long as the view and the source table are marked as updatable, then you should be getting past this error.
-
8. Re: ldap post
prashanthi1 Oct 2, 2015 10:04 AM (in response to shawkins)Hi Steven,
I have opened and issue fro this - [TEIID-3740] ldap post - JBoss Issue Tracker
Thanks,
Prashanthi.